split database - Taking a replica

[VPK_Access]

Hi,

I have recently split the access 2003 database and have placed this in a server. Now I wanted to take a copy of the database into my local machine and work as a different instance. so I have taken a copy of the frontend and backend database file and copied on my local machine. Then I went to the Linked Table Manager and changed the path of the table from that on the server to the one on my machine.

However now the user accessing the database from the server is also getting directed to the tables on my local machine.

Could anyone help me in telling what did I do wrong?

 

[spikepl]

Each user should have own frontend locally on own machine not on the server

 

[VPK_Access]

How do I make a a copy of the file and work from my local machine? (kind of a UAT environment).

 

[spikepl]

I don't know what you actually did, but you need to COPY both files and put them on your own machine. Some time ago I had an issue with MOVING a file (using the File Manager) because the shortcuts ppl had, followed!

Users should have own local copy of the frontend, and not run a frontend residing on a server