Importing Table "DESIGN"

[vCallNSPF]

My company has a database that allows us to print report data based off information relating to 'aged care' facilities. each of our facilities has its own seperate access database.



there is also a control database, which is empty, that has the formatting of all the other databases. basically the plan is, as the facility databases adapt and change, i change the empty database aswell so that any new facility database i make will have these new changes.

my problem comes when i need to update all the OTHER facility databases. what i have been doing is importing reports, forms and queries from the empty database and all has been fine. HOWEVER, i have not had to update the design of a table until now. im sure you see the problem now, when i import a table from the empty database, naturally, it is empty, so it deletes all the current table data i have in database im updating.

So how do I import only the table design and not the empty data/is this possible?

thank you.

[ConneXionLost]

How about this approach?

1. Make a "new" copy of your control template/database.

2. Use append queries to copy (just the) data from your "working" database to your "new" database. You can delete the append queries once they have done their job.

3. Replace the entire "working" database with the "new" database (make sure the file names are identical).

4. Update complete!

Cheers,

[vCallNSPF]

Haha, thanks heaps.

I actually "facepalmed" when I read your solution, so simple!

Cheers again, solved.