Can you control the Linked Table Manager using VBA 1

[WantsToLearn]

I have a client who runs 2 separate businesses on 2 databases on the same SQL Server. Everything is identical except the data. He is using Access as the front end to the data. The only difference between the Access databases is the SQL Server database to which it is being connected.

To avoid making duplicate changes, I would like to set the DSN?? when the database is opened. I found the following:

DoCmd.RunCommand acCmdLinkedTableManager but I don't know hwo to set it up. Can anyone help me? Thanks!

 

[PHV]

Take a look here:

http://www.peterssoftware.com/tlk.htm

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[WantsToLearn]

Thanks! There is some nice stuff there.