473,327 Members | 2,007 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Access 2002 security

I am creating a database in Access 2002 for a small firm that would
like security on the tables. They want some employees to have write
access only to tables, while others read-only.

I have not done anything with security since way back in version '97.
I'm reading some white papers I've found to gain knowledge of
current security issues.

My question is, can I create security problems with other access
programs I have created as I create users and groups for this new
program? I have a number of small programs I've done for others and
would hate to see that somewhere along the line users or groups pass on
to their databases.

I would not be opening any of the other databases and applying any
security - I just didn't want to fool around with this too much if
I end up causing myself problems in other databases.

If anyone has any links to good sites regarding security for access
2002 that would be helpful as well

Thanks for any insite.

Nov 13 '05 #1
3 1839
If you set up Access User Level Security (ULS) *correctly*
you should not mess up any other Access applications on your
machine or any other user workstations. The key to this process
is creating your own workgroup file and securing your database
with that MDW file. Do not mess with the default system.mdw
that Access uses, otherwise you really are going to cause problems.

You and everyone else will start the secured database application
through a desktop shortcut that tells Access which file you want
to open and *which* workgroup file you want to use. This way,
no other applications are affected and everyone can still make and
modify Access databases.

ULS is a difficult process to set up the first couple of times so
I highly recommend practicing on dummy databases until you
are really comfortable with the process. I would also recommend
that you read all of the ULS information I have accumulated here:

http://www.ltcomputerdesigns.com/JCR....html#Security

Good luck,
--
Jeff Conrad
Access Junkie
Bend, Oregon

"mar10" wrote in message:
news:11*********************@f14g2000cwb.googlegro ups.com...
I am creating a database in Access 2002 for a small firm that would
like security on the tables. They want some employees to have write
access only to tables, while others read-only.

I have not done anything with security since way back in version '97.
I'm reading some white papers I've found to gain knowledge of
current security issues.

My question is, can I create security problems with other access
programs I have created as I create users and groups for this new
program? I have a number of small programs I've done for others and
would hate to see that somewhere along the line users or groups pass on
to their databases.

I would not be opening any of the other databases and applying any
security - I just didn't want to fool around with this too much if
I end up causing myself problems in other databases.

If anyone has any links to good sites regarding security for access
2002 that would be helpful as well

Thanks for any insite.


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Nov 13 '05 #2
Thanks for the info and link - I now feel at least a little more secure
about playing around with security -

Nov 13 '05 #3
"mar10"wrote in message:
news:11**********************@o13g2000cwo.googlegr oups.com...
Thanks for the info and link - I now feel at least a little more secure
about playing around with security -


You can do it, but just give yourself some time.
You will not "get it" in an hour or two.
It takes time and patience, but when you really
have ULS mastered, it becomes an incredible
tool in your Access arsenal.

Good luck with your project,
--
Jeff Conrad
Access Junkie
Bend, Oregon

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet...
7
by: Campbellbrian | last post by:
I have a database that I thought had fairly tight security applied to it. It's in Access97. I'm running it also on a couple of machines that shipped with Access 2002. This is probably not a good...
3
by: icb | last post by:
Hi I have a front-end/back-end setup. The front-end utilises all unbound forms populating the back-end via the code I have written. All fine so far. Prior to splitting the database I ran the...
13
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine,...
2
by: TechBoy | last post by:
I am trying to learn on the fly about Access Security for an app we are developing. I realize Access security is an advanced subject with many details. I wanted to share a scenario and ask a...
3
by: TechBoy | last post by:
I had a useracct called xxx123 I had set up. Now there is a problem in that **every single** .mdb file I open now on my PC (regardless of age of the file, location of the file, etc) now asks for...
4
by: RM | last post by:
Had VS .Net 2002 installed on W2k Server SP3 and supported a number of web sites. Installed VS .Net 2003 on Friday and now all web sites using .Net & MS ACCESS get this strange error upon open. ...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
10
by: Walshi | last post by:
Hi all, I'm a relative newby to access and VBA etc. My forms and tables etc are working great and saving lots of time...However... I have two databases with the exact same table format. I want...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.