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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jim Horn
Hi Jim Thanks for the advice. I will re enter the question
Alan
Hi Jim Thanks for the advice. I will re enter the question
Alan
ASKER
JDettman
Taking Jims advice and re entering the question.
Alan
Taking Jims advice and re entering the question.
Alan
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.c
Thanks,
Sam