Changes while users are in the database

[bestfc01]

Hi there,

I was wondering if it was possible to be able to make changes to a form whilst others are accessing different forms.

At the moment, if i am editing the database any user trying to access the database gets a error warning them, they the database is in admin.

But if another user is in the database while i am trying to change a form / report, i am unable to save.

I no the simple way to do this would be to do changes whilst no-one is in. Its just some minor tweeks need doing during the day.

 

[RainLover]

The users should be using an MDE file, while you should be designing in a MDB file.

Once you have finished updating and testing convert to mde and make it available to the users who should place a copy on their own Drive, not a shared drive on the server.

 

[bestfc01]

Thanks for prompt response.

I am using access 2007

Insturction of MDE for 2007 is to do "Database Tools" > "Database Tools" > "Make ACCBE"

When i attempt to do this i get an error saying unable to create. when i go into the "help" part it say its "
This error is usually associated with compiling a large database into an MDE file.　 Because of the method used to compile the database, a considerable number of TableID references are created for each table.　 The Access database engine can only create a maximum of 2048 open TableIDs at one time.

 

[pr2-eugin]

The other possibility for unable to create a MDE will be because there are still unresolved Compiler errors.. So before doing a MDE operation, try to run a 'Compile', make sure there are no errors.. If there are any correct them, then try again..

Also have you split the database yet?

 

[RainLover]

It looks like you have a problem with the Database.

Try the following.

Go into any module. You need to use Debug to compile the code. I don't have 2007 so if you can't find it use HELP.

Next go back to the Database and do a Compact and Repair.

If you can do both of these then you should be able to convert to ACCBE.

Question. Have you split the Database into a Front End Back End situation.

 

[bestfc01]

Many thanks this now works perfect. Has a issue with the coding i used to password protect a form. Removed this and work instandly. Thanks

 

[RainLover]

So are you set now. The discussion got changed a little from your original question.

PS. Make sure you keep backups of the MDB or ACCDB (Whatever they call it now)
These back ups must be of different stages. Do not destroy yesterday's backup by replacing it. Create a new one and change the name by adding a date.

 

[bestfc01]

All set, up and running. Seems no issues also ensure other users dont edit the database as well which to be honest is a bonus

Many thanks