[AccessD] Read-Only error message opening database

Charlotte Foust cfoust at infostatsystems.com
Wed Nov 5 20:14:59 CST 2003


Design changes (like the paper size of a report) are handled in Access,
not in SQL Server.  Access 2000 and later do NOT allow users to make
design changes to objects unless they have exclusive access to the
database.  Since your database is being shared,  that would only be
possible if a single user was in the database.  Also, read-only access
to that folder won't work because the users need to be able to create
and/or write to the ldb file for the shared front end and to delete it
when the last person exits.

Charlotte Foust

-----Original Message-----
From: access at tlcbc.com.au [mailto:access at tlcbc.com.au] 
Sent: Wednesday, November 05, 2003 6:03 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Read-Only error message opening database



Hi!

I have just found this list so apologies if this question has been asked
before 
(couldn't see it in the archives).

We have a database that is stored on a shared network drive with the
data 
itself in an SQL Server backend.  For security reasons the majority of
users 
have read-only access to the network drive where the database is stored.
With 
Access 97 this worked fine but the database has recently been upgraded
to 
Access 2000 and now the users receive a message when they open the
database 
stating that it is read-only so they won't be able to save their changes
(which 
is incorrect as, of course, the updates are done on the SQL server which
they 
do have write access to).  Not a major problem but very annoying and
confusing 
for the users.

Does anyone know how to disable this error message under Access 2000?

Thanks,
Terry Bradford
(Canberra, Australia)


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list