Cloud DB

[gary g]

I am not sure where to ask this, so if I am in the wrong forum let me know. This is just a general question. If two people need to access a specific DB, but are not connected via any kind of network, what is the best solution that would allow mutual access? One user is located in one part of the city, while the other is located in another. I presume it would be some sort of cloud setup, but am not sure what the first step would be or how this would be created. Any advice? Thanks.

 

[Pat Hartman]

A simple way to perform a proof of concept is to sign up for a free 90 day trial Azure account. You will be able to use SSMA (SQL Server Migration Assistant - download from MS if you don't have it) to "upsize" your Jet/ACE database to SQL Azure. You may need to change some of your DAO/ADO code to add "dbSeeChanges" to operations that update tables with autonumber PKs. You should also read some of the papers on Client/Server optimization for Access to make sure your queries and forms will operate efficiently against a SQL Server database.

Another alternative is Citrix if your company supports it.