Link to External Database Like SQL Server, Using DAO...

[hneal98]

Does anyone know how I can link to an external database using DAO. I need to link from Access 97 to SQL Server 2000.

Thanks.

 

[scriverb]

Here are a couple of links that responded to with code to do just what you want. Take a look and if you have any more questions just get back with me for help.

thread705-488486

thread705-491733 Bob Scriver

 

[hneal98]

Thank you for your response. This is great for linking to another Access database, but I wanted to link to a SQL Server database; however, this does give me some ideas.

Thanks.