hey. i have a small access database that runs part of my site and i was wondering how i would secure that so that not just anyone can write to it? and the what conn string would i use?password protect your folders and/or you have to use member status to add stuff.as scoutt mentioned, you use secure logins to control access to your database. I'm not as familiar with access as I am with relational databases... but you may be able to restrict user access down to the table level as well.
Basically you set up a webuser that your server side scripting uses to access to the database. Generally this access has limited funtionality... such as read, insert, and update.... but not delete, truncate, create, drop etc.
Basically you set up a webuser that your server side scripting uses to access to the database. Generally this access has limited funtionality... such as read, insert, and update.... but not delete, truncate, create, drop etc.