473,386 Members | 1,721 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

How secure is MSAccess?

I am creating a new ASPX web app. I would like to use MS Access, but am
concerned about security. There will be alot of secure info in this db
(credit cards, passwords, client info, etc...) Is Access secure enough or
should I just go with MS SQL Server? I like the portability of the MDB.

Also, any good links/suggestions on how to secure your db interactions (ie
ConnectionString in web.config, passwords/credit card info in tables,
etc....)

Thanks!
Nov 18 '05 #1
6 1235
Mixing portability with security?!?!?!

Go with MSDE instead (the free version of SQL-Server but limited to 2Gg for
the size of the database).

S. L.

"VB Programmer" <Do*****************@jEmail.com> wrote in message
news:Ow**************@TK2MSFTNGP11.phx.gbl...
I am creating a new ASPX web app. I would like to use MS Access, but am
concerned about security. There will be alot of secure info in this db
(credit cards, passwords, client info, etc...) Is Access secure enough or
should I just go with MS SQL Server? I like the portability of the MDB.

Also, any good links/suggestions on how to secure your db interactions (ie
ConnectionString in web.config, passwords/credit card info in tables,
etc....)

Thanks!

Nov 18 '05 #2
Sylvian,
Mixing portability with security?!?!?!
You wrote exactly what I was thinking when I readed the message.

:-)

Cor
"Sylvain Lafontaine"
.. Mixing portability with security?!?!?!

Go with MSDE instead (the free version of SQL-Server but limited to 2Gg
for the size of the database).

S. L.

"VB Programmer" <Do*****************@jEmail.com> wrote in message
news:Ow**************@TK2MSFTNGP11.phx.gbl...
I am creating a new ASPX web app. I would like to use MS Access, but am
concerned about security. There will be alot of secure info in this db
(credit cards, passwords, client info, etc...) Is Access secure enough or
should I just go with MS SQL Server? I like the portability of the MDB.

Also, any good links/suggestions on how to secure your db interactions
(ie ConnectionString in web.config, passwords/credit card info in tables,
etc....)

Thanks!


Nov 18 '05 #3
"VB Programmer" <Do*****************@jEmail.com> wrote in message
news:Ow**************@TK2MSFTNGP11.phx.gbl...
Is Access secure enough


http://lastbit.com/access/default.asp
http://www.lostpassword.com/access.htm
http://www.passwordservice.com/access/index.htm
Nov 18 '05 #4
On Mon, 22 Nov 2004 11:48:40 -0500, "VB Programmer" <Do*****************@jEmail.com> wrote:

¤ I am creating a new ASPX web app. I would like to use MS Access, but am
¤ concerned about security. There will be alot of secure info in this db
¤ (credit cards, passwords, client info, etc...) Is Access secure enough or
¤ should I just go with MS SQL Server? I like the portability of the MDB.
¤
¤ Also, any good links/suggestions on how to secure your db interactions (ie
¤ ConnectionString in web.config, passwords/credit card info in tables,
¤ etc....)

As a data store it isn't the most secure. In addition, if this is a multi-user application then I
would also recommend SQL Server instead.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 18 '05 #5
If you could get to the SQL.dat file could you not just bring it right into
an existing sql server and read the data directly?

Both options would require direct access to the data file.

I guess I am just thinking outloud.

"Mark Rae" <ma**@mark-N-O-S-P-A-M-rae.co.uk> wrote in message
news:eL**************@TK2MSFTNGP11.phx.gbl...
"VB Programmer" <Do*****************@jEmail.com> wrote in message
news:Ow**************@TK2MSFTNGP11.phx.gbl...
Is Access secure enough


http://lastbit.com/access/default.asp
http://www.lostpassword.com/access.htm
http://www.passwordservice.com/access/index.htm

Nov 18 '05 #6

Access is not secure at all. You will have to do it with standard
operating procedures.

You can start with limiting physical access to the machine (limited
access area).
Keep database files out of network shares and not under wwwroot directory.
Use strong passwords for everything.
Keep the server patched.
Limit access to backup tapes/files/media.
Don't store or hardcode passwords.
VB Programmer wrote:
I am creating a new ASPX web app. I would like to use MS Access, but am
concerned about security. There will be alot of secure info in this db
(credit cards, passwords, client info, etc...) Is Access secure enough or
should I just go with MS SQL Server? I like the portability of the MDB.

Also, any good links/suggestions on how to secure your db interactions (ie
ConnectionString in web.config, passwords/credit card info in tables,
etc....)

Thanks!


Nov 18 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Brad Burke | last post by:
From a windows .Net app, I need to 1) check if MSAccess is already open to a certain Access application. If so, then open a form and find a certain record. 2) If not open, then open MSAccess and...
15
by: (Pete Cresswell) | last post by:
I've got a .BAT file that I use for executing various MS Access apps that I wrote way back in the days of 2.0. It's evolved over time, but it still contains a number of possible paths to...
2
by: Wayne Aprato | last post by:
I have been given a secure .mdb file, the .mdw file and the appropriate user name and password. How do I actually open the mdb using the mdw and the supplied username and password. Thanks in...
0
by: Richard Beacroft | last post by:
Trying to write a C# Windows App to export all objects and content from 2 MSAccess 97 databases for comparison analysis. very little documentation found. Have managed to instantiate MSAccess,...
0
by: MLH | last post by:
I've been unable to determine the correct setting to force a copy of msaccess.exe to be written to target disk during runtime installation process. It may be that the runtime installation...
4
by: Jamey Shuemaker | last post by:
A2k2 with user-level security and all preventive measures, vis a vis, Security FAQ enabled or enacted. I've got three DBs, which due to size constraints can't, or rather, probably shouldn't be...
2
by: reidarT | last post by:
I am making an installation program for an Access application. The application is run on both Office 2000, 2002, 2003 and soon 2007 versions of Office, When I install the application I need a...
1
by: rolandsk | last post by:
I need help to schedule a MsAccess procedure I want the procedure to run in backgrund and not the MsAccess file to be open during the time when the procedure runs. The procedure in MsAccess picks...
0
by: bbrewder | last post by:
I am struggling with some MSAccess automation issues. Basically, we have a .Net application that uses MSAccess for reporting (legacy code). We are able to launch MSAccess fine and even work with...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.