Anytime I try and compact & repair or when I try and create a backup
of my db, the program locks up. (returns a "beep" with each click and
I cannot select any field.
I am using Access 2007 and I have been going to the
File>>Manage>>...menu. I have tried to import my tables into a fresh
db and start it over that way, and I still am having the same problem.
I have also tried running a repair on access and it has not fixed the
problem. I wish I had an idea more of what may be causing the problem.
But as of now, this is all I can find. Thanks!

-WhatHaveIDone?

WhathaveIdone? wrote:
Can you compile your app cleanly?

Let's say your app is called Test.mdb. What happens if you create 5 new
mdbs; TestTables, TestQueries, TestForms, TestReports, TestModules.
Into each of these 5 import the files based on the name. Can you
compact each one? Does one fail?

You might want to consider SaveAsText, LoadAsText on your forms and
reports.
http://www.access-programmers.co.uk/...p/t-99179.html

BTW, keep/make a backup copy before you start messing around.

On Nov 10, 8:35*pm, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
I created a new db file for each type of object and imported them in.
I compiled each type individually. I did find an error in some code
that I had tried out some time ago. It was no longer even useful so I
removed the module. However, I am still having the same problem with
the database together. I was getting ready to split the database and I
want to make sure everything is ok before I split it and distribute it
to 15 people.
BTW, does it make a difference that my file is ACCDB instead of MDB?
Shouldn't I be able to compact/repair or do a backup of the file?
I would love to make a backup copy, but that is the problem. I can't
make a backup copy. I can copy the file, so I am keeping a copy on a
separate disk as a backup.
A few more specifics: I have a login form, that will run after I make
the backup copy or do the compact/repair. But then it goes to the next
form as it ought to and it will be locked up form there. I tried CTRL-
Break. No help. It only works on my primary file. So I still don't
have a clue what might be causing the application to hang-up. Anymore
help would be appreciated. Thanks.
-WhathaveIddone?

WhathaveIdone? wrote:

Enter the word
STOP
in the OnOpen event of the form that locks up to turn the debugger on.
Step thru the code and see what line it fails on.

Check out saveastext, loadastext on google it is just that form that
causes fits.

On Nov 11, 2:20*pm, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
That did it!! I entered STOP before the code to move me to my main
menu form from the login form I had set up. Going through one step at
a time, I could see that my OnError code was causing problems. I
eliminated the OnError code from that particular sub and everything is
working perfectly!
I get a fully functioning database again! Thank you so much for
sharing your knowledge and expertise.

-WhatHaveIDone?