Database Documenter does not work

Question

I recently switched from an older version of MS access (97 Access) to the latest version (I switched from a .mdb file to a .accdb file) and now when I click on my tables in the the database documenter, it gives me an error that says "no objects were selected." Does anyone know how to fix this access error so that I can open my reports?

Answer 1

Thank you, however, it looks as though MS Access is pulling up a property list of the table rather than the original table as shown below. Is there a way to fix this so that I can pull up the original table?

Answer 2

SELECT the Object(s) you want or SELECT ALL

Answer 3

OK it looks like you are trying to use the Database Documenter.But there doesn't appear to be any table selected (a selected table will have a check mark, just highlighting it is not enough).

Answer 4

I did create a new .accdb file using the current version to import everything. I'm not sure what version I am running but it looks recent (definelty not the 97 Access anymore). I did change some of the VBA code but I don't think that seems to be the issue. I included a picture below of what the error message on my screen looks like but when I go into the database documenter and try and open one of my tables (ie tenant register), it tells me 'no objects were selected" after I click OK. Is this a file access/conversion error? Should I try doing a clean reset/convert again?

Answer 5

Create a new .accdb file using the current version (which are you running?) and use File... External Data... Import to import everything from the .mdb file into the .accdb. You'll almost surely need to edit your VBA code to be consistent with the new system but there are folks here who can help with that process; Compile the project and you'll be able to tackle the compilation errors one at a time.