Issues after splitting data tables (97)

Topic

New Reply

I have inherited a project that contains code behind the event of a control. This one is a real challenge for me. I have an mdb and an mde that both work fine when the data tables are a part of the mdb or mde. But once split I get the following error message:
“Error 3219:Invalid operation”

when running this line of code:
Set rst = dbs.OpenRecordset(“tblRates”, dbOpenTable)

Why will this work when the tables are not split, but doesn’t work when the tables ARE split? I don’t profess to be “Access proficient” but this doesn’t seem rational to me. I used Access’ Database splitter to split the data.

Any ideas?

Thanks.

Ken

Reply | Quote

Replies

You can only use dbOpenTable on local tables. Use dbOpenDynaset on linked tables.

Reply | Quote

Charlotte,

You are awesome. Will the dbOpenDynaset also work on local tables, or does it require the dbOpenTable always on local tables?

Thanks again for your help.

Ken

Reply | Quote

dbDynaset opens an editable recordset. It will work on local or attached tables. If you don’t need to edit the recordset but just want to read it, use dbOpenSnapshot, which takes fewer resources.

Reply | Quote

dbDynaset opens an editable recordset. It will work on local or attached tables. If you don’t need to edit the recordset but just want to read it, use dbOpenSnapshot, which takes fewer resources.

Reply | Quote

Charlotte,

You are awesome. Will the dbOpenDynaset also work on local tables, or does it require the dbOpenTable always on local tables?

Thanks again for your help.

Ken

Reply | Quote

You can only use dbOpenTable on local tables. Use dbOpenDynaset on linked tables.

Reply | Quote