Connecting Tech Pros Worldwide Forums | Help | Site Map

Database opens as READ ONLY

Tom
Guest
 
Posts: n/a
#1: Nov 13 '05
Just upgraded my old Access 97 DB to Access 2003. It is on a shiny new XP
Pro box. ON the new computer there is my domain administrator account and a
regular user account. If I open the DB in the Admin account, everything
works fine. If I open in the User account, I get a message telling me the
DB is in a read only mode and several of the update forms in the DB do not
work.

I prefer to have the users log in to their own account rather that have
everyone have domain admin permissions. How do I get this db to open
correctly. I have tried the "Runas" command and it didn't work.

Please help
Thanx
Tom



Rick Brandt
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Database opens as READ ONLY


"Tom" <harristomm@hotmail.com> wrote in message
news:HuD3d.2500$Ae.852@newsread1.dllstx09.us.to.ve rio.net...[color=blue]
> Just upgraded my old Access 97 DB to Access 2003. It is on a shiny new[/color]
XP[color=blue]
> Pro box. ON the new computer there is my domain administrator account[/color]
and a[color=blue]
> regular user account. If I open the DB in the Admin account, everything
> works fine. If I open in the User account, I get a message telling me[/color]
the[color=blue]
> DB is in a read only mode and several of the update forms in the DB do[/color]
not[color=blue]
> work.
>
> I prefer to have the users log in to their own account rather that have
> everyone have domain admin permissions. How do I get this db to open
> correctly. I have tried the "Runas" command and it didn't work.[/color]

The database needs to reside in a folder that the user has full permissions
on. They need file create, edit, and delete authority on that folder.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Closed Thread