vba Set openRecordSet Linked SQL table

Question

I have written some code in access 2013 to open the Global Address List in outlook and when I select names it uploads the information to my table in access. It works when using a table in Access but when I switch to a Linked sql table the Set rst = CurrentDb.OpenRecordset("Employees") gives me a error. I am assuming because it is a Linked SQL table.

Answer 1

I tried again and it worked. The only thing I can figure out is if the table is open it won't work but if I close the table it works. Guess I will need to run a test to see if is open then close it before the

Set rst = CurrentDb.OpenRecordset("Employees") command.

Answer 2

Still you're not giving us (and the wider community finding your issue later, and looking for a solution) the verbatim error message :-(

Your code:

Set rst = CurrentDb.OpenRecordset("Employees")

will work. I am assuming Employees is a linked SQL Server table.

As you probably know, your line is equivalent to:

Set rst = CurrentDb.OpenRecordset("Employees", dbOpenDynaset)

I prefer that, because it is more explicit that you intend to edit data in this recordset, not just read it.

Did you re-link the table using the Linked Table Manager?

Answer 3

No I have a primary key that's not it. I worked around it just edited the form I am on it works fine now. but would like to know how to open a record set for a linked SQL table which I will need to know how to do still for some other task.

Answer 4

Please quote error messages verbatim.

Perhaps you don't have a Primary Key in your SQL table?