Win32API declarations with 64-bit Support

This is an update to older post API calls in 64bit VBA with direct link to large file with Windows API Declarations and Constants for Visual Basic, including 64-bit version.

Again on Error 3048: Cannot open any more databases

Once again I was hit by this error - Cannot open any more databases. It was a complex report, same as last time, all DFirst(), DMax() were removed, any calculated expressions were moved to code behind module. This helped for several months, but application is growing and users start to complain on this error. This time it occurred in same report, but when I make PDF file from 3 reports; I open 3 reports in hidden mode, output all three to PDF and merge into one file. If I comment out one report – it works without errors. Or if I close one form and do export it also works. The only explanation I have so far – Access has limited number of "pointers" to current database, each form/report/code opens more "pointers". So when I open 3 reports and then do export – it reaches "pointers" limit and error occurs.

I my case I changed a query in one or report's subreport from using subquery to Group By, and this solved the problem. Do not know for how long, but at least I know what to do next. In worst case I just do all calculations in temporary tables, this will made reports simple and require less "pointers ".

Did you have similar experience? Or maybe you have better explanation/workaround for this effect? Let us know!

What’s changed or removed in Access 2013

Changes in Office 2013:

• ADP fully removed - ok, I tried to use it several times, no luck. MDB with linked tables is much better approach
• Access data collection - the idea was good, but never used it. Now its much easier to made data collection on SharePoint server or ASP.NET application.
• Access 2003 Menus and toolbar - I would like to have them available…
• Replication, source control - did not use it for a long time
• Upsizing wizard - we can use one this older version, not a big deal

 

BTW, few days ago it was Access 20th Anniversary! 20 years and still in a good shape!

Access 1.0 Oct. 28, 1992