[AccessD] Re: Read-Only error message opening database

Terry,

Have you converted the MDBs from 97 to 2000.
That may be the reason they are getting me message.

Also, how are your permissions setup on SQL Server?

Have you thought of changing to ADPs?

Robert

At 02:52 AM 11/6/2003 -0600, you wrote:
>Date: Thu,  6 Nov 2003 15:02:58 +1300
>From: access at tlcbc.com.au
>Subject: [AccessD] Read-Only error message opening database
>To: accessd at databaseadvisors.com
>Message-ID: <1068084178.3fa9abd2322e1 at 210.55.105.82>
>Content-Type: text/plain; charset=ISO-8859-1
>
>
>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