replicate database design, not data

[Guest]

I have a database, tables, queries, forms, reports, macros, etc. I want to
use this database at several clients and enable them to work on it also
(leave it on their network).

But, the project is constantly changing. Is there a way to update a master
and have the related information replicated to their machines? For example,
have a master database and then replicate enhancements to their copies? I
have looked at replicate, but it appears it will not work with forms and
reports. Also, I just want to replicate structure not data since it will be
unique at each location.

Thanks,
Dave

 

[Alvin Bruney [ASP.NET MVP]]

one approach is to write a simple script to copy the schema and distribute
to clients. then they can add the data as they see fit since the structure
would be correct

--
Regards,
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
_________________________

 

[Tony Toews]

I have a database, tables, queries, forms, reports, macros, etc. I want to
use this database at several clients and enable them to work on it also
(leave it on their network).

But, the project is constantly changing. Is there a way to update a master
and have the related information replicated to their machines? For example,
have a master database and then replicate enhancements to their copies? I
have looked at replicate, but it appears it will not work with forms and
reports. Also, I just want to replicate structure not data since it will be
unique at each location.

Not really. Replication is meant for record changes/inserts/deletes
and likely handles schema updates just fine. But it isn't designed,
and I don't think it can do, only schema updates.

For some sample code see the TempTables.MDB page at my website which
illustrates how to use a temporary MDB in your app.
http://www.granite.ab.ca/access/temptables.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm