Calling a query using .mde files and merged word documents.

[lawsonium]

Hi,

My situation:

A front end written in Access (back end mySQL).
I have made a .mde file out of this front end.
There are a number of MS Word documents used (as merge documents) for running reports and letters that are linked to queries in the database. However, I can only link these documents to the original .MDB file as you can't link to the queries ni the .mde file.

This works fine until you have a query that requires a parameter from a form. The user will have selected the parameter from the .mde version of the front end that they are using but the query which is being called from the .mdb version (by the Word merge document) can't see this parameter because it is a totally separate database.

How can I get around this problem?

Sorry this is a lengthy post, hope it makes sense.

Matt.

 

[lawsonium]

Just found this by searching Google:
http://support.microsoft.com/kb/180663

I'm going to try it out now, I'll post back.

Matt.

 

[lawsonium]

OMG, stupidly, this actually works!

You rename the .mde file .mdb and magically you can link to the queries within :-/
The .mdb file now has all the same characteristics as the .mde file (locked to the user for editing). So you have to be careful that you don’t overwrite your original .mdb file when you rename the .mde
I haven't had the chance to try this out with a parameter based query yet, I'll post back results of that too.

Matt.

 

[lawsonium]

Solved

It looks like I've answered my own question

Yes, it does wok with parameter based queries as well.

Thanks for all your, lol.

Matt.

 

[KeithG]

Thats crazy! So is the db still locked for design changes like it would be as a .MDE after you change the extension to .MDB?