OpenRecordset on backend tables Help!

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
 
T

Ted

I'm not sure that you can use the dbOpenTable type for a
linked table. You may want to try dbOpenDynaset.
 
D

Dirk Goldgar

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.
 
Y

yves

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Message from Access 2007 on sub function 3
How do I set up openrecordset with the table as a variable? 2
A openrecordset question 1
combine code for one button 7
OpenRecordset - Run-time error '13' 3
Type mismatch when opening recordset 5
qty in table1 minus qty in table2 equal to result column in table2 2
Do I need a Nested Loop? 14

Top