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

[Paul Stanial]

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

[Brian Peasland]

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