Create an File to open DB (w/o exclusive access)

[jimjaix]

Hi, I would like to create setup file or some simple code to open my db without exclusive access. I Googled this kind of question, and people suggested to split the database into 2, one that points to the database table to update. How do I do something like that?

If someone has the db open and I want to modify certain thing and try to save it I get the "exclusive access" error which I do not like.

 

[dhookom]

You might want to BING "Access how to split file". The first result might help.

Duane
Hook'D on Access
MS Access MVP

 

[jimjaix]

I did, I actually split the file, is it the best way to go with the issue I am having?

 

[dhookom]

The recommended method of developing is to have your application split into the front-end and back-end files. I typically name my files like:
MySolutionName_AP.mdb (application front-end)
MySolutionName_DT.mdb (application data tables)
Each user should have their own copy of the front-end file. Keep a copy of the front-end in a personal folder where you create and modify forms, queries, reports, etc. Have some method for pushing the new front-end to users after the modifications have been tested.

Duane
Hook'D on Access
MS Access MVP

 

[jimjaix]

I named mine Intake_BE and Intake (I changed the extension from .mdb to .mde on my front end, does this do anything? I read a forum and it says do that) Both Front end and Back end are saved on the shared drive. I will create a shortcu to the front end for user's desktop.

Let's say someone is accessing the front end piece, can I access it and modify forms, queries and when they access it again they will be able to have the up dated version of it?

 

[dhookom]

Again, each user should have their own copy of the front-end. I would not "create a shortcu to the front end for user's".

Duane
Hook'D on Access
MS Access MVP

 

[jimjaix]

I see what you mean now. If everyone has a copy of the front end, I can just update my copy and replace everyones.