Transact SQL

[Steven Marti]

How can i link in mdf-File into an adp-Project?
with wich code can i do the same as the command Datei-Verbinden-Transact
sql?

Thanks! Steven

 

[Norman Yuan]

You don't "link" anything to *.mdf file. One or more *.mdf file is used by
SQL Server. Your ADP project only connects to SQL Server.

 

[Steven Marti]

Sorry, but i like to link an mdb-File (not an mdf-File) into in adp-File,
and for this i would like to know the vb-code.
Thanks! Steven

 

[Norman Yuan]

*.ADP in MS Access is specifically designed to connect to SQL Server as a
front-end. You do not use ADP project to connect to jet database (*.mdb).
You use regular *.mdb as another *.mdb( containing tables only)'s front end
by linking the front end *.mdb to back end *.mdb.