Split Database then error 3219

[Wuffles]

I have an access 2007 database. When I split the database using the Access
database splitter then run the program I get error 3219. The debugger shows
that the code stopped at an OpenRecordset dbOpenTable command. The database
was split correctly and separated the table and application successfully.
What could be the problem? Any help would be greatly appreciated.
BobG

 

[John W. Vinson]

I have an access 2007 database. When I split the database using the Access
database splitter then run the program I get error 3219. The debugger shows
that the code stopped at an OpenRecordset dbOpenTable command. The database
was split correctly and separated the table and application successfully.
What could be the problem? Any help would be greatly appreciated.
BobG

OpenTable only works with *local* tables, or you need to explicitly open the
backend database as another Database object.

Consider using OpenDynaset instead - it works fine with linked tables. You
will need to use the FindFirst method rather than the Seek method.

 

[David W. Fenton]

OpenTable only works with *local* tables, or you need to
explicitly open the backend database as another Database object.

Consider using OpenDynaset instead - it works fine with linked
tables. You will need to use the FindFirst method rather than the
Seek method.

I would always recommend against using Seek, as the value of the
performance benefit is slight in anything but a very small number of
circumstances.

But if you're trying to make legacy code that uses Seek work with
linked tables, just change your database variable from one assigned
with CurrentDB to one assigned with DBEngine.OpenDatabase, where you
open the back-end database. With that, the old code with dbOpenTable
and Seek will continue to work.