Programmatically updating replicas...

[Guest]

I am very new to Access, but I have a decent amount of VBA knowledge from
programming in Excel... I have a situation I could use a little help with. I
have created a database and several replicas that feed information to a very
complex userform in Excel. The userform can detect network connectivity and,
if offline, will use a local copy of the database. I would like to know how
to have the replicas sync with the server when the machine connects to the
network -OR- where to find the information to be able to do this...

Thanks for any information

 

[Scott McDaniel]

I am very new to Access, but I have a decent amount of VBA knowledge from
programming in Excel... I have a situation I could use a little help with. I
have created a database and several replicas that feed information to a very
complex userform in Excel. The userform can detect network connectivity and,
if offline, will use a local copy of the database. I would like to know how
to have the replicas sync with the server when the machine connects to the
network -OR- where to find the information to be able to do this...

If you're talking about Access Replication, then try the Replication FAQ:
http://support.microsoft.com/default.aspx/kb/282977

When you say you have "several replicas", are you syncing them back to the design master and THEN using them to fill
your Excel userform? Or does the userform attempt to combine the data in the replicas?

Also, there are newsgroups devoted to Access replication; perhaps you could post a question in those forums, might get
more complete answers there.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Guest]

If you're talking about Access Replication, then try the Replication FAQ:
http://support.microsoft.com/default.aspx/kb/282977

When you say you have "several replicas", are you syncing them back to the design master and THEN using them to fill
your Excel userform? Or does the userform attempt to combine the data in the replicas?

Also, there are newsgroups devoted to Access replication; perhaps you could post a question in those forums, might get
more complete answers there.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Yes I am talking about Access replication - I didn't have "Replication" as
one of the forums to choose from in the Office Online Discussion Groups. I'll
try using a news reader instead.

The Excel form doesn't care one way or the other which database it uses. It
just looks for the network version first and if it can't find it, it looks
for the local copy. I'm just looking for a way to keep the local and the
network copies sync'd.

Thanks for the info, Scott.

 

[Scott McDaniel]

Yes I am talking about Access replication - I didn't have "Replication" as
one of the forums to choose from in the Office Online Discussion Groups. I'll
try using a news reader instead.

The newsgroup name is microsoft.public.access.replication

The Excel form doesn't care one way or the other which database it uses. It
just looks for the network version first and if it can't find it, it looks
for the local copy. I'm just looking for a way to keep the local and the
network copies sync'd.

You mention "local and network copies" ... have you replicated the databases on a LAN? Generally replication is used for
remote offices/users (think of a travelling salesman type of scenario), while a "split" database is used for local
network users. In the split scenario, you split your database into a "frontend" (forms, reports, modules, and queries)
and a "backend" (tables only), then deploy a frontend to each user. Each of those frontends would connect to the same
backend, so all users would enter/edit data in the SAME file (the backend) ... at this point, your Excel userform would
hook up to the backend database ...

Thanks for the info, Scott.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com