access at tlcbc.com.au
access at tlcbc.com.au
Wed Nov 5 20:02:58 CST 2003
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)