OpenRecordset on backend tables Help!

  • Thread starter Thread starter yves
  • Start date Start date
Y

yves

I've just splitted in front and back end (access2000)
TableClient is now a linked table "C:\data\Backend.mdb"
and the following code gives the error Run-time error '3219': Invalid
operation

Dim dbs As Database
Set dbs = CurrentDb
Dim rst As Recordset
Set rst = dbs.OpenRecordset("TableClient", dbOpenTable)

can anybody correct it or tell me if I need to change the database or method
or dbengine or whatever workspace , connection

Thanks and happy new year everyone
Yves
 
I'm not sure that you can use the dbOpenTable type for a
linked table. You may want to try dbOpenDynaset.
 
Ted said:
I'm not sure that you can use the dbOpenTable type for a
linked table. You may want to try dbOpenDynaset.
Click to expand...

Quite right. Note that you can't use the Seek method on a dynaset, so
if you were opening as a table-type recordset specifically so that you
could use that method, you'll have revise your code.
 
Many thanks both of you!
everything up and running now
Dirk, I don't quite understand all that you said, but I'll do what it takes
to understand

All the best!

Yves
 
Back
Top