Link tables using VBA question...

[hollifd]

I have a back end database holding tables of data and a front end database holding forms, queries and reports etc.

Users currently click on a batch file on their desktops that will copy down the front end to their C:Temp folder and then start the database which is linked to the back end on the network.

My problem...
The front end database has linked tables to the back end database. The link spells out the network location of the backend database like U:NCCODE......etc.

Some users are mapped to this network drive using a drive letter different than "U:"

My thought was to somehow link the tables using VBA and spelling out the drive connection like \dbdenccode......etc hoping that this would work regardless of what letter the users have mapped to.

Does any of this make sense to anyone? Does this idea sound like it could be a solution or is there a better way. Can anyone point me in the right direction about how to link the tables using VBA?

Thanks for any help you can offer,

David

 

[parry]

This looks to be the ticket ... http://www.mvps.org/access/tables/tbl0009.htm

Dont ask me to interpret it though! Hopefully you can just change a couple of params and your away.

Good luck.

 

[hollifd]

Thanks Parry,

I will have a look at that to see if I can figure it out.

David

 

[parry]

Hi, just as a matter of interest did you use the code in that link and did it work? Might need to do that myself one of these days

 

[hollifd]

Parry,

I did use the code after some modifications and was able to make it work. I have to admit though, that I do not fully understand how it works. If you need an explanation of how I made it work, just let me know and I can send you some info.

Thanks for your time and pointing me in the right direction.

David