Notes: Database is Access 2.0
- Need to use workgroup program to join dhs.mda file.
- Then open carlile.mdb to update
- Don't have admin pass. Use everythingaccess.com services to get passes
- You'll need to update 2.0 access databases to 97, then can go to 2013
Issues: Change 16 bit module code to 32-bit code (refer to list below).
- To open databases in design mode hold shift after typing user and pass
Note: If its an old database you need to get access 2003 and upgrade, then use access 2013 to upgrade again (http://support.microsoft.com/kb/2755119/en-us).
- Wizard to help (http://office.microsoft.com/en-gb/access-help/troubleshoot-converting-an-access-file-HP005186403.aspx)
- Install office 2003 and sp3
- TRY CONVERT .MDA file in access 2003.
Note: If you get a low memory problem search all registry entries for MaxLocksPerFile and increase to maximum value
FIRST ISSUE:
A file in Microsoft Access 2000 or Access 2002 - 2003 file format has a limit of 1000 modules, while an Access 97 database has a limit of 1024 modules. The number of modules in a Microsoft Access file includes forms and reports with the HasModule property set to Yes.
To fix this memory problem, reduce the number of objects in your Access database. Consider dividing your application into multiple databases. If you have modules with a large amount of code, consider using library databases to store the code.