Hi there,

I have a VB6 program connected to Access 97. I migrated access 97 into SQL server 2000 and i am now in the process of linking SQL server 2000 database with VB6. I used the connection string and it seems to be working.

My problem is VB6 code uses opentable method to open access 97 tables. This has been used in many times in the code and i need to know how i can use the same code to SQL server 2000.
For example, at present it uses

Set MyTable1 = MyDb.OpenTable("client") for Access 97. How can i do the same for SQL server 2000?

I am very new to SQL server and i really appriciate u r help!

Thank you very much...

Perhaps you can also post this in the VB Databases area, or even in the SQL server area to get more responses.

HTH

mmcdonal