Adding Queries and Macros to the database

[Chrismarworth]

I have designed a couple of queries and marcos to extract data thats required from the database and at present I have only put them into a spare backup for design and testing purposes.

If I were to add the queries and macro to the databse thats actually in use is this going to cause any issues with the software? Will any software upgrades clear them from the db?

[Duncan Rounding]

You can create additional tables in the database but be careful not to write any data to existing tables unless you are very sure of the implications.

The structure of the database can (and often does) change with releases and yes your queries may get wiped or no longer work.

Also be careful if Actinic is open when you run your macros/queries.

[completerookie]

I wrote complex queries etc looking at the actinic database
BUT and its a BIG BUT - I never ever changed the actinic database in anyway shape or form.
Its so easy to create a new access database and then link one (or more) tables from the actinic database into the new database.
I ran a complete trackside-shop (karting) looking directly at the database, using sections, names, addresses, you name it, but ANY values were ALWAYS stored in MY database.
I then used my database to store stock values, re-order values, suppliers, etc etc
The only hassle I ever got, was making sure I could update stock figures at the end of a track day, but to be honest, that wasn't an actinic issue, that was a "my database issue"

I did have my database open at the same time as the actinic side of things, and never experienced problems - thats not to say you may not get problems, just that I never had issues with open database, afterall, the database is really a READONLY db.

kev

[gabrielcrowe]

mr grounding is right, its best not to fluff with the structure of the actiniccatalog.mdb at all.

However, if you're looking for an online solution, how about this:
http://www.interact-studio.co.uk/aca...Connector.html

This tool moves data from the local database, to an online one. Then you can mysql yourself to digital oblivion, in whatever scripting language you like.

the data is used here:
http://www.interact-studio.co.uk/aca...ientLogin.html
user: kijuhygtfrdshygtfr@yhgtfrdehygtfrdeyhgtfd.com
pass: TTTEST20000044

Is this the kind of thing you're writing?