How do I create/change a form in a multiuser environment?

[SteveRSX]

Hi,

I have a small Access dB that 20 users Access at the same time. Everyone opens it in shared mode. The problem I have is that when there is another user in the dB, I cannot change any of my existing form, or even create a new one. I always a get a "You do not have exclusive Access to the dB at this time". Is there a way around this?

This situation only occurs for forms. Queries and reports are no problem.

Thanks

 

[KenReay]

Hi

Usual way around this is to split the database into two.

A Front end (FE) which contains the Forms, Reports, Queries etc, and has links to the Back end (BE) which contains the tables.

The FE is located on each users C: drive, the BE is on a network share.

Then you can take a copy of the FE, make your changes away from the 'live' situation. When you have made changes and tested (using a test version of the BE), you put the tested FE on each Users PC, and link tables to the live BE
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[MelissaT]

I have several databases that are multi-user. A FE/BE will work, if you want to spend time going and putting that FE back on 20 PCs. Personally, I think it would be a pain. No offense Ken. In my department we keep two copies of our databases, one that the users see and one just for ourselves. If you have changes to make, just make them on your copy and then you can apply them quickly all at once. Just don't copy over the entire DB, though. Import your changed queries, forms, reports, macros, or modules. Tables you would be best to make the changes live, or you might accidently overwrite their data. You would have to have all of your users get out, but I have found, that if you are doing something to a database that is going to benefit the users, they don't mind getting out of it for a minute or two.

Hope this helps.

 

[MichaelRed]

First, you need to have the db split.

Next, the overall issue has been discussed in these forums in the past. A few of the threads are listed below. Feel free to search for additional references.

thread181-30072
thread705-96536
Thread181-83809
Thread181-84496

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over