|
Subject:
|
.mde problem
|
|
Posted By:
|
Derek_05
|
Post Date:
|
2/7/2006 5:57:10 AM
|
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
|
|
Reply By:
|
Derek_05
|
Reply Date:
|
2/7/2006 5:59:17 AM
|
oh and when I open the mdb again its in read only state. just tested it. thank you
|
|
Reply By:
|
AccessMaster
|
Reply Date:
|
2/18/2006 5:05:06 PM
|
Is the MDB file on the local hard drive?
Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
|
|
Reply By:
|
Looch
|
Reply Date:
|
4/13/2006 4:21:31 PM
|
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
|
|
Reply By:
|
TonyHawe
|
Reply Date:
|
9/20/2006 7:38:46 PM
|
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/2004/08/31/13.29.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
|
