Copy queries from mdb to txt

[ill_comms]

Hi All,

I would like to read/iterate through all queries in an access db and write them to a txt file. This will include the name of the query and the sql text.
Any ideas?

 

[ChrisO]

Before anyone spends too much time on this would you mind explaining why you want to do it?

Regards,
Chris.

 

[ill_comms]

Sure at certain periods through out the year I would like to send out database updates to multiple users that use this database. Without having to update them one by one.

So basically I note down table and data changes which is a bit more manual, and I add these as sql commands to a txt. E.g. Drop tables, manipulate what data I need to. Then the queries are be dumped into the txt file.

Then I have another script that I send out to users along with the txt file and get them to run it so it updates tables, data and queries are up-to-date and in sync with me.

 

[ChrisO]

It sounds like the users are not using a split database…FE/BE.

Normally a FE is sent which overwrites all of the FE, not just the queries.

But others may have a different view so let’s wait and see.

Regards,
Chris.

 

[ill_comms]

The users are not part of the same system. Separate networks, off-site from me, councils round Aussie.

 

[ChrisO]

As far as I can see, each remote network should be split FE/BE (a point not addressed by you) whatever it does.

Therefore, updates to the way their data is manipulated is usually performed by the replacement of the entire FE, not just parts of the FE as in queries.

Are the remote databases split and how are they split?

Regards,
Chris.