B
Barry George
Greetings,
I am in the process of upgrading an Access application from Access 2000 to
Access 2007 with a backend going from sqlServer 7 to sqlServer 2005.
In the following example, at the .delete statement I get an error stating;
"Could not find server "SERVERName" in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
The code is supposed to delete all the records from a table and has nothing
to do with a
linked server.
The connection "cnn" has already been established elsewhere.
Dim rs as new adodb.recordset
rs.open "rsTable", cnn, adOpenDynamic, adLockOptimistic
With rs
.Movefirst
Do
.Delete 'Execution stops here.
.movenext
if .eof then exit do
Loop
End with
P.S. This code works with Access 2007 connected to the sqlServer 7 data, but
not the sqlServer 2005 data.
Any suggestions would be greatly appreciated.
I am in the process of upgrading an Access application from Access 2000 to
Access 2007 with a backend going from sqlServer 7 to sqlServer 2005.
In the following example, at the .delete statement I get an error stating;
"Could not find server "SERVERName" in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
The code is supposed to delete all the records from a table and has nothing
to do with a
linked server.
The connection "cnn" has already been established elsewhere.
Dim rs as new adodb.recordset
rs.open "rsTable", cnn, adOpenDynamic, adLockOptimistic
With rs
.Movefirst
Do
.Delete 'Execution stops here.
.movenext
if .eof then exit do
Loop
End with
P.S. This code works with Access 2007 connected to the sqlServer 7 data, but
not the sqlServer 2005 data.
Any suggestions would be greatly appreciated.