-
Opening SQL Server in Visual Basic
Hi,
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)
Thanks,
Marta
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|