Conversion to mde

[Ling]

Hi..
I have a mdb file now that has linked tables to the SQL
server and I would like to convert it to a mde file.
However, I cant seem to do it. There's a error msg
saying ' Microsoft Access is unable to make a mde
database'. Sometimes, the computer hangs when I try to
convert into mde format.

Any ideas?

Thanx

Ling

 

[Cheryl Fischer]

Ling,

Two possibilities come to mind:

1. There may be coding errors or problems in the database; these will
prevent the creation of an MDE. Open any code module and, from the VBA
menu, select Debug, then Compile. If there are any errors, you will see an
error message and the problem line of code will be highlighted. Continue
compiling until the compile completes with no messages at all.

2. If you are using Access 2002 or 2003, the default database format is
Access 2000. Unfortunately, if you use the Access 2000 database format in
Access 2002/3, you cannot create an MDE. You may only create an MDE of an
Access 2000-format database using Access 2000.


hth,

 

[David Dunster]

When you create and MDE file with Access, it complies the code.

If Access during that compile should find an error in the code or somthing
missing, it will not create the MDE and likely generate the error you get.

To find out why it won't compile to MDE, you need to get into the code. Open
you database, press ALT-F11 then under DEBUG on the top menu bar, select
Compile.

Access will compile the code and when it find the error, it will stop so you
can see what it is.

Hope that helps.

signed

Dave, VE5DGD
Self-taught Access 95, 97 & 2000 programmer