Disable "read-only" warning message?

  • Thread starter Thread starter tlcbc
  • Start date Start date
T

tlcbc

Guest
We have a shared MS Access 2000 front-end with SQL Server data tables. This is on a network drive and to prevent users stuffing anything up the front-end is read-only (they can still update data as this on an SQL server with appropriate permissions depending on the user). The problem is when the users open the database they get a warning message saying the database is read only so they wont be able to save changes - this confuses the users as they think they cant save any new information when they actually can.

Is there any way to disable this error message? (This database used to be Access 97 and does not give the error message under that version as we were able to modify the shortcut to include a flag which effectively disabled the warning message - that does not seem to work under Access 2000).

Any ideas would be appreciated!

Thanks,
Terry.
 
Have you tried useing a Macro?

If you create a new marco and set the WARNINGS ON value to NO this should get rid of the problem (don't forget to turn them on again afterwards...)

Then use this Macro on the form/page for the DB
________
buy vaporizer
 
Last edited:
The warning message comes up as soon as the database is opened (ie. before any macros or code is run). With Access 97 you could create a shortcut that opened the database with the /runtime option which effectively disabled the error message but this does not work with Access 2000.

Any other suggestions?
 

Users who are viewing this thread

Back
Top Bottom