Question Access to multiple database in a server

[Access2007User]

I have problem connecting my Access to SQL. I have this situation wherein I am creating more than one database in a server, let us say 5 databases. How can I make a code that will use and link those tables from those 5 database into my FrontEnd?

 

[georgedwilkinson]

Why do you think you need to use code to do that? Unless you have specific needs for DSN-less connection, you should be able to do everything you need via the Access UI.

On the table tab, just right click and link all the tables you need linked.

 

[Access2007User]

I need to do automate it using vba because I am creating a frontend for the users. If going to use the DSN-less, what will be the proper code to link from all the tables from the 5 databases. Can you give me example please.

 

[georgedwilkinson]

Just about everything you could ever need is at http://www.accessmvp.com/DJSteele/DSNLessLinks.html or a link from that page.

Since I am a very lazy person, I would just manually create the links and then use Doug's code (pointed to above) to make the links DSN-less.