Problems with Access xp (2002)

[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

 

[marot_r]

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.

 

[Ken]

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

 

[George Nicholson]

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.

 

[Alan]

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 -

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