How to get data from linked table?

Question

I'm new in VBA so i don't know how to get data from linked table in ms access, But i tried some code but it show this error

"Run time error '3219' 
Invalid Operation

I already search this error everywhere but not find right answer.

Code

 Dim db As DAO.Database
 Dim db As DAO.Recordset
 Set db = CurrentDb

 Set rsHoliday = db.OpenRecordset("Holidays", dbOpenTable)
//Error Occur in this line

PaulFrancis · Accepted Answer · 2014-07-23 08:47:02Z

1

You are trying to assign a Table to a Recordset. Loose the dbOpenTable parameter from the code. It would compile just fine and do what you want. Unless you wish to open the table you need to use DoCmd.OpenTable

answered Jul 23, 2014 at 8:47

PaulFrancis

5,8191 gold badge23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ashareef Over a year ago

To add to this, dbOpenDynaset will allow for editable records and dbOpenSnapshot is a "read-only" snapshot of the data.

Collectives™ on Stack Overflow

How to get data from linked table?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related