D
darien.watkins
I am working on updating a Call log / Trouble Ticketing System that
was made in Access 2000 or 2003. The original application had a
design master on a network share, and the techs used replicas. This
allowed them to use locally if offline, and replicate once connected
to the network and they could do it simultaneously.
Now I'm trying to update to Access 2007 and also make it a bit more
robust. A couple of issues I've come accross.
Access new format does not support replication.
Cannot link table from a new format database either.
Now I'm not looking to use sharepoint. Here's what I'm thing of.
Database 1 is company data such as contacts, products, etc.
Database 2 is trouble ticket application with data linked from
Database 1.
Each tech has their own copy which synchronized to a master on the
server.
(This is neccesary as they might be on the road or in the
office)
What is the new method of thinking in Access 2007. I think I could VB
code some fancy hack, but i'm sure there's an approved method.
Thanks,
Darien
was made in Access 2000 or 2003. The original application had a
design master on a network share, and the techs used replicas. This
allowed them to use locally if offline, and replicate once connected
to the network and they could do it simultaneously.
Now I'm trying to update to Access 2007 and also make it a bit more
robust. A couple of issues I've come accross.
Access new format does not support replication.
Cannot link table from a new format database either.
Now I'm not looking to use sharepoint. Here's what I'm thing of.
Database 1 is company data such as contacts, products, etc.
Database 2 is trouble ticket application with data linked from
Database 1.
Each tech has their own copy which synchronized to a master on the
server.
(This is neccesary as they might be on the road or in the
office)
What is the new method of thinking in Access 2007. I think I could VB
code some fancy hack, but i'm sure there's an approved method.
Thanks,
Darien