Security Newsgroups: Access Security

Access-New User-Help!!

E. Barry Bruyea - 14 Jul 2006 9:34 PM - 20 messages

I have Microsoft Office XP 2002. When I first loaded Office, I installed all of its components, but until recently never had a use for Access. I was recently diagnosed with Diabetes and along with my tester, I purchased specialty software for tracking my Diabetes. Some ...

log on screen in Access?

Maria needs help - 14 Jul 2006 3:58 PM - 6 messages

For a reason unknown to me, Access now requires me to log in before doing anything. I did not set up any permissions and I am the only one using the program (on a personal computer). I cannot do anything at all... cannot ...

Programatically hide and unhide the database window

Patrick - 14 Jul 2006 3:46 PM - 4 messages

Hey! I don't know if this is the appropriate place, but I've looked and can not find a vba way to hide and unhide the database window? Can anyone point me in the right direction? Thank you! Patrick ...

Security nightmare - 2 mdw's mixed up

jct - 13 Jul 2006 6:30 PM - 51 messages

Sorry for the long post, but I'm hoping to give enough info to get a quick resolution. Thanks in advance. In testing stages of a security on database... I had security set and was testing it with another user and myself. The db was on a network server, and ...

Digital Certificate for runtime installs. (Not Self Cert)

Don - 13 Jul 2006 3:43 AM - 24 messages

I was wondering if anybody knows the best place to get a digital certificate for "commercial" use. NOT USING SELF CERT ...

Reopen the database for relogon

mike - 12 Jul 2006 8:52 PM - 5 messages

I have security on my DB and it works great until I leave the computer. How can I get it to go back to the logon screen. I don't want to have anyone use my logon. I have a button to exit access when I am done, but someone might ...

ldb won't delete

Pattyt - 12 Jul 2006 5:13 PM - 2 messages

Hello, I have a split DB running and when I try to open the back-end to do edits on a table, I get a message saying that I do no have exclusive access and that my changes may not save. When I checked the ldb files I found that there is ...

Disable Security - Use the standard .mdw file - Allow external apps to connect using DAO

vladimir.mcbadger - 12 Jul 2006 5:03 PM - 3 messages

I have a database that I tried to implement the access security using a stand alone .mdw security file. I no longer want to have the security implemented and want to make the DB completely unsecure. I have sort of achieved this - I can now distribute the DB freely and ...

deleting microsoft access user passwords

Charge - 12 Jul 2006 5:03 PM - 4 messages

I need to delete user passwords as the administrator on a access program, and have followed the "Help" instructions to no avail. ...

Record level access

Vanessa Jennings - 12 Jul 2006 3:21 PM - 4 messages

anyone know how I can give certain users access only to certain records within a database...too many forms and reports to redo for each user!... ...

** Security Issue While Linking Excel or Word to Access Database **

Adam Bataran - 12 Jul 2006 2:17 PM - 2 messages

Hello -- I have recently implemented security on a networked Access database (system. mdw is in the same network location). The security at a user level seems to be working fine. However, now that the security has been implemented, I am unable to link ...

mde file

Akilah - 12 Jul 2006 2:16 PM - 2 messages

I created a mde in a folder and copied it to other folder for other users. Sometimes the forms and queried don't function properly. Does the mde and mdb need to be in the same folder or can I make a mde in one folder and copy ...

Network Security multiple users, Getting rid of the warning messag

Daniel Lees - 12 Jul 2006 11:01 AM - 8 messages

Hi I am implementing a database that is to be shared on a network. I was wondering with the access security when a user is logged on and some1 else tries to log on with the same correct details what happens? Are they allowed ...

corrupt files

sidfarkas - 11 Jul 2006 10:27 PM - 7 messages

On June 27th at 7:46 pm all my database files ( in the same folder) became corrupt( Probably around 100 different files all with the same time stamp of June 27 7:46 pm) I think the file that did it was ...

Adv/disadv of using Access built-in security tools vs build in db

sisyphus - 11 Jul 2006 9:19 PM - 22 messages

This is a high level question. I can think of three ways, in general, to implement Access user-level security * Use the built in security tools to create workgroups and users ...

Unable to merge after sharing database

James - 11 Jul 2006 7:07 PM - 4 messages

What did I leave out? Added security in access 2003 and lost the abbility to merge with word 2003! ...

Creating security for MS Access application

PadmaBhaskar - 11 Jul 2006 4:28 PM - 5 messages

I have a MS Access application which would be on the network and multiple users must be able to access using their respective used ids. I wanted to create user ids and grant permissions based on user ids. First, I created a workgroup using Tools -> Security -> Workgroup ...

Startup problem with runtime and no-runtime apps

DaBartman - 11 Jul 2006 4:24 PM - 2 messages

This problem just cropped up about 10 days ago. When starting a program I get the security warning dialog (No, Open, More Information). Normally clicking Open allows the program to begin at it's startup page. I am using my ...

Can't add users and groups

parolam - 11 Jul 2006 3:17 PM - 2 messages

I create a new MDW file, then created a new database using the new mdw, then created a super user, then logged out and logged in as the super user. Then I removed all the permissions from the admin and user. Now ...

log in problems

Sal - 11 Jul 2006 2:59 PM - 5 messages

When I first created the access db I created it on a local drive. There I created the log ins and security permissions. Everything was working fine. I recently moved it to a network drive only to discover the users I had set ...

workgroups

Kevin Barlow - 11 Jul 2006 11:42 AM - 2 messages

Were running an access 2000 database with a workgroup file. I can't see anything for adding the workgroup into access and yet access says I need to add the workgroup file and doesn't tell me how.... can someone tell me how, thanks ...

I was the owner of the access database. and now the owner is unkow

tariq - 11 Jul 2006 5:04 AM - 2 messages

i lose my permissions as admnistrator ...

Capturing Windows Login

Ray - 11 Jul 2006 1:06 AM - 3 messages

Is there a way of identifying the windows logon while in access? I have computers with Access on Windows XP. I want to be able to identify the windows' users that are using the mdb. I have established no security for ...

Preventing users opening backend

Mary Ann - 10 Jul 2006 5:33 PM - 3 messages

I am in the process of creating a simple split flat database using the Splitter Wizard. I shall locate the back end in a shared folder on the network and ensure the six users each have a copy of the front end database ...

Installed updates, now macros don't work!

Nik - 10 Jul 2006 4:41 PM - 5 messages

I have a Windows 2000 server that holds an Access 2002 database. Users used to be able to open this database through Terminal Services when necessary, but every since I installed Windows and Office updates toward the end of ...

Testing Database Security

John B - 10 Jul 2006 5:39 AM - 2 messages

Good-day Experts, 2 questions 1) I have a database that has security (user/password) defined by say person A on his machine. When person A opens the database, he gets user name and password prompt. However, when I opened it, I do not get the prompt (i.e. ...

Missing User data on some macros stops conversion of Access97 to Access2003

Ant - 9 Jul 2006 2:39 PM - 2 messages

Hi, I'm trying to convert an Access 97 database to Access 2003 how ever I get an error message that Access 2003 can not convert some of the database due to security reasons (some of the macros are set to read only) and quits. ...

logon

JB - 9 Jul 2006 11:24 AM - 3 messages

Hi. I have 5 databases on my system which I've been able to go in and out of with no restrictions. I was in the Analyse wizard in one of them and right at the end there was a ...