Access is not secure at all (any version, numerous password hack tools),
however if you have Access on a secure PC that is running a web server (IIS)
the Access database will be less vulnerable than SQL Server 2000 database
since Access does NOT and can NOT "listen" on any communications port
because it doesn't have a Service running. However, if you want to keep
Access secure internally you'll need to make sure your server's directory
rights are setup correctly. Suggest you put the Access MDB in a directory
that is restricted to just your ASP.NET web app code.
"phil cunningham" <phil@NOS_oakleafsoftware.co.uk> wrote in message
news:Ot**************@TK2MSFTNGP11.phx.gbl...
I did double post this and it has been answered elsewhere so please ignore
Phil
"phil cunningham" <phil@NOS_oakleafsoftware.co.uk> wrote in message
news:eR**************@TK2MSFTNGP11.phx.gbl...I am using Access to run a database within the company and also have a
website that makes some of the information available to the general
public
And so far everything is working very well
q. is there any problem using Access to do all our internal work while
the
DB is exposed to the web
q. if I move to SQL server can I still use all the features of Access
(VBA
reporting etc) for our internal work
I really like Access and would hate to have to do everything through
ASP.NET
if I don't have to
I think I just need a little advise before I get stuck into the
development
work
Any feedback will be much appreciated
Phil
PS I may have double posted this!