ODBC Connect from MS Access to SQL Server 2000-Viable?

How viable is it to use MS Access as a front end (via ODBC) to a SQL Server
2000 database?

The users would access via the internet using a netgear vpn setup.

Thanks,

Paul SPaul Stanial wrote:
> How viable is it to use MS Access as a front end (via ODBC) to a SQL Server
> 2000 database?
> The users would access via the internet using a netgear vpn setup.
> Thanks,
> Paul S

I've seen this configuration more as an afterthought. What I mean is
that someone uses Access to design an application, complete with Forms
and Reports. Afterwards, they wish to put the data in SQL Server, but
they don't want to redo their Forms and Reports. From those projects
that I've moved the data to SQL Server, things have worked really well.

That being said, if this was a new application, I'd be deploying
something web-based (since you indicated that your users would access
via the internet). With many of the web-based tools out there, you can
quickly create applications as well.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba@.remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
the three"

ODBC and internet access

We are trying to restict internet access from certin computers but, it's still in place because we need to process credit cards. Is it possible to remove internet access and allow our SQL based program to still run credit cards because of the ODBC connection to the SQL server which has internet access?

ODBC connects via SQL Native Client which takes in the server name/ip address of the machine to connect. As long as your app can connect to sql server via an intranet connection, you do not need to have internet connection. However, if the only link between your app and the server is the internet, then you can't disable internet on the ODBC connection.

HTH

|||I don′t know if I got the situation described, is it like the following: ?

App -- Internet SQLServer

What is your actual concern here ? That the SQL Server is exposed to the internet ? Or that the app has internet access ?

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

In the case where you're trying to restrict access to the server to clients from specific IP address, you can do so using TDS endpoints. Please take a look at http://msdn2.microsoft.com/en-us/library/ms191220.aspx.

Thanks,

Il-Sung.