Replication and MDE

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

I am trying to create MDE files for a database that i have replicated. I am
doing this from the Design Master.

I keep getting the message "you cannot create a Microsoft Access MDE from a
Microsoft Access Replica"

How do i protect my VB Code?

thanks
 
andy said:
I am trying to create MDE files for a database that i have replicated. I am
doing this from the Design Master.

I keep getting the message "you cannot create a Microsoft Access MDE from a
Microsoft Access Replica"

How do i protect my VB Code?

thanks
Click to expand...
Split the database in a front and backend. Frontend: unreplicated forms and
procedures,
keep the data in the replicated backend database.
 
andy said:
I am trying to create MDE files for a database that i have replicated. I am
doing this from the Design Master.

I keep getting the message "you cannot create a Microsoft Access MDE from a
Microsoft Access Replica"
Click to expand...

And to add to Frits response Michael Kaplan has stated that
replication was only ever meant to be used for tables and data and
never other objects such as queries, forms, reports, macros and
modules.

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
 
andy said:
My database has a design master on one machine and is replicated on 3
different machines in different countries. The syncronisation takes place
over dial-up, usually daily. Do i put the data and structure Access files
on all the machines, with the data.mdb set to replica.

And can i remove the Replicate property from all the forms, as they are
currently set to replicate. Thanks
Click to expand...

Well, you should really be splitting your MDB and replicating just the
BE. Distribute new complete new copies of your FE via email, network
share or whatever.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at my website for more info.

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
 
Back
Top