Prev: Need End User Trainers (3 positions) , North carolina, NC
Next: Senior Cognos Consultant Detroit, MI
From: PW on 4 May 2010 16:22
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

From: Rich P on 4 May 2010 16:35
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 ***
From: Arvin Meyer on 4 May 2010 16:35
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(a)ifIremember.com> wrote in message
news:pbv0u5h908e4u73frgkhbms5aqcginefh3(a)4ax.com...
> 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
>


From: PW on 4 May 2010 21:57
On Tue, 4 May 2010 16:35:39 -0400, "Arvin Meyer" <arvinm(a)invalid.org>
wrote:

>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.

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
From: PW on 4 May 2010 21:58
On 04 May 2010 20:35:07 GMT, Rich P <rpng123(a)aol.com> wrote:

>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 ***

Thanks Rich

-paulw
 |  Next  |  Last
Pages: 1 2 3 4 5 6
Prev: Need End User Trainers (3 positions) , North carolina, NC
Next: Senior Cognos Consultant Detroit, MI