Remote use of Access / SQL database

Several years ago, I created an Access 2003 ADP database linking directly to SQL2000.  The client now wants to have a reliable way for several people to be able to access the database remotely.

I could do with a bit of advice about the best way to do this.  My initial thoughts were for a VPN/RDP solution, but I'm open to suggestions.
Andy BrownDeveloperAsked:
Who is Participating?
 
lamaslanyCommented:
VPN should work fine but performance may be an issue depending on the speed of the Internet connection and the amount of data that gets transfered.

RDP would give a more consistent experience and may be better for slower Internet connections but unless you already have a Terminal Server/Remote Desktop server it is likely to be the more costly of the two solutions.  
0
 
EyalCommented:
can you give them access to the SQL server?
0
 
Andy BrownDeveloperAuthor Commented:
They haven't spec'd it up yet, so I would assume they would install the SQL2000 server onto the RDP Server/Solution.  There aren't too many users that need to access it simultaneously, so it shouldn't be too heavy.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
EyalCommented:
so why not letting them access to the real database using sql manager?
0
 
lamaslanyCommented:
When you say 'remotely' do you mean from another computer on the same network or across the Internet?  I suspect the latter as you mentioned VPN but thought I'd check...

I assume you want to keep the Access 2003 front end?
0
 
Andy BrownDeveloperAuthor Commented:
Yes - Across the web.
Access 2003 - I think so as I don't think they would have the budget to move across to .Net
0
 
Andy BrownDeveloperAuthor Commented:
That's great - thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.