MDE file with linked Oracle DB tables

[vanHel]

Hi there.

I need help about creating an MDE file of my Access db. The db to be converted contains linked tables from an Oracle db.

Access is currently not able to create an MDE file. I assume that this problems results from the linked tables.

Is it possible to create an MDE file anyway?

I appreciate any help!

Regards,
Robert

 

[lupins46]

Linked tables do not affect the ability to create an mde.
The two most common issues are:
a) there are compilation errors when you compile your code (these need to be fixed)
b) the mdb file format must match the version of Access you are using (convert if necessary)

 

[vanHel]

Thanks lupins!

I am trying to convert the db with the same installation (without any update up to now) of Access with which I created the db.

Do you know if Access creates a log file or something similar during the conversion process that contains a description of the errors? When I try to convert it Access is working for a couple of minutes and finally it shows a messagebox just telling me that the conversion process failed (no error number...). The modules I developed are running properly without any compilation errors.

Any hints what to check next?

Thanks in advance!
Robert

 

[lupins46]

The point about the file version is that if you are using A2000, A2002 or A2003 the default file format for each of these versions is A2000 format. However, the only Access version which can create an mde for an A2000 format file is A2000. If you are using a later version of Access you must convert the mdb file to A2000-3 format first. You then need to check that you get a clean compile of the converted version. If you are having difficulty converting the mdb file I suggest you create a new blank mdb file in the correct format and then import everything from the current mdb file. You will then need to check references and get a clean compile before createing the mde.

 

[vanHel]

I do not think that this a version issue. I created the db with A2000 and I tryied to convert it with that same version (no updates or changes of the version in the meantime).
How can I check if Access has compilation problems? I compacted and repaired the db without problems. When I save and run the modules Access does not notify me of errors. Is there anything else I can check?

Thank you!
Robert

 

[PHV]

When in VBE (Alt+F11) menu Debug -> Compile ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886