want to use opendatabase for sql server linked tables

[diamondsc]

I have an Access 2000 app with linked data tables from an Access 2000 database. I use the following to open this database:

Dim dbs As Database
Set dbs = OpenDatabase("\\billingsvr\mbdata\mbData.mdb&quot

Billingsvr is the Windows 2000 Server and mbdata is the folder where the database resides. We are going to upgrade to SQL Server 2000. The name of the sql server instance will be something like sqlbillingsvr and the database name will be mbData.

How would the OpenDatabase line read for this?

 

[dhookom]

I doubt you can open an SQL database/table using OpenDatabase. Depending on what you plan on doing with the data, you should consider using ADO which is much more appropriate than DAO.

Duane
MS Access MVP