MDE - UPDATE FORMS AND REPORTS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

THINK - 19 Jul 2006 22:11 GMT

I have working application between multiple users, pc and laptops, all in MDE
form to protect original code. All replicated with design master.
Everything works well. My question is how to make minor changes to the
replicated database. I can change queries and tables in the design master
and replication is automatic with the next sync. Currently changes made to
forms and reports require copying data into non-mde, creating new mde,
replicating and replacing each database. What is the better way?

Signature

My salvation does not depend upon my code running!

Reply to this Message

Douglas J. Steele - 19 Jul 2006 22:19 GMT

Since you're dealing with MDEs, you have no choice but to continue doing
what you're currently doing. Even if you were dealing with MDBs, though,
you shouldn't be replicating the application portion of the database (i.e.
forms, reports, macros and modules). Replication is only intended for data.

You might find the Auto FE Update Tony Toews has for free at
http://www.granite.ab.ca/access/autofe.htm useful.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have working application between multiple users, pc and laptops, all in
>MDE
[quoted text clipped - 5 lines]
> forms and reports require copying data into non-mde, creating new mde,
> replicating and replacing each database. What is the better way?

Reply to this Message