 |
|
|
home > storefront 2000 > storefront 2000 knowledge base
|
Password-protecting your StoreFront 6.0 Access Database
|
|
Posted Friday, April 23, 2004 |
|
Some StoreFront 6.0 users have expressed a desire to apply password protection to the sf6.mdb database as an additional security measure. This can be done; however, if the web store's web.config file is not subsequently modified to include the newly applied password the store's pages will not able to connect to the database and errors will result. If you apply password protection to your web store's database, be sure to modify the web.config to reflect the new password according to the following instructions:
Modifying web.config to include a database password: -
Open your web store using Dreamweaver or FrontPage.
-
Open the web.config file and locate the following line of code. The code will appear all on the same line in the file, though it may wrap here due to space constraints:
<add key="StoreFront.DataAccess.ConnectionString" value=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[MapPath]db\sf6.mdb;User Id=Admin;Password=;" />
-
Modify the code to match the following example, where myPassword is your database password:
<add key="StoreFront.DataAccess.ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[MapPath]db\sf6.mdb;User Id=Admin;Jet OLEDB:Database Password=MyPassword;" />
-
Save the changes to the file.
|
|
Browse more...
StoreFront 2000 Knowledge Base
|
|
|
|
|
|
|
|
