Linking Tables without opening the Access Database Screen

[Marcel Stoop]

Hi

- I'm using MS SQL Server as back-End DB

Normally if you want to link an Access Application to a SQL BE Database, you
would open the Database Screen, and use the Funktionality of Linking a
Database.

In my Access Application, I do not want the user to open the Database
Screen, but still it should be possible for the user to create some linked
Tables.

So I would like to make a build-in functionality for linking Tables.
Is it possible to get access to the "Linking Table Screen", or is it in an
other way possible to achieve this goal.

Thanks for the help

Cheers
Marcel

 

[SusanV]

Hi Marcel,

Take a look here:
http://p2p.wrox.com/topic.asp?TOPIC_ID=33788

 

[Marcel Stoop]

Thanks for the Answer,

In the mean While I found what I was looking for: DoCmd.RunCommand
acCmdLinkTables

Cheers
Marcel