DATABASE CRASHES when creating new report from existing report

[Sammie]

I tried to create a new report from an existing report by using "save as"
while in report preview. It seemed to work. When I went to the database
window under reports, my new report name was not there. I get the follwing
error message:
"Name conflicts with existing module, project, or object library."
I also tried finding my old report in the database window under reports and
copying it. This produces the following error message:
error#2: "The search key was not found in any record."
Can anyone help?
Thanks!
Sammie

 

[Allen Browne]

This sounds like a corruption.

You can try to fix it like this:
1. Run a compact/repair:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

2. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

3. Open Access (holding down the Shift key if you have any startup code),
and compact again.

4. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

5. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

If that doesn't solve it, create a new (blank) database, and import
everything. Steps:

6. Create a new database:
File | New
or in Access 2007:
Office Button | New

7. In the new database, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

8. Import everything:
File | Get External
or in Access 2007, choose the External Data tab of the ribbon, and click the
Access icon in the Import group.

 

[Sammie]

I am stuck on step 2. Here is my run command:
"c:\Program Files\Microsoft office\office11\msaccess.exe" /decompile "
C:\Documents and Settings\ShelleyK\My Documents\5superdatabase.mdb"
I get the error message: Microsoft office is unable to open the data access
page." I do not know what a data access page is. Much searching hasn't
provided an answer.
Thanks for the help.
Sammie

 

[Allen Browne]

A Data Access Page is what shows on the Pages tab of the Database window.

Since you don't know what a DAP is, you probably don't have any, so this may
be part of the corruption.

Try picking up at Step 6 (i.e. importing into a new database.)

 

[Sammie]

Hi Allen,
I am rebuilding my database, and I found some forms and reports that were
corrupt in the process. So far so good with that.
I thought it would be a good idea to decompile my new database, back to your
step 2, but I am unable to do it. I keep getting the error ". . . unable to
open the data access page. The path specified was invalid, or may be too
long... etc.". So I created a new database with nothing in it (before
importing anything, and both before and after turning off auto-name-correct
but doing nothing else), and tried it with my database both in My Documents
and on the root C. I still get the data access page error. Is there
something wrong with my Access software? Here is my run command that returns
the error: "c:\Program Files\Microsoft office\office11\msaccess.exe"
/decompile " C:\6superdatabase.mdb" (including quotes)
Thank you!
Samnie

 

[Allen Browne]

Samnie, I've never seen that message, and don't really know what to suggest.

You could try uninstalling and reinstalling Office to see if something has
gone haywire.

If that doesn't work and you don't get any other suggestions here, post a
new question in the microsoft.public.access group (which gets higher traffic
than this one.) Be sure to explain that the problem occurs even with a brand
new database. Mention you are using Access 2003, and what service pack (from
Help | About.)

 

[Sammie]

Thanks. I think I'll try decompiling my database on another computer, and if
no joy, I'll try your suggestion. I appreciate all your help.
Sammie