MDB to MDE

[rdkirb49]

How can I convert my MDB to MDE? I am using Access 2002 on an XP machine.

Reg

 

[Crowley16]

you need to first create a password

then you need to goto the tools menu, and under database utilities, select the make mde option

 

[jrbarnett]

You don't crowley, just open the MDB file, then go to tools -> database utilities -> Make MDE.

If Make MDE is greyed out and you are using Access 2002 (XP), you need to convert the MDB to Access 2002 format (for some reason it can't create an MDE from an access 2000 database). Presumably the same would apply to Access 2003.

John

 

[ZmrAbdulla]

Hi,
To add some more to John's post..

1. Set a startup form
Tools > Startup
2. Compile your code form the VBE window.
While at Form/Report design View
View > Code
Debug > Compile dbName
3. Make sure all your objects are accessible from forms.
If your user is working with runtime version, he
can't access DB window you can with full version.
4. Make sure you have no more design changes in the db.
You have to keep a master copy (MDB)for design changes.
5. Take a backup of the MDB
6. Do a Comapct and repair.
7. At last you are at Make MDE ..

regards


Zameer Abdulla

http://www.geocities.com/zameerabd/

 

[rdkirb49]

I followed all the steps. I received the error message that microsoft access could not create an MDE. What do I need to do?

Reg

 

[rdkirb49]

Would this be due to the fact that I added code to Access?

This is the code that I added to run a mail merge document.

Private Sub Report_1_Click()

On Error GoTo Err_Report_1_Click

Set Sh = CreateObject("WSCript.Shell")
Sh.Run "D:\archive\closure_pkg_batch1.doc"

Exit_Report_1_Click:
Exit Sub

Err_Report_1_Click:
MsgBox Err.Description
Resume Exit_Report_1_Click

End Sub


I already have the code password protected. I also have disabled everything on startup (i.e. shortcut keys like f11). I am trying to eliminate most common avenues that the average user could possibly use to change my code or damage the database.

Thanks also for all the help so far.

Reg

 

[ZmrAbdulla]

Hi,
Normally if there is any problem with code, Compiling will highlight it. In this case you are not getting any error while you compile.

Try to create a new db without the code that you suspect and make MDE. If you are success then there should be some problem with that code.

regards

Note: I am going on a long vaccation from today. I don't think I can login to this Forums regularly, so won't be posting any reply for some time. I will when I get time.


Zameer Abdulla

http://www.geocities.com/zameerabd/