Mutiple user access to access?

[J S]

I have an access database that I'm currently designing. I have some code
that runs in the outlook that inserts some rows into the database everytime
an email arrives. But I get an error if I'm designing the database at the
same time that the outlook code attempts to connect to the database.

The error is :

"The database has been placed in a state by user 'Admin' on machine
'computername' that prevents it from being opened or locked."

I have default open mode to be shared. Yet whenever I'm writing visual basis
code in modules in the database, I get that error.

 

[John Spencer (MVP)]

You can ONLY design when you have exclusive access to the database. That is one
of the reasons to split the data (tables) into a separate backend. Once you've
done that you won't run into problems while designing the front end (Forms,
Reports, Modules, etc). You can split the database with one of the wizards.

On line help Answer Wizard - Type "Split an Access Database" and then check the
topics returned.

On the Tools menu, point to Database Utilities, and then click Database Splitter.

Follow the instructions in the Database Splitter Wizard dialog boxes.