Automatically adding tables into MSAccess

[a.stobirski]

Is it possible to automatically insert queries / link tables into a MS Access database by the using of executables - i.e. something that would automatically install when double clicked.

At present, I am having to visit customers on site and manually edit MS Access databases to fix a problem. Anything that could be emailed out, that auto installs would make my life much easier.

Cheers

Andy

 

[Keith P]

It can be acheived by having a split FE/BE database. If you need to add/amend forms, queries, reports etc. then you can send a replacement frontend. If you need to create or change tables, indexes, relationships etc then you can use a third database to apply changes to the BE by use of createTable, createField, CreateRelation, CreateIndex etc I've also found Alter very useful.

 

[Keith P]

To finish answering the question. Yes you can link tables using code. A search of the forum will provide code examples/links.