Replication of VBA module

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gb - 19 Sep 2005 23:12 GMT

Hi

I was asked to write a small demo system in Access 2000 which, of course, as
always happens is now live and being used by 21 users and, as the data is
confidential to each user means maintaining 21 copies of the database. When
I get the opportunity I will split the database into a Front and Back End
but in the interim I was wondering if there is any easy way of replicating
the code from one of my VBA modules to the 21 database copies. I would be
quite happy to copy the whole module.

Does anyone have any suggestions

many thanks

Gordon Bathurst

Reply to this Message

Douglas J. Steele - 19 Sep 2005 23:23 GMT

Replication should only be used for Jet objects (tables and queries). It
shouldn't be used for Access objects (forms, reports, macros and modules)

Splitting it should only take a matter of minutes, so do it now. Then you
can use the free Auto FE Update Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm

Signature

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

> Hi
>
[quoted text clipped - 11 lines]
>
> Gordon Bathurst

Reply to this Message

gb - 12 Oct 2005 20:32 GMT

Sorry Douglas, I forgot to say thanks for your help.

Gordon

> Replication should only be used for Jet objects (tables and queries). It
> shouldn't be used for Access objects (forms, reports, macros and modules)
[quoted text clipped - 18 lines]
>>
>> Gordon Bathurst

Reply to this Message