Creating MDE Files

[Guest]

I've created a database to monitor machine downtime and production levels.
The database is split into a front end and back end. The front end is on 10
computers. I was led to beleive that it would be a good idea to save the
front end as an MDE file. When I go into database utilities it will not let
me create an MDE file, any ideas why this could be?

Tommy

 

[Guest]

Probably a versioning problem. If your version is more recent than 2000 and
not 2007, the default database format is 2000; however, in this situation,
you cannot create an mde. You must first convert your back end and front end
to the version you have installed.

 

[John W. Vinson]

I've created a database to monitor machine downtime and production levels.
The database is split into a front end and back end. The front end is on 10
computers. I was led to beleive that it would be a good idea to save the
front end as an MDE file. When I go into database utilities it will not let
me create an MDE file, any ideas why this could be?

Tommy

A couple of reasons. If you're using A2002 or A2003, you must use Tools...
Convert to convert the database from the default 2000 format to 2002/3 format
before it will let you create a .mde. The other possibility is that there is a
compilation error somewhere in your VBA code; to find out, type Ctrl-G to open
the VBA editor and select Debug... Compile <your database>. Fix any errors,
compile again, compact the database, and then try creating the .mde again.

John W. Vinson [MVP]