Hello,

I am trying to convert my .mdb > .mde and have 'converted it to 02/03' version as well as 'compacted and repaired'. It is free from compile errors and I get no message saying that it cannot be converted or any messages it fact. There is alot of VB code in the .mdb so I was wondering if this causes it to take longer to create the .mde as the CPU usage is at tops (100%) and access is blank. should I leave it for a longer period of time? cause I tend to hit ctrl+alt+del to cancel access. i wanted for upto 30mins. can it take this long i want to ask?

any help or advice would mostly be appreciated. thank you.

Derek

oh and when I open the mdb again its in read only state. just tested it. thank you

Is the MDB file on the local hard drive?

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Hi, i have the same problem. The database is on a file server, but when i copy it to my local drive and try to convert to .mde i get the blank access and 100% cpu load with what looks like very little progress. Thanks

I realise this is a long time since the original post but it took me so long to find a solution to a similar problem I am posting the solution I found everywhere I encountered in my search so that it might save someone else some time.

This describes the problem I had
http://brandon.fuller.name/archives/....25/index.html

I also copied all the tables/forms/queries/code modules to a new blank db and ended up in the situation Derek was in.

The solution to my problem is contained in the comments on the page above:

- Run MSACCESS.EXE /decompile
- Edit a form that contains a code/event
- On Microsoft VB code click Debug then Compile the project - this will remove all the unnecessary codes.
- Save it back then recreate an MDE