cannot make mde !?

[piet123]

please help.

access error: access cannot make mde file.

why not ? (i think because i messed up with the security settings in my db)
never got the security issues to work anyway.

how do i fix my db to make mde file again ?

any help will be appreciated.

thanks,
piet.

 

[maxmangion]

did you try compiling any modules you have ?

 

[piet123]

no modules

i don't have any modules in my db, just a few tbls, qrys, frms, reps.

 

[maxmangion]

but did you place any codes in your forms, reports etc. ? if yes try to compile your code!

 

[Mile-O]

Also, if you are using Access 2002, the default is a A2000 database which you'll have to convert to A2002 before being able to compile an .MDE

 

[maxmangion]

if you are using Access 2002, the default is a A2000 database which you'll have to convert to A2002 before being able to compile an .MDE

you're right Mile-O-Phile, but when i encountered that problem, i had the MDE option dimmed in the first place, and not giving me errors as piet123 mentioned!

 

[piet123]

compile for mde

but did you place any codes in your forms, reports etc. ? if yes try to compile your code!

(i'm new to all this.)

i have [event procedures] for a few cbo boxs on forms for which i wrote a few lines (of code?) in the vba window.

1. how do i COMPILE code then ??

2. will compiling the code fix the db so i can mde file again ?

any help please ?

thanks.
Piet.

 

[maxmangion]

to compile those pieces of code (Event procedure) when you are in the vba editor i.e. where you wrote the code, go to the Debug Menu and select compile from that menu.

 

[Mile-O]

Also, if you have created an object on a form or report, put code behind any of this control's events, and subsequently deleted the control then the code will not be removed and will have to be done manually. This will also prevent the compilation of an .mde file.