Access 2000,2003 cannot open the recordset on the SourceTable (being a linked table) using this code below:
Dim QNumber As Integer
Dim rst As Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("SourceTable", dbOpenTable)
QNumber = rst.RecordCount
I have a code that creates a new table and inserts records from the source table randomly into this new table. The database worked well. But Because of security reasons I have had to split the database tables into Front-End and Back-End using Database Splitter. Now it doesn't work.
Can someone please help me change this code to make it compatible with a linked table?
Yes, I have split the database and see the arrow next to the table which tells me the table is linked. I can also click on the table and all the data is present. But VB does not see any questions? Any suggustions?