Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

I can't open ms access 2003

Discussion in 'Information Technology' started by Jose Perdigao, Jul 28, 2006.

Tags:
  1. Jose Perdigao

    Jose Perdigao
    Expand Collapse
    Guest

    Hi,

    I created a new account in windows XP without administrator privileges.

    When I opened the ms access 2003 I was surprised, it opens ready only.

    What can I do to open ms access for the users that doesn't have
    administrator permissions?



    Thanks a lot,

    JP
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Jose Perdigao wrote:
    > Hi,
    >
    > I created a new account in windows XP without administrator
    > privileges.
    > When I opened the ms access 2003 I was surprised, it opens ready only.
    >
    > What can I do to open ms access for the users that doesn't have
    > administrator permissions?
    >
    >
    >
    > Thanks a lot,
    >
    > JP


    Take a look at the MDB or MDE file and look at the file properties. Is
    it read only? If so you need to change it.

    Next look at the directory in which the file is located. You MUST have
    read, write, delete and create privileges in that directory. Your new
    account must have all those rights.


    --
    Joseph Meehan

    Dia duit
     
  4. Jose Perdigao

    Jose Perdigao
    Expand Collapse
    Guest

    The mde file is not read only and the folder is dull permissions.
    If I open the file as administrator account I don't have problem, the ms
    access file is not read only. If I open the account not as administrator the
    ms access file is opened as read only.

    Do you have any suggestion? Why if the account is not administrator the ms
    access file open as read only? I opened the Northwind.mdb and is the same,
    it open as read only; if I change the account for user administrator, it
    open without problems.

    Thanks,
    José Perdigão


    "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    news:%23kEz9qVnGHA.3436@TK2MSFTNGP02.phx.gbl...
    > Hi,
    >
    > I created a new account in windows XP without administrator privileges.
    >
    > When I opened the ms access 2003 I was surprised, it opens ready only.
    >
    > What can I do to open ms access for the users that doesn't have
    > administrator permissions?
    >
    >
    >
    > Thanks a lot,
    >
    > JP
    >
    >
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Jose Perdigao wrote:
    > The mde file is not read only and the folder is dull permissions.
    > If I open the file as administrator account I don't have problem, the
    > ms access file is not read only. If I open the account not as
    > administrator the ms access file is opened as read only.
    >
    > Do you have any suggestion? Why if the account is not administrator
    > the ms access file open as read only? I opened the Northwind.mdb and
    > is the same, it open as read only; if I change the account for user
    > administrator, it open without problems.
    >
    > Thanks,
    > José Perdigão


    Has user level security been applied to the database? Does the database
    link to any other data sources? Is it a split database?


    >
    >
    > "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    > news:%23kEz9qVnGHA.3436@TK2MSFTNGP02.phx.gbl...
    >> Hi,
    >>
    >> I created a new account in windows XP without administrator
    >> privileges. When I opened the ms access 2003 I was surprised, it opens
    >> ready
    >> only. What can I do to open ms access for the users that doesn't have
    >> administrator permissions?
    >>
    >>
    >>
    >> Thanks a lot,
    >>
    >> JP


    --
    Joseph Meehan

    Dia duit
     
  6. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    Permissions are handled by the operating system, Windows XP.

    If your application is read-only, you need to change the
    permissions in Windows XP.

    If you are confused by the permissions in Windows XP, you
    have come to the wrong place, because we really only know
    about Access.

    What we can tell you about Access is that those permissions
    are handled by the operating system, Windows XP.

    I do not know what the difference is between your Users
    Accounts and your Administrator Account.

    You may find it easier to test if you use a text file
    and Word or Notepad instead of using a database.

    When you have a text file that is not read only, your
    database will not be read only.

    (david)


    "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    news:%23LxXJDanGHA.4868@TK2MSFTNGP02.phx.gbl...
    > The mde file is not read only and the folder is dull permissions.
    > If I open the file as administrator account I don't have problem, the ms
    > access file is not read only. If I open the account not as administrator
    > the ms access file is opened as read only.
    >
    > Do you have any suggestion? Why if the account is not administrator the ms
    > access file open as read only? I opened the Northwind.mdb and is the same,
    > it open as read only; if I change the account for user administrator, it
    > open without problems.
    >
    > Thanks,
    > José Perdigão
    >
    >
    > "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    > news:%23kEz9qVnGHA.3436@TK2MSFTNGP02.phx.gbl...
    >> Hi,
    >>
    >> I created a new account in windows XP without administrator privileges.
    >>
    >> When I opened the ms access 2003 I was surprised, it opens ready only.
    >>
    >> What can I do to open ms access for the users that doesn't have
    >> administrator permissions?
    >>
    >>
    >>
    >> Thanks a lot,
    >>
    >> JP
    >>
    >>

    >
    >
     
  7. Jose Perdigao

    Jose Perdigao
    Expand Collapse
    Guest

    Split and not split database is the same.
    When I open word document or excel file, I don't have problem, I mean, I
    open and I can edit.
    Access files I open read only.



    "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    news:6rNpg.4601$u11.4361@tornado.ohiordc.rr.com...
    > Jose Perdigao wrote:
    >> The mde file is not read only and the folder is dull permissions.
    >> If I open the file as administrator account I don't have problem, the
    >> ms access file is not read only. If I open the account not as
    >> administrator the ms access file is opened as read only.
    >>
    >> Do you have any suggestion? Why if the account is not administrator
    >> the ms access file open as read only? I opened the Northwind.mdb and
    >> is the same, it open as read only; if I change the account for user
    >> administrator, it open without problems.
    >>
    >> Thanks,
    >> José Perdigão

    >
    > Has user level security been applied to the database? Does the
    > database link to any other data sources? Is it a split database?
    >
    >
    >>
    >>
    >> "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    >> news:%23kEz9qVnGHA.3436@TK2MSFTNGP02.phx.gbl...
    >>> Hi,
    >>>
    >>> I created a new account in windows XP without administrator
    >>> privileges. When I opened the ms access 2003 I was surprised, it opens
    >>> ready
    >>> only. What can I do to open ms access for the users that doesn't have
    >>> administrator permissions?
    >>>
    >>>
    >>>
    >>> Thanks a lot,
    >>>
    >>> JP

    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
     
  8. Jose Perdigao

    Jose Perdigao
    Expand Collapse
    Guest

    When we create accont in windows xp, we can create as administrator and not
    administrator.
    As administrator I don't have problem, as not administrator I have this
    problem, access file is opened read only.

    I post this question here because word document, excel file and another
    files I don't have this problem.
    I think here I could receive help.

    JP

    "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
    news:uGO3ORcnGHA.2148@TK2MSFTNGP03.phx.gbl...
    > Permissions are handled by the operating system, Windows XP.
    >
    > If your application is read-only, you need to change the
    > permissions in Windows XP.
    >
    > If you are confused by the permissions in Windows XP, you
    > have come to the wrong place, because we really only know
    > about Access.
    >
    > What we can tell you about Access is that those permissions
    > are handled by the operating system, Windows XP.
    >
    > I do not know what the difference is between your Users
    > Accounts and your Administrator Account.
    >
    > You may find it easier to test if you use a text file
    > and Word or Notepad instead of using a database.
    >
    > When you have a text file that is not read only, your
    > database will not be read only.
    >
    > (david)
    >
    >
    > "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    > news:%23LxXJDanGHA.4868@TK2MSFTNGP02.phx.gbl...
    >> The mde file is not read only and the folder is dull permissions.
    >> If I open the file as administrator account I don't have problem, the ms
    >> access file is not read only. If I open the account not as administrator
    >> the ms access file is opened as read only.
    >>
    >> Do you have any suggestion? Why if the account is not administrator the
    >> ms access file open as read only? I opened the Northwind.mdb and is the
    >> same, it open as read only; if I change the account for user
    >> administrator, it open without problems.
    >>
    >> Thanks,
    >> José Perdigão
    >>
    >>
    >> "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    >> news:%23kEz9qVnGHA.3436@TK2MSFTNGP02.phx.gbl...
    >>> Hi,
    >>>
    >>> I created a new account in windows XP without administrator privileges.
    >>>
    >>> When I opened the ms access 2003 I was surprised, it opens ready only.
    >>>
    >>> What can I do to open ms access for the users that doesn't have
    >>> administrator permissions?
    >>>
    >>>
    >>>
    >>> Thanks a lot,
    >>>
    >>> JP
    >>>
    >>>

    >>
    >>

    >
    >
     
  9. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Jose Perdigao wrote:
    > Split and not split database is the same.
    > When I open word document or excel file, I don't have problem, I
    > mean, I open and I can edit.
    > Access files I open read only.


    Can you save your edits in Word? Can you make a new file in Word and
    can you delete that new file in Word?


    >
    >
    >
    > "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    > news:6rNpg.4601$u11.4361@tornado.ohiordc.rr.com...
    >> Jose Perdigao wrote:
    >>> The mde file is not read only and the folder is dull permissions.
    >>> If I open the file as administrator account I don't have problem,
    >>> the ms access file is not read only. If I open the account not as
    >>> administrator the ms access file is opened as read only.
    >>>
    >>> Do you have any suggestion? Why if the account is not administrator
    >>> the ms access file open as read only? I opened the Northwind.mdb and
    >>> is the same, it open as read only; if I change the account for user
    >>> administrator, it open without problems.
    >>>
    >>> Thanks,
    >>> José Perdigão

    >>
    >> Has user level security been applied to the database? Does the
    >> database link to any other data sources? Is it a split database?
    >>
    >>
    >>>
    >>>
    >>> "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    >>> news:%23kEz9qVnGHA.3436@TK2MSFTNGP02.phx.gbl...
    >>>> Hi,
    >>>>
    >>>> I created a new account in windows XP without administrator
    >>>> privileges. When I opened the ms access 2003 I was surprised, it
    >>>> opens ready
    >>>> only. What can I do to open ms access for the users that doesn't
    >>>> have administrator permissions?
    >>>>
    >>>>
    >>>>
    >>>> Thanks a lot,
    >>>>
    >>>> JP

    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit


    --
    Joseph Meehan

    Dia duit
     
  10. Jose Perdigao

    Jose Perdigao
    Expand Collapse
    Guest

    I can edit, save, delete files, I can do every thing in word or excel.
    I change computer I created new account as not administrator it happens the
    same.
    I don't know if is a ms access problem or windows xp problem.
    If I logon an account as administrator and I open the same access file, I
    don't have problem.

    Sugesttions?

    "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    news:RtTpg.9222$vl5.991@tornado.ohiordc.rr.com...
    > Jose Perdigao wrote:
    >> Split and not split database is the same.
    >> When I open word document or excel file, I don't have problem, I
    >> mean, I open and I can edit.
    >> Access files I open read only.

    >
    > Can you save your edits in Word? Can you make a new file in Word and
    > can you delete that new file in Word?
    >
    >
    >>
    >>
    >>
    >> "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    >> news:6rNpg.4601$u11.4361@tornado.ohiordc.rr.com...
    >>> Jose Perdigao wrote:
    >>>> The mde file is not read only and the folder is dull permissions.
    >>>> If I open the file as administrator account I don't have problem,
    >>>> the ms access file is not read only. If I open the account not as
    >>>> administrator the ms access file is opened as read only.
    >>>>
    >>>> Do you have any suggestion? Why if the account is not administrator
    >>>> the ms access file open as read only? I opened the Northwind.mdb and
    >>>> is the same, it open as read only; if I change the account for user
    >>>> administrator, it open without problems.
    >>>>
    >>>> Thanks,
    >>>> José Perdigão
    >>>
    >>> Has user level security been applied to the database? Does the
    >>> database link to any other data sources? Is it a split database?
    >>>
    >>>
    >>>>
    >>>>
    >>>> "Jose Perdigao" <perdijc@hotmail.com> wrote in message
    >>>> news:%23kEz9qVnGHA.3436@TK2MSFTNGP02.phx.gbl...
    >>>>> Hi,
    >>>>>
    >>>>> I created a new account in windows XP without administrator
    >>>>> privileges. When I opened the ms access 2003 I was surprised, it
    >>>>> opens ready
    >>>>> only. What can I do to open ms access for the users that doesn't
    >>>>> have administrator permissions?
    >>>>>
    >>>>>
    >>>>>
    >>>>> Thanks a lot,
    >>>>>
    >>>>> JP
    >>>
    >>> --
    >>> Joseph Meehan
    >>>
    >>> Dia duit

    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
     
  11. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Jose Perdigao wrote:
    > I can edit, save, delete files, I can do every thing in word or excel.
    > I change computer I created new account as not administrator it
    > happens the same.
    > I don't know if is a ms access problem or windows xp problem.
    > If I logon an account as administrator and I open the same access
    > file, I don't have problem.
    >
    > Sugesttions?
    >


    Sorry I am out of suggestions. I seem to recall someone else having a
    like problem and someone helped them out, but I fear my memory is fuzzy.

    --
    Joseph Meehan

    Dia duit
     

Share This Page