Problems with Access xp (2002)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 29 Apr 2008 20:45 GMT

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

Reply to this Message

marot_r - 29 Apr 2008 21:09 GMT

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.

Signature

A+

> 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
[quoted text clipped - 8 lines]
> Thanks
> Ken

Reply to this Message

Ken - 29 Apr 2008 22:00 GMT

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

> Sorry for asking trivial questions but did you try to compact your currentdb ?
>
[quoted text clipped - 22 lines]
> > Thanks
> > Ken

Reply to this Message

George Nicholson - 29 Apr 2008 22:29 GMT

> 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.

Signature

HTH,
George

> Yes I did the compact and repair.
> And I did start with a blank db and import all several times.
[quoted text clipped - 40 lines]
>> > Thanks
>> > Ken

Reply to this Message

Alan - 13 May 2008 15:30 GMT

> Yes I did the compact andrepair.
> And I did start with a blank db and import all several times.
[quoted text clipped - 36 lines]
>
> - 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

Reply to this Message

Rate this thread: