G
Guest
I have an Access database, running on a terminal server network. I want
multiple people to use the front end at the same time to update the SQl
server database. The problem is users get a message saying that the database
is read only. Although one would assume that they cannot update data, users
are able to update data so it seems the message refers only to database
objects. I thought perhaps it had something to do with Open Exclusive, but
the users are accessing the database from a shortcut. I'm the only one who
uses the Open Exclusive and that's when I am making changes. I make sure I
open it using the regular Open option (not exclusive) when I test the db
after making changes. Even though I have full rights, when I open the
database (if I'm not trying Open Exclusive and I'm the only one with it open)
I will get the read-only message as well.
Any help would be greatly appreciated! The users are getting frustrated
with the message pop-up.
multiple people to use the front end at the same time to update the SQl
server database. The problem is users get a message saying that the database
is read only. Although one would assume that they cannot update data, users
are able to update data so it seems the message refers only to database
objects. I thought perhaps it had something to do with Open Exclusive, but
the users are accessing the database from a shortcut. I'm the only one who
uses the Open Exclusive and that's when I am making changes. I make sure I
open it using the regular Open option (not exclusive) when I test the db
after making changes. Even though I have full rights, when I open the
database (if I'm not trying Open Exclusive and I'm the only one with it open)
I will get the read-only message as well.
Any help would be greatly appreciated! The users are getting frustrated
with the message pop-up.