Access to SQL Server (smart card application connection to SQL Server)

[kalvin]

I had an on going project to create a smart card application for a college here in Malaysia. I was told that MS Access would do fine as I am quite well versed in it. But now the requirements have changed and my client now wants it MS SQL Server 2000. I would appreciate it someone could let me know how to connect MS SQL Server 2000 to my VB6-compiled application. Or if anyone has a better idea on how should I overcome this please reply. I would appreciate it. Thank you.

[Vanaj]

Have you tried msdn.microsoft.com and looking at the connection strings for MSSQL Server 2000. I do believe you can d'load the Online books for SQL Server 2000.

[jp140768]

Are you using ADO to connect to Access, if so you just change the connection string.

The following will give you the connection strings:

ADO connection strings (http://www.able-consulting.com/ADO_Conn.htm)

HTH