Replication and Macro Failure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marguerite - 27 Oct 2004 16:47 GMT

I created a database in Access 2000. When the workgroup increased from 5 to
15, some being 1500 miles apart, I replicated the database for performance
reasons. Now everyone can run the replicated copies fine except one user.
When she tries to run the copy on her C drive, it says "Macro cannot be
found". Yesterday, in working with her, I tried to access the Design Master
on her PC, and it ran! It found the macros and did everything it was
supposed to. So I tried running the replica on the file share (which I
regard as my replica master). It gave me the same error. This is similar to
the question Mike T. related in August. But I have more information. Can
anyone please help?

Signature

Marguerite

Reply to this Message

Douglas J. Steele - 27 Oct 2004 22:38 GMT

Are you saying that the application isn't split into a front-end (containing
the queries, forms, reports, macros and modules) and a back-end (containing
the tables)? All replication is intended for is data. In other words, only
the back-end should be replicated. If you make changes to the front-end,
simply replace the front-end file on each user's desktop.

Signature

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

> I created a database in Access 2000. When the workgroup increased from 5 to
> 15, some being 1500 miles apart, I replicated the database for performance
[quoted text clipped - 6 lines]
> the question Mike T. related in August. But I have more information. Can
> anyone please help?

Reply to this Message