Security on Access DB

[schueymcfee]

Anybody know if it would be safe to hold important information on an Access database?

If so whats the best way to make it secure?

[Liszt]

It is fairly secure.

You can password protect it, but that can be broken, if you try hard enough.

It can be backed up and moved easily enought as it is just one file.

It all depends on how critical the data is on its suitability.

Also consider where the file will reside. Secure network, DMZ, dirty network, web server, standalone PC? Consider how easy it would be for an external hacker to get at it remotely, and an internal black hat to get at it physically.

[pdV6]

How important is 'important', though, as Access has a horrid habit of corrupting itself from time to time. Frequent backups and frequent repair/compact-ing would be advised.

[plotloss]

Yep gotta go with that, if its truly important I wouldnt put it anywhere near that bloody Access thing...

[pdV6]

We advise our smaller customers to give Access a miss now and download MSDE instead.

[plotloss]

Yeah I noticed that installing when I installed VS.NET the other day.

'andy 'arry...

[schueymcfee]

Well, the DB would be on a web server and it may hold personal details such as credit card details, but not sure yet. Not sure whether I should risk it...

>> Edited by schueymcfee on Thursday 26th August 15:34

[plotloss]

mySQL may be a better bet for that sort of thing...

[schueymcfee]

plotloss said:

mySQL may be a better bet for that sort of thing...

I was thinking the same...

Is it easy to use ASP with mySQL, I don't fancy re-writing all my scripts to PHP....

>> Edited by schueymcfee on Thursday 26th August 15:38

[Liszt]

schueymcfee said:

Well, the DB would be on a web server and it may hold personal details such as credit card details, but not sure yet. Not sure whether I should risk it...

Ok in that case l would probably recommend, SQL server, Oracle, DB2 etc.

Don't know mySQL so can't comment on it.

[anonymous-user]

schueymcfee said:

Is it easy to use ASP with mySQL, I don't fancy re-writing all my scripts to PHP....

Look out for myODBC - it's an ODBC driver for mySQL.

That way, you can use ADO in pretty much the same way that you do for Access with mySQL just by changing the connection string.