<div>
can you give them access to the SQL server?
</div>


can you give them access to the SQL server?

<div>
They haven't spec'd it up yet, so I would assume they would install the SQL2000 server onto the RDP Server/Solution. &nbsp;There aren't too many users that need to access it simultaneously, so it shouldn't be too heavy.
</div>


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.

<div>
so why not letting them access to the real database using sql manager?
</div>


so why not letting them access to the real database using sql manager?

<div>
When you say 'remotely' do you mean from another computer on the same network or across the Internet? &nbsp;I suspect the latter as you mentioned VPN but thought I'd check...<br />
<br />
I assume you want to keep the Access 2003 front end?
</div>


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?

<div>
Yes - Across the web.<br />
Access 2003 - I think so as I don't think they would have the budget to move across to .Net
</div>


Yes - Across the web.
Access 2003 - I think so as I don't think they would have the budget to move across to .Net

<div>
<div class="content wysiwyg-content">
Several years ago, I created an Access 2003 ADP database linking directly to SQL2000. &nbsp;The client now wants to have a reliable way for several people to be able to access the database remotely.<br />
<br />
I could do with a bit of advice about the best way to do this. &nbsp;My initial thoughts were for a VPN/RDP solution, but I'm open to suggestions.
</div>
</div>


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.

Remote use of Access / SQL database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Remote access may refer to the connection to a data-processing system from a remote location, for example through a virtual private network remote desktop software, terminal emulation, or the activation of features of a business telephone system from outside the business's premises.