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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
EyalCommented:
so why not letting them access to the real database using sql manager?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andy BrownDeveloperAuthor Commented:
That's great - thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.