S
Steve Mahon
I have an Access 2003 front end + SQL server 2005 back end applicaton that
works great on our lan. I want to deploy it to remote offices and field
workers that do not have consistent connectivity to our LAN. I've been
playing with merge replication in SQL, and it seems like a good solution. The
clients are Vista machines. I've already set up replicas of the database that
successfully sync via Syn Center + VPN. I've used the default named instance
"SQLExpress" on each machine, and named the database "ASCReplica". Now here
is where I can't sort things out.
Access is not installed on the clients, so I need the applicaiton to run on
Access Runtime, but I don't know how to point the links to the correct SQL
Server once I install the MDE onto the client, since each one has a different
computer name.
Can this be accomplished somewhere in the Solution Packer? Perhaps it can be
done programmatically in VBA? It would be nice if I could create 1 MDE that
could be coppied to each machine and would be self-configuring for that
machine's instance of SQL Express. That way when I update the application, I
only need to send the new MDE.
Any help is much appreciated.
works great on our lan. I want to deploy it to remote offices and field
workers that do not have consistent connectivity to our LAN. I've been
playing with merge replication in SQL, and it seems like a good solution. The
clients are Vista machines. I've already set up replicas of the database that
successfully sync via Syn Center + VPN. I've used the default named instance
"SQLExpress" on each machine, and named the database "ASCReplica". Now here
is where I can't sort things out.
Access is not installed on the clients, so I need the applicaiton to run on
Access Runtime, but I don't know how to point the links to the correct SQL
Server once I install the MDE onto the client, since each one has a different
computer name.
Can this be accomplished somewhere in the Solution Packer? Perhaps it can be
done programmatically in VBA? It would be nice if I could create 1 MDE that
could be coppied to each machine and would be self-configuring for that
machine's instance of SQL Express. That way when I update the application, I
only need to send the new MDE.
Any help is much appreciated.