trying to create MDE on machine with several Access version

  • Thread starter Thread starter Jesper
  • Start date Start date
J

Jesper

I'm trying to create an MDE with with Access 2000 (db is in that format too
and compiles well).
I have both A2K, A2002 and A2003 on the computer which I've read here
http://www.access.qbuilt.com/html/conversion.html
can be a problem. Everything else on the checklist seem to be okay.
Is there a way to do to create a A2K-mde on a machine with several versions
of Access?

Jesper
 
Are you saying that when you start Access 2000 and open the MDB, you're
unable to create an MDE?
 
Are you saying that when you start Access 2000 and open the MDB, you're
unable to create an MDE?
Click to expand...

Yes. It's a secured db. The frontend of a split setup. I'm opening the file
with exclusive access. I removed the VBA password but it didn't help. I'm
able to create MDEs from a few non-secured dbs. Are there issues related to
converting secured dbs?
I'm logged in as the db owner. I appreciate any input. Thanks.

Jesper, Denmark
 
Jesper said:
Yes. It's a secured db. The frontend of a split setup. I'm opening the
file with exclusive access. I removed the VBA password but it didn't help.
I'm able to create MDEs from a few non-secured dbs. Are there issues
related to converting secured dbs?
I'm logged in as the db owner. I appreciate any input. Thanks.
Click to expand...

I'm unaware of any issues. Hopefully someone else will chime in.
 
Um, unless I've missed it, you haven't said /why/ you are unable to
create an mde. Is the option greyed out? Is it not greyed out, but you
get an error when you try it?

If you haven't done so already, you should do a "compile all" (or
whatever it is on your version of access) to check for compilation
errors. These will always prevent the creation of an MDE. Also check
for missing references (tools:references).

Another rare but possible cause of being unable to create an mde, is
using methods of the dbengine object without the explicit dbengine
qualifier; eg. opendatabase instead of dbengine.opendatabase. See if
you have any of those.

HTH,
TC
 
Jesper, I'm not sure, but I suspect that an error has
crept into that web reference. I would read it as:

"Are you attempting to create an MDE from Access 2000,
but with applications from Microsoft Office XP or Visio 2002
also installed on the computer, and "
DO NOT
"already have Microsoft Office 2000 Service Packs 1, 2 and 3
installed?"


Office XP and Visio 2002 installed a version of
VBE6.dll that was incompatible with unpatched
versions of Access 2000, leading to possible
file corruption.

(david)
 
Back
Top