cannot create a recordset object for a link table

  • Thread starter Thread starter tedpottel
  • Start date Start date
T

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
 
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,
 
Back
Top