Multiple instances of Access on one machine

[BillEchert]

Hi, I need to recreate a record locking problem users are experiencing. I currently do not have access to a network, so would like to recreate this on my machine. How do initiate multiple instances of my development version of the application on my machine?

Thanks,
Bill

 

[Aqif]

Simplest is create a split database with backend/frontend interface. You can create multiple copies of same frontend by slightly changing the names.

So you can have Frontend_1.mdb, Frontend_2.mdb and Frontend_3.mdb all opened at the same time and linked with the same backend data file MyData.mdb

How's that sound?

Cheers!
ÙÇãá

It's important to learn the rules so that you know how to break them.

 

[alvechurchdata]

How do initiate multiple instances of my development version of the application on my machine?

Open Access twice and run a copy of the application in each instance.

Testing on a single machine might not show all the record locking problems. Once you get onto a network with buffers and routers and servers and flakey network cards and users treading on cables then you get all sorts of problems with data getting mislaid and delayed.

Geoff Franklin

http://www.alvechurchdata.co.uk