db.OpenRecordset with linked tables
Posted on 2002-07-10
I am running code that updates tables using the following:
Set rs = db.OpenRecordset("tblVendorNames1", DB_OPEN_TABLE)
I have what to me is an interesting problem. When I try to use this code with linked tables I get run time error 3219 Invalid Operation. When ever I try to use this with tables located in the front end it works fine. I would like to keep all my tables located in the back end. How can I get this to work with linked tables?