If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Splitting - Ready Only
I am new to splitting and security. I read "Splitting a access database, or
how to run ms-access in a multi-user mode" by Albert D. Kallal. I split a database and created an MDE of the FE database (had to convert to 2002 to be able to do this). I distributed the MDE to a co-worker. I went to their computer and opened the MDE which seemed to work fine. I was still able to delete edit/delete data. I guess I thought splitting and creating an MDE would prevent users from editing/deleting. I want to prevent users from editing or deleting data. I want to give users the ability to create their own queries, but only want them to be able to view data. What is the best way to give users access to the data (read only) and still utilize the benefits of a fe/be on a network? Any assistance you can provide would be greatly appreciated. |
#2
|
|||
|
|||
Splitting - Ready Only
Only give them read-only access to the folder where the back-end exists.
Yes, they'll get an annoying warning every time they go into the database, but they won't be able to update it. Alternatively, you could use Access User-Level Security. If you want to go that route, check out http://support.microsoft.com/support...ent/secfaq.asp (Warning: Implementing Access User-Level Security is non-trivial. Make sure you've read the document several times before trying, work on a copy of your database, and don't skip any steps) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "KReese" wrote in message ... I am new to splitting and security. I read "Splitting a access database, or how to run ms-access in a multi-user mode" by Albert D. Kallal. I split a database and created an MDE of the FE database (had to convert to 2002 to be able to do this). I distributed the MDE to a co-worker. I went to their computer and opened the MDE which seemed to work fine. I was still able to delete edit/delete data. I guess I thought splitting and creating an MDE would prevent users from editing/deleting. I want to prevent users from editing or deleting data. I want to give users the ability to create their own queries, but only want them to be able to view data. What is the best way to give users access to the data (read only) and still utilize the benefits of a fe/be on a network? Any assistance you can provide would be greatly appreciated. |
#3
|
|||
|
|||
Splitting - Ready Only
The link doesn't work?
"Douglas J. Steele" wrote: Only give them read-only access to the folder where the back-end exists. Yes, they'll get an annoying warning every time they go into the database, but they won't be able to update it. Alternatively, you could use Access User-Level Security. If you want to go that route, check out http://support.microsoft.com/support...ent/secfaq.asp (Warning: Implementing Access User-Level Security is non-trivial. Make sure you've read the document several times before trying, work on a copy of your database, and don't skip any steps) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "KReese" wrote in message ... I am new to splitting and security. I read "Splitting a access database, or how to run ms-access in a multi-user mode" by Albert D. Kallal. I split a database and created an MDE of the FE database (had to convert to 2002 to be able to do this). I distributed the MDE to a co-worker. I went to their computer and opened the MDE which seemed to work fine. I was still able to delete edit/delete data. I guess I thought splitting and creating an MDE would prevent users from editing/deleting. I want to prevent users from editing or deleting data. I want to give users the ability to create their own queries, but only want them to be able to view data. What is the best way to give users access to the data (read only) and still utilize the benefits of a fe/be on a network? Any assistance you can provide would be greatly appreciated. |
#4
|
|||
|
|||
Splitting - Ready Only
Works fine for me!
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Kou Vang" wrote in message ... The link doesn't work? "Douglas J. Steele" wrote: Only give them read-only access to the folder where the back-end exists. Yes, they'll get an annoying warning every time they go into the database, but they won't be able to update it. Alternatively, you could use Access User-Level Security. If you want to go that route, check out http://support.microsoft.com/support...ent/secfaq.asp (Warning: Implementing Access User-Level Security is non-trivial. Make sure you've read the document several times before trying, work on a copy of your database, and don't skip any steps) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
splitting database w/ different versions | Susan | General Discussion | 2 | November 14th, 2005 05:01 PM |
database splitting | Garry | General Discussion | 3 | September 18th, 2005 07:32 PM |
Splitting a Target Figure | oldgit99 | Worksheet Functions | 3 | August 23rd, 2005 02:50 PM |
Slow Load Time After Splitting - Re Tony's Code | Nate via AccessMonster.com | Running & Setting Up Queries | 1 | March 30th, 2005 02:38 PM |
Help! Splitting Text And Numbers In The Same Cell | William | Worksheet Functions | 1 | February 3rd, 2004 04:46 AM |