Unanswered: Can't do Multiple Recordsets queries to a .MDB thru a system DSN
My .ASP page can successfully connect and display data from my .MDB file (which is set up as a system DSN on the server). However if I need to display data from more than multiple tables on my page and add a second recordset (i.e. Recordset 1 = Table 1, Recordset2 = Table 2) my page crashes with the following error:
· Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
The problem can't be in the code because I can connect and run fine with only a single recordset.
Could it be:
1) some setting in the .MDB file?
2) some attribue of the system DSN set up?
3) or something with file permission? (the file currently has full control allowed for every one.)
Have also tried several work arounds (make one recordset with all my tables, mirroring my data table in my query table) these don't work due to various other problems.... for starters I break the max allowed fields per SQL query, among others.