|
Subject:
|
Problems Converting Dbase and making MDE
|
|
Posted By:
|
ggiibboo
|
Post Date:
|
12/23/2005 12:34:28 AM
|
Hi there funksters,
I have made a Dbase in Access2000. I want to make an MDE file, however Access says "MDE can't be created".
My dBase is free from compile errors, all objects have all read/write privillages, i haven't made a replica and my dBase isn't a design master.
this is driving me nuts.
i also have a version of Access2003 on another computer, and so I tried converting the 2000 dBase to 2003, and i couldn't do that either. it comes up saying "After you have converted the file it won't be able to be used in access97 and Access200 etc. etc." and then i click "OK" but nothing happens.
someone please please please help.
|
|
Reply By:
|
Bob Bedell
|
Reply Date:
|
12/23/2005 12:49:02 AM
|
A) Compilation errors and B) database corruption are the two primary causes of this problem. Since you're confident A isn't the issue, look at B. Import your db objects into a new .mdb file and try again.
1. Will it compile? If not, fix your code.
2. Will it compact/repair? If not, import all your objects into a new mdb. file.
3. Can you create a .mde from a new mdb.? If not reinstall Access.
HTH,
Bob
|
|
Reply By:
|
ggiibboo
|
Reply Date:
|
12/23/2005 12:57:24 AM
|
ok, I've already imported all objects into a new mdb file.
will it compile? well how do i know. there are no errors when i open up the form that i have created.....
is it possible to send someone the code so that he/she may have a look at it for me?
|
|
Reply By:
|
Bob Bedell
|
Reply Date:
|
12/23/2005 10:39:28 AM
|
To compile your db, open up the Visual Basic Editor (Alt-F11) and from the menu select Debug --> Compile. If you have errors in your code (form and report modules, standard modules, class modules), they will be highlighted and you can correct them.
HTH,
Bob
|
|
Reply By:
|
ggiibboo
|
Reply Date:
|
1/3/2006 12:42:27 AM
|
Thanks for that Bob,
Very Helpful. I have my database in an almost usable form.
When I open my database now, however i keep getting security warnings, however there is no issue with the security. what code should i put in so that access ignores warning messages.?
mike
|
