Replication of a stand-alone application

[cwarner]

Hi,

I want to replicate my Access front-end, SQL-server back-end application, so that I can distribute to other locations. The app is stand-alone for each user; different data. Right now my Access app works with SQL server DEVELOPER edition, and my question is, how do I configure my Access app to talk to the SQL server in other locations, once replicated? My server name is "cwsqlserver" in my connection string; how will I know what other people's connection string data sources (server name) are? Do I force the naming of the server, and if so, how?

Thanks!
Christy.

 

[donutman]

Wrong forum, you should post in the Access forum.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]