Opening SQL Server in Visual Basic
I just started using SQL server today. We upsized an Access database to SQL server and now my Visual Basic program cannot open the tables. The following code works when the database is in Access. What is the proper format open a table in SQL server if I want to call it through an MS Access DB?
Public Data_Queries As Recordset
Set ClinTrack = DBEngine.Workspaces(0).OpenDatabase("R:CLINICA LPRIVATECLINTRAKTESTCLINTRAK.MDB"
Set Data_Queries = ClinTrack.OpenRecordset("Data_Queries", dbOpenTable)