Re: Query exists in MSysQueries, but not in db anymore
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Wed, 11 Mar 2009 23:57:32 +0900
I don't understand that reply, Chris.
If it is a multi-user program, you *really* need to split it. If that's a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html
Once you have it split, you can replace the front end with an updated one (without the corrupt query), without much difficulty.
If you need to automate that process across 2000 machines, this utility might help:
http://www.granite.ab.ca/access/autofe.htm
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"chris" <chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9358436A-A52F-47DF-8AAA-A480112AA65D@xxxxxxxxxxxxxxxx
Thanks Allen, Program runs on 2000 machines, only this one gave this error...
so is not easy following this solution :-(
.
- Follow-Ups:
- References:
- Query exists in MSysQueries, but not in db anymore
- From: chris
- Re: Query exists in MSysQueries, but not in db anymore
- From: Allen Browne
- Re: Query exists in MSysQueries, but not in db anymore
- From: chris
- Query exists in MSysQueries, but not in db anymore
- Prev by Date: RE: Saving Access03 Report to multiple pdf's
- Next by Date: Re: Query exists in MSysQueries, but not in db anymore
- Previous by thread: Re: Query exists in MSysQueries, but not in db anymore
- Next by thread: Re: Query exists in MSysQueries, but not in db anymore
- Index(es):
Relevant Pages
|
