Please help a novice!

[sabavno]

Hi all,

I have this problem that I have to solve, but since I am not experienced in this topic, I came here to ask for the help.

I have an application (Access 97), residing on our sharedrive(all machines are NT stations). Application has linked table (linked to another sharedrive).

What I want to do is once my application has been open, I want to map the user's machine (the user that has open my application from a sharedrive)to that drive to which my Access table is linked to.

Is it possible to perform?

Any help would be greatly appreciated.

Thanks

 

[Spirit]

Go on to the other PC, share the drive give yourself permissions to it. Go to network Neighbourhood navigate to other PC find newly shared drive right click, map network drive. Or have I missed something?

 

[sabavno]

Well, I want to be done automatically, not manually...

 

[deadeyes81]

Sabavno,

Carefull with Access. It is intended to be a single user application. If you have multiple people accessing the database at the same time it won't be long before you're spending more time fixing problems and developing code.

We use access as a front end to a sql database. In order to resolve conflicts the first thing we do is have the program copy itself out to the users' hard drive and have them run it from their own copy. Since it's just a front end it doesn't hurt anything for them to all be running a copy. We use a VB script to create the copy.