Restricting access to DB
-
Hello, I would like to limit access to the MS Access database that my app uses. Ideally, it would not be accessible at all from outside the app. My app will provide means to initialize and copy the database with the copy being accessible. Is there a way to do this either on the MS Access side or the VC++ side? Thanks. Paul Ebert
-
Hello, I would like to limit access to the MS Access database that my app uses. Ideally, it would not be accessible at all from outside the app. My app will provide means to initialize and copy the database with the copy being accessible. Is there a way to do this either on the MS Access side or the VC++ side? Thanks. Paul Ebert
Hi, The good news: There is a comprehensive security setup document suite inside the help files of Access. It is relatively easy to read. The bad news (for me): I could not get it to work reliably and usually couldn't get the options that I wanted. I gave up eventually. My advice: download the miniSQL server version from vstudio in MSDN. It's called MSDE. Here's a link to a Jet vs MSDE debate: http://msdn.microsoft.com/library/default.asp?URL=/library/backgrnd/html/msdeforvs.htm&RLD=462. Here's a link to the MSDE itself: http://msdn.microsoft.com/library/default.asp?URL=/library/backgrnd/html/msdeforvs.htm Hope this helps. Kind regards, Al. VBer who wants to go back to, but will have to learn again, C++. I'll carry on using VB for the front-end; so when I get proficient at C++/STL can I jump straight to ATL and avoid the MFC?