Link to home
Start Free TrialLog in
Avatar of chestera
chestera

asked on

Access to Sql Server migration advice

Hi

I need to place my Access data away from the server so that users in other locations can access it. Sql Server seems to be the recommended way to go. In this technological changing world is there a simpler method of accessing date remotely. I have looked at Sql Server 2008 and so far all I have been able to do is up size the data the rest is a bit confusing. Anyt help appreciated.

chestera
Avatar of sameer2010
sameer2010
Flag of India image

Hi,

You can use SQL Server for allowing remote access. You could either provide authorization to access data from server or abstract it and provide access through application.
Read the following articles on remote configuration for SQL Server.
http://technet.microsoft.com/en-us/library/ms191464(v=sql.105).aspx

Thanks,
Sam
Avatar of chestera
chestera

ASKER

sameer2010

Hi Sam

I have booked mark web site I will read and digest. So my question Sql server is still the way to go. I have been told there are sites that you can subscribe to and place the data for every body to access. This is completely new territory for me.

Alan
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Jim Horn

Hi Jim Thanks for the advice. I will re enter the question

Alan
JDettman

Taking Jims advice and re entering the question.

Alan