Unable to make ACCDE

[jhargram]

Hi All---Please advice me how i prepare ACCDE file, when i click that button it will give some error msg. like "Microsoft office access was Unable to create the .accde, .mde, or .ade file".

Can anybody help me to resolved this issue...




I am using Access 2007.
file type .accdb


Thanks in Advance..

[RuralGuy]

Almost always caused by a compile error of some kind. Have you tried to compile your project?

[tanvi]

As RuralGuy has already replied that this is a compile error. I am totally agreed with this!!

So you should compile your project. I would like to add on how to compile database. Kindly follow these steps as given below:

1.First Press Alt + F11 to display VBA editor.
2. In the menu'Debug' >>'Compile AccessDb'.
3. If No error occurs, the database will get compiled.
4. During compilation process, if VBA editor will display any error message then you can easily rectify it.
5. Once all the errors get rectified, you will be able to compile the database.

[jhargram]

Hi Tanvi Thanks for the help. But I have one more issue. After these steps i can make that but when i want to open that file it shows a error msg and closed that application. I can't open that file..

[RuralGuy]

What is the error message? Do you also get the message with the accdb? How about when you open while holding down a <SHIFT> key?

[tanvi]

Hi Tanvi Thanks for the help. But I have one more issue. After these steps i can make that but when i want to open that file it shows a error msg and closed that application. I can't open that file..

Plz mention error message here, after that I can give you the solution!!