cannot create a recordset object for a link table

[tedpottel]

Hi,
I have a mysql dadtbase and access has a table called web_stat link to
it. I have the following code

Set dbs = CurrentDb
Set fromset = dbs.OpenRecordset("web_stat", dbOpenTable)
the 2nd line gives me a invalid operation error. It works fin if I
replace web_stat with local_stat, ie a table I created on acces.

How can I use DOA to access a link table??
Ted

 

[George Nicholson]

Check the DAO Help file, but I'm pretty sure dbOpenTable is an invalid
instruction with a linked table.

Perhaps you want dbOpenDynaset or dbOpenSnapshot? I think Dynaset is the
default with a linked table (so you could omit the argument altogether, if
that's what you want...)

HTH,

 

[Guest]

dbOpenTable only works with Access Workspaces
Try it without that option.