Hi,

Mom is in one state, daughter is in another. Mom mostly takes
reservations over the phone, and once in a while the daughter will.
Both can be entering in new clients.

I am trying to think if synching the two databases (most like will be
emailing them back and forth or using Remote Desktop) would be
possible.

One main table:

Clients!ClientID (Parent)

Then multiple supporting child tables:

Reservations!ReservationID which links to Clients!ClientID

RoomAssignments!AssignmentID which contains both ClientID and
ReservationID

Activities!ActivityID which relates to Reservations!ReservationID
(using Activities!ReservationID)

And various other child records.

All ID fields are autonumbers so they can not be relied on to relate
properly to both databases. ID fields will not always match up, at
least with new records.

I am trying to think how ActiveSync, for instance, synchs with mobile
devices. User specifies if "mom" overides "daughter", or "daughter"
overides "mom" or both synch together.

Any ideas if this is possible (and how)?

-paulw

For a scenario like that you would need to build a web application with
a sql server backend. Access is file based and is not well suited for
wide area network operations.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

For just 2 users, remote desktop is the way that I'd go. Make sure that each
user is still using their own copy of the front-end.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"PW" <emailaddyinsig (AT) ifIremember (DOT) com> wrote

On Tue, 4 May 2010 16:35:39 -0400, "Arvin Meyer" <arvinm (AT) invalid (DOT) org>
wrote:

So I would just use my table reattachment module which brings up a
window for the user to point to where the data file is and she would
be able to see the mdb on the remote pc?

Is that how it would work in this case with only the front-end on one
PC?

-paulw

On 04 May 2010 20:35:07 GMT, Rich P <rpng123 (AT) aol (DOT) com> wrote:

Thanks Rich

-paulw

PW <emailaddyinsig (AT) ifIremember (DOT) com> wrote in
newsbv0u5h908e4u73frgkhbms5aqcginefh3 (AT) 4ax (DOT) com:

I think for this purpose, I'd go with hosted Sharepoint and use it
to synch between databases. Dunno if that works reliably and
efficiently with what's currently available (A2007), but what's
coming with A2010 and Sharepoint 2010 with Access Services would
serve the purpose quite well.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

If you are connecting through a PC instead of a server, make sure that you
have a folder with a second copy of the front-end. Remember, there is no
difference (effectively) between a local user and a remote user. I would
think that without a terminal services server, there may be some performance
issues. What I've always done in that situation is to connect to a running,
but unused PC (like logging into my workstation at work, from a laptop while
on the road)

Two people cannot really use the same workstation remotely. They wind up
fighting for control of the mouse, keyboard, etc. There are PC thin client
programs that function like a server though. Here's 1:

http://www.thinsoftinc.com/product_t...server_vs.aspx
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"PW" <emailaddyinsig (AT) ifIremember (DOT) com> wrote

Hi Arvin,

I am not sure what you mean or why that is necessary. That would be
on the PC connecting? The data would most likely be somewhere else
than the PC that she would be connected to (another PC, or a server)
as there may be mutliple users there.

Thanks,

-paulw

On 5 May 2010 02:55:35 GMT, "David W. Fenton"
<XXXusenet (AT) dfenton (DOT) com.invalid> wrote:


Thanks David. I don't know anything about Sharepoint but will do some
research.

-paul

It is necessary because multiple users on the same front-end WILL eventually
cause a corruption.

A server is a standalone machine that stores and serves files. No one works
on a server. That means in a 2 user situation you have 3 machines, a server
and 2 PCs. If you are using a peer to peer network (only 2 machines) only
one user should be working at a time (for terminal services). On a
peer-to-peer LAN there can be 2 machines without a server, and both users
can work at the same time.

In ALL cases you MUST use a separate front-end, linked to the data, for EACH
user. Anyone who tells you otherwise is wrong. If you do not have separate
front-ends you will corrupt eventually.

I can't make it any plainer than that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access



"PW" <emailaddyinsig (AT) ifIremember (DOT) com> wrote