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.

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

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?

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

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