Forums
This topic is locked
Secure ODBC and access databases
Posted 13 Feb 2004 21:22:36
1
has voted
13 Feb 2004 21:22:36 Rene Bandsma posted:
Is there a good way to secure access databases and the ODBC records?In Access you can set a password (Tools, Security, set password) but you cannot set a username (while it can be set in DMX).
Has anyone a good tutorial or website where I can find most aspects about this database (odbc + access) or should I move to MS SQL server?
Replies
Replied 16 Feb 2004 01:26:44
16 Feb 2004 01:26:44 Phil Shevlin replied:
Why not use some type of login for the pages that view, edit the database. What is the purpose you are trying to achieve?
Replied 16 Feb 2004 11:46:55
16 Feb 2004 11:46:55 Rene Bandsma replied:
Maybe I didn't explain the situation right...
The pages that can edit the database are protected with a password.
We have a FTP server where more than 10 people have access to, there are only 2 people who are allowed to edit the databases. When you use DMX, you can easily gain access to ODBC datasources and edit them. I want to use a password for ODBC (Can be set in DMX, but is not working.)
I am planning to 'shift' to OLE DB connections in stead of ODBC.
The pages that can edit the database are protected with a password.
We have a FTP server where more than 10 people have access to, there are only 2 people who are allowed to edit the databases. When you use DMX, you can easily gain access to ODBC datasources and edit them. I want to use a password for ODBC (Can be set in DMX, but is not working.)
I am planning to 'shift' to OLE DB connections in stead of ODBC.