Hi,
I have a query which works fine for some records and not others. It is a very simple query:
SELECT * FROM MAS WHERE systemNo = 'B123456'
The records that don't work the error is:
Runtime Error 3049
Cannot Open Database ". It may not be a database that your application recognises
To troubleshoot I tried to select the record by its native primary key (instead of systemNo) and it worked, so I figured the system key for that record is somehow corrupt and tried to retype it in for that record but the database is currently in use - will try this later.
Yes the database is split.
Any other ideas?
Cheers
-Al
I have a query which works fine for some records and not others. It is a very simple query:
SELECT * FROM MAS WHERE systemNo = 'B123456'
The records that don't work the error is:
Runtime Error 3049
Cannot Open Database ". It may not be a database that your application recognises
To troubleshoot I tried to select the record by its native primary key (instead of systemNo) and it worked, so I figured the system key for that record is somehow corrupt and tried to retype it in for that record but the database is currently in use - will try this later.
Yes the database is split.
Any other ideas?
Cheers
-Al