Chris,
Thanks for the repsone. It makes perfect sense. Sorry but I am new to
working with a split a database. I asked the user to put a copy of the FE on
their local machine and everything works fine. Thanks again!!!

"Chris O'C via AccessMonster.com" wrote:

By having everyone share the same front end file, you defeat the purpose of
splitting the database. Place a copy of the front end on every user's PC and
have each user only open their own copy. They will each have exclusive
access on their own copy whenever needed.

Chris
Microsoft MVP


Maldo wrote:
I have a Multiuser data entry mdb (built in Access 2003) split between FE and
BE. Both FE and BE reside on network directory. Each user has read/write
access to the network drive. I have a start up form with the datasource
being a table linked to the BE. My Start up options have all menus and
toolbars turned off. Under my OptionsAdvanced tab the default open mode is
set to Shared for FE and BE mdb's. Record locking is set to No Locks. Some
of the users have seen this message pop up at start up -- "You do not have
exclusive access to the database at this time. If you proceed to make
changes, you may not be able to save them later." I have a moderate level of
vba event procedures behind the form including a MouseHook function that
disables the mouse wheel to prevent users from scrolling through existing
records. I don't think there is anything wrong with my code so I don't know
where else I can begin trouble shooting this issue as it only seems to be
happening for a few users. Can anyone offer some guidance? Thanks!!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1