report disappeared

K

Kim

I was trying to run a Documenter report showing all object permissions. It
had an error so didn't complete the report. Now when I try to do it again I
get an error that says "Table 'doc.tblObjects' already exists" but I can't
find the report anywhere. Where would it be?
 
K

KARL DEWEY

It should be where ever your Word has for default file location - maybe My
Documents.'
When you get that message just let Access overwrite it with the latest report.
 
K

Kim

I did a file search and it is no where to be found. Also, Access doesn't give
me the option to override it. I just have to click OK and then nothing
happens.
 
J

John W. Vinson

I was trying to run a Documenter report showing all object permissions. It
had an error so didn't complete the report. Now when I try to do it again I
get an error that says "Table 'doc.tblObjects' already exists" but I can't
find the report anywhere. Where would it be?
Click to expand...

It may be hidden; try opening the database window and selecting Tools...
Options... View, and check the checkboxes for System Objects and Hidden
Objects. You'll see all the tables that Access has created "behind the
scenes". I expect that you can safely just delete this table.

Back up your database first just in case!

John W. Vinson [MVP]
 
K

Kim

This didn't work either. Any other suggestions?

John W. Vinson said:
It may be hidden; try opening the database window and selecting Tools...
Options... View, and check the checkboxes for System Objects and Hidden
Objects. You'll see all the tables that Access has created "behind the
scenes". I expect that you can safely just delete this table.

Back up your database first just in case!

John W. Vinson [MVP]
Click to expand...
 
J

John W. Vinson

This didn't work either. Any other suggestions?
Click to expand...

Turn off Name Autocorrect; compact and repair the database, and see if it's
gone.

John W. Vinson [MVP]
 
C

cw

Hi Kim,

Have you tried going to the following path to locate your documenter report
info?
C:\Documents and Settings\...Your Profile Here...\Application
Data\Microsoft\Access\. The Application Data folder is hidden so you may need
to open Windows Explorer and set the folder options to "Show hidden files and
folders".
 
C

cw

Sorry Kim,
Forgot to mention - after you get to the directory - you can open the
database file titled ACWZUSRT which is where the file is stored.
 
Top