Multiple Users using the same Access 2002 File

M

Marcus

Is there a way for multiple Windows XP users to edit a Microsoft Access 2002
file? I have a problem where one of my users try to save a MDB file, but it
says that it can't save it because the file is open.

Also, is there a way to hide the design portion of the Access file so that
users only see the front end? (I don't want them to see the tables, queries,
forms, & reports). There is an option to hide the window but I have to do
this every time the file is opened. I was wondering if there is a more
permanent solution.

Thanks,

-Nassar
 
T

Todd Shillam

Marcus,

You need to make sure you 'split' the application into two components, a
front-end and back-end. Once you the two parts, in the front-end, just
configure the 'Startup' option not to display the database window--there's a
lot more you can do as well. For example, you can disable the ShiftKeyBypass
so your application user won't be able to use the Shift key to open the file
and display the database window. Keep the questions coming.

Todd
 
Top