Creating queries on an MDE

[mjn015]

I have split my database and have the BE on a network server. Users were each given a copy of the MDE file to enter data from using a Form.

When I bring up my copy of the MDE and create a query or edit an existing one and give it a new name... only I can see this new query. Is this the way it's supposed to work?

What would I need to do if I wanted the query I created to be seen by everyone who has access to the database? Do I need to create the query on the MDB and then create a new MDE?

Thanks,
Michael

 

[Rabbie]

In Short Yes. When you have split the DB everyone has their own copy of the FE and share the BE.

So any changes made to queries/forms/reports are local to that PC until you distribute a new version.

 

[pbaldy]

Do I need to create the query on the MDB and then create a new MDE?

Yes, and distribute the new MDE. Most of us use some sort of utility to automate that. BobLarson has posted one here if you poke around.

 

[mjn015]

Thanks Rabbie...Thanks Paul...
I sort of figured I'd have to do that. And yes, I have made use of Bob's utility, so distribution won't be an issue.

Thanks again for your help!

 

[mjn015]

Thinking about this a little more.....

So, if a user creates a bunch of queries within his MDE and the DB administrator decides to...let's say...change the color of a form. He creates a new MDE and distributes that form change via the new MDE to all the users. The new MDE each user receives will write over their existing MDE automatically (via Bob Larson's utility). That would mean, their custom queries would be gone, correct?

 

[pbaldy]

If you let users create queries, then yes, that process will lose them. I don't let users create queries (I force them into runtime mode). If you intend to let them, I've heard of update utilities that update individual objects rather than the whole file.