Would really like some help with this as it is driving me insane.
I have an access database which is linked via ODBC to SQL Server.
I create an SQL string in access and create a connection.
I then use the line:
Set rst = connodbc.openrecordset(SQLString)
Usually it works but at times I get the message:
Run Time error 3669
Execution Cancelled
Can anyone tell me why this is. It would make my day so much better.
Thanks
