D
Dax Arroway
Our club has an Access Membership DB on a localhost
machine. We're also designing a "Member's Only" section
on the club's website which needs to validate current
members. I've set an Access DB with one table (onTbl)
with names, passwords, and usernames on the server. It
would be nice to simply place the Membership DB on the
server but the club DOES NOT want the membership DB on
the server due to sensitive personal member's
information. So, in the localhost Membership DB, we've
created a table (offTbl) with name and dues-paid-through
feilds that links to the Membership Table (MemTbl). What
I'm looking for is a way to synch the onTbl DB Table with
the offTbl DB Table.
The localhost DB is stored on the Membership Chair's
computer at home and she is only on a dial-up
connection. I'm not looking for a script to make the
connection. She can do that herself when she's ready to
synch. New members will be added to the Membership DB by
the chair herself on her machine. So, when that happens
we need a way to have that new member uploaded to the
server. So, What I need is to figuring out how to get
the two DBs to talk to each other. I need the
information on the offTbl table on the localhost to synch
with the onTbl on the server and visa-versa.
I hope that makes sense. Does anyone know a way of doing
this? Or if you have any questions please ask. Thanks
so much in advance.
- Dax
machine. We're also designing a "Member's Only" section
on the club's website which needs to validate current
members. I've set an Access DB with one table (onTbl)
with names, passwords, and usernames on the server. It
would be nice to simply place the Membership DB on the
server but the club DOES NOT want the membership DB on
the server due to sensitive personal member's
information. So, in the localhost Membership DB, we've
created a table (offTbl) with name and dues-paid-through
feilds that links to the Membership Table (MemTbl). What
I'm looking for is a way to synch the onTbl DB Table with
the offTbl DB Table.
The localhost DB is stored on the Membership Chair's
computer at home and she is only on a dial-up
connection. I'm not looking for a script to make the
connection. She can do that herself when she's ready to
synch. New members will be added to the Membership DB by
the chair herself on her machine. So, when that happens
we need a way to have that new member uploaded to the
server. So, What I need is to figuring out how to get
the two DBs to talk to each other. I need the
information on the offTbl table on the localhost to synch
with the onTbl on the server and visa-versa.
I hope that makes sense. Does anyone know a way of doing
this? Or if you have any questions please ask. Thanks
so much in advance.
- Dax