Edit Database

[David]

I would like to update certain forms in my database while data entry is
going on. Is it possible to do this? I keep getting an error saying that I
don't have exclusive access.

 

[Jeff Boyce]

David

Does this mean you have only a single copy of the database, used by
everyone? If so, consider "splitting" your database into a back-end,
containing only the data (and living on your network), and a front-end, a
copy of which lives on EACH user's PC.

This way, you can be working on changes to forms and other (non-data-table)
objects in YOUR copy without affecting anyone else's use of the application.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[David]

Hmm very good idea. I will give it a shot. I hope its not too much
conversion to make this happen. Any advice or information on how to do this
would be greatly appreciated.

Thanks Jeff!

 

[Jeff Boyce]

David

Splitting is quite easy.

Make a copy of the db.

In one of the two copies, delete all the tables. Then use File | Get
External ... | Link ... and link to the tables in the other db.

In the other copy, delete everything BUT the tables.

It's split!

(You can also give the Database Splitter wizard a try, if that seems like
too much work.)

Consider doing a bit of searching at Google.com or otherwise on "MS Access"
and "split".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[David]

Works Great!!!! Thanks Jeff! I used the wizard. It was too easy. Now i
can do what I have to do anytime. I love it!

Dave