I'm interfacing to Access Reports from my VB application. I'm running Access 2003.
I create the report table in VB and call my Access report.
DoCmd.RunReport "ReportQuoteActivityPrint", acViewNormal
I keep getting the 2486 error. It worked at first, but now I get the error. It acts like there is a lock code on the table or database. I've searched the Microsoft problems and can't find this issue.
Any help would be appreciated.....
I tried some reports this morning and got the same error....I did notice that when I opened my ACCESS database, my object.view was set on the reports. I set my object. view to my tables, saved, and reran the VB application. They work!
For what it is worth, I think ACCESS may be locking at the object.view level, if there is a change to reports. Even if you save your report changes, ACCESS may not want to release it???
I create the report table in VB and call my Access report.
DoCmd.RunReport "ReportQuoteActivityPrint", acViewNormal
I keep getting the 2486 error. It worked at first, but now I get the error. It acts like there is a lock code on the table or database. I've searched the Microsoft problems and can't find this issue.
Any help would be appreciated.....
I tried some reports this morning and got the same error....I did notice that when I opened my ACCESS database, my object.view was set on the reports. I set my object. view to my tables, saved, and reran the VB application. They work!
For what it is worth, I think ACCESS may be locking at the object.view level, if there is a change to reports. Even if you save your report changes, ACCESS may not want to release it???
Last edited: