Problems with Access xp (2002)

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have developed at different levels with Access for many years. I think it
is a great product. But I am now getting interrupted on the most mundane of
changes, like adding a text box, with the error, sorry Access must close
down, suggest you upgrade.

All the folks I do thing for have access xp or acces 2003. I would like an
mvp, or experienced person with this, to give me a suggestion, as I am about
to have ulcers for the first time I think. This is killing my efforts to
program.

Thanks
Ken
 
Sorry for asking trivial questions but did you try to compact your currentdb ?

If yes, have you tried a decompile

Here the calling syntaxe to be put in a cmd window.

call "C:\PathToYourAccess\msaccess.exe" /decompile
"C:\PathToYourDB\YourDB.mdb"

And last you can create a new mdb and import all the object from the
failling one.

Hope it helps.
 
Yes I did the compact and repair.
And I did start with a blank db and import all several times.
I havent done the decompile.

I am not sure I know how to do that. Do I just type it exactly as you have
it, and then hit enter in the command window. Is the word call typed in also?

Thanks for your help
 
Is the word call typed in also?

If you do it via a command window, yes.

Or you can create a desktop shortcut with exactly the same syntax but leave
out the "Call".

I have 2 such shortcuts in permanent residence on my desktop. One for the
/decompile switch, one for the /runtime switch (opens the specified file as
if you were a runtime user). Anytime I need to use one or the other, I just
edit the "...\YourDB.mdb" section to the file I'm working on and execute.
 
Yes I did the compact andrepair.
And I did start with a blank db and import all several times.
I havent done the decompile.

I am not sure I know how to do that.  Do I just type it exactly as you have
it, and then hit enter in the command window.  Is the word call typed inalso?

Thanks for your help










- Show quoted text -
Click to expand...

Hi,

Maybe you need to check your mdb files to see they are ok or not.
Perhaps they are damaged or something. If necessary, you can try a
tool called Advanced Access Repair at http://www.datanumen.com/aar/ .
I have used it to repair many corrupt Access MDB files on my damaged
disks successfully. Hope this can help.

Alan
 
Back
Top