G
Guest
I tried to simplify my code because my select is much longer than this, but
this is basically what I'm trying to do.
Open a recordset that I loop through looking for various items and updating
a table. This worked when I was 100% Access, but now my tables are in SQL
Server. I'm getting the message "Path/File Access Error".
I'm fairly new to SQL Server and using Access as the front end. It's been
very frustrating for me to say the least. Any assistance or thoughts would
be appreciated!
Dim db As Database
Dim strSQL As String
Dim rs As Recordset
Set db = CurrentDb()
strSQL = "SELECT "dbo_Anesth.* FROM dbo_Anesth "
Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)
this is basically what I'm trying to do.
Open a recordset that I loop through looking for various items and updating
a table. This worked when I was 100% Access, but now my tables are in SQL
Server. I'm getting the message "Path/File Access Error".
I'm fairly new to SQL Server and using Access as the front end. It's been
very frustrating for me to say the least. Any assistance or thoughts would
be appreciated!
Dim db As Database
Dim strSQL As String
Dim rs As Recordset
Set db = CurrentDb()
strSQL = "SELECT "dbo_Anesth.* FROM dbo_Anesth "
Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)