 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / December 2007mdb as client server
I would like to develop a new client server like multi users application using mdb file. I just wanted ti know can MS Access mdb file can create a database like server on the LAN and clients to link table on the server. Does mdb support store procedures like SQL server? If it is multi users then will MS Access lock the server database when one user uses the app. Are there any ways to set security down to column level? Your information is great appreciated, >I would like to develop a new client server like multi users application >using mdb file. Sharing an Access MDB on the file server is not true client server. >I just wanted ti know can MS Access mdb file can create a database like >server on the LAN and clients to link table on the server. No. See above. >Does mdb support store procedures like SQL server? No. >If it is multi users then will MS Access lock the server database when one >user uses the app. Yes, Access is multi user. And no one user doesn't lock the database unless the user is missing create rights as otherwise the LDB file can't be created. Thus Access only allows one user in at a time. Also you must split the MDB into a front end and back end. >Are there any ways to set security down to column level? No. Tony  SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >>Are there any ways to set security down to column level? > > No. Er, yes there is. You have to use Jet ULS and RWOP queries specifically designed with the columns involved. This can be inefficient or very efficient, depending on the requirements and exactly how you implement it. Of course, Jet ULS is breakable, but it can be sufficient in a large number of circumstances. SignatureDavid W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ >>>Are there any ways to set security down to column level? >> [quoted text clipped - 7 lines] >Of course, Jet ULS is breakable, but it can be sufficient in a large >number of circumstances. Ah, that hadn't occurred to me. It'd be a certain amount of work of course. And neither had the use of ADPs. Tony SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ I understand that mdb file on the share folder is not true client server application. Because I do not have resource to use SQL server as backend, I would like to do it is like client server. My questions are: Can MS Access have multi users and password login to identify user login? Can I use macro to run several queries work like stored procedures? Can I have a mdb only database and many client only query on the form to have different level to access and protect data? It all the answers are yes, I think I can use MDB works like client server application, but not true one. Thanks millions again, > >I would like to develop a new client server like multi users application > >using mdb file. [quoted text clipped - 24 lines] > > Tony > My questions are: > Can MS Access have multi users and password login to identify user > login? Yes, using Jet user-level security. It's a complex topic so you should read up on it before embarking on implementing it. > Can I use macro to run several queries work like stored > procedures? No need for macros -- program it in VBA. > Can I have a mdb only database and many client only query on the > form to have different level to access and protect data? You seem to be confusing two issues: 1. permissions on the data. 2. privileges in the UI. You set permissions on the data in the back end, using Jet user-level security. In the front end UI, you can control who can use which UI components based on Jet ULS group membership. > It all the answers are yes, I think I can use MDB works like > client server application, but not true one. Your questions really don't have anything at all to do with Client/Server -- they are all security and application questions. SignatureDavid W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ Thanks millions, > > My questions are: > > Can MS Access have multi users and password login to identify user [quoted text clipped - 28 lines] > Your questions really don't have anything at all to do with > Client/Server -- they are all security and application questions. David's already answered. >Can MS Access have multi users and password login to identify user login? Another approach would be some home grown security using the Windows userid. API: Get Login name http://www.mvps.org/access/api/api0008.htm But that wouldn't be as secure as using Access security. Tony SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >I understand that mdb file on the share folder is not true client server >application. >Because I do not have resource to use SQL server as backend, I would like to >do it is like client server. I'm not sure what kind of resource you don't have, but if it's money, you might want to check out the free Express version of SQL Server. It can probably do anything that you need, it can be used with and Access front-end to build a true client server application, and did I mention that it's free? :) http://www.microsoft.com/sql/editions/express/default.mspx Armen Stein Microsoft Access MVP www.JStreetTech.com No. Yes. Especially if you use the ADP file format. No. The locking strategy is up to the server database, not the front-end application. No. Unless you roll your own. -Tom. >I would like to develop a new client server like multi users application >using mdb file. [quoted text clipped - 9 lines] > >Your information is great appreciated, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.