Hi,

There's not much space in the title but I hope I caught someones attention that can help.

For starters it's ACCESS97

The database is split into front end and linked tables.

We added few fields a couple of days ago. ( We have a full back-up)

What is happening now is that after a period of time the buttons stop working and give a message saying something like...

The On Click can't find the file or info that it is supposed to be doing. That isn't the exact words, but I don't currently have the damaged version it is deleted. There is no error message number.

The same thing has happened 3 times. Each time I delete the front end and replace it with the backed up copy. This then works again.

Also....

Once the corruption or whatever it is happens, you cannot add any buttons in design view and also you cannot get to the Event Proceedures through the properties and also the Build Event doesn't let you in either. All you get whet trying any of these is a File Not Found message.

Any ideas out there or do I just have to revert back to the copy before the changes ?

It's a very big database about 90Meg Front end and 8Meg Tables

Help Please.

Thank you

Mike:confused:

Hi,

90MB front end sounds very large to me, Do you think it really is that size?

1, Have you compacted and repaired it?
2, Have you decompiled it?
3, Is the fronnt end running and PCs with different version of access?

Hi,

Thank you for the response,

The front end is 89,640KB
The tables are 7,250KB

It is a woppa!

The versions of access we have are all 97. We all have XP machines but we are scared to try to convert it to anything higher.

I tried to repair the DB the last time is crashed or whatever it is doing. This just made it so that I could not even open it. It said that there was a sharing issue. There was no-one else logged on at the time though ??

I could try to compact and repair it. Is it easy to do ? Should I do this with the damaged version or the original version ? What are the effects of compacting it ?

As regards de-compiling it, that sounds complicated. What does that involve and how could / would it help ?

Best regards,

Mike:confused:

Compacting will remove lots of dead space and delete entries that are cluutering up the access file. Its a bit analogous to defragging a disk. Take a backup first and everything will be OK. Do a search on decompile in this forum for more info about that. I think it will help you if its A97.

Thanx Rabbie it saved my little fingers typing.

Mike, here is the decompile method if you havent found it yet.
(its still worth searching to get a full write up)

START > RUN

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "Your Application PAth" /decompile

Close it straight away and that should decompile it.
When you next open it you can then goto a module and compile it.
After that Compact and Repair.

I think you will find that this will reduce the size of your FE by 50% if not more.

)

START > RUN

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "Your Application PAth" /decompile



You may need to modify the path to msaccess.exe if you are not using A2003.