Security Newsgroups: Access Security

changing mysysobjects permission

eaben - 24 Jun 2006 3:15 PM - 2 messages

i`m trying to read report names from an access database into a vb program but i cant change the read permission of mysysobjects because it belongs to "engine" and not to "admin" How can i change this? i tried openening the database in exclusive mode but didn`t work ...

Lost mdw files

douglasm3 - 23 Jun 2006 11:31 PM - 5 messages

I have several mdb files that had an associated mdw file. I cannot locate the mdw files. Is there any way to open these databases? ...

Read only for staff

Craig - 23 Jun 2006 7:03 PM - 5 messages

How can you set an Access database file so the accountant can make changes to the data in the database yet staff people other than the accountant would only be able to read the data in the database? Thank you very much.... ...

Clear Password through VBA

Connie B via AccessMonster.com - 21 Jun 2006 10:19 PM - 3 messages

Does anybody know if it is possible to use code to clear another user's password without knowing the password, like you can do in Tools, Security, User and Group Accounts, Clear Password? I have been given a requirement for users to change their passwords ...

Security Warning

Hype Man - 21 Jun 2006 5:36 PM - 2 messages

I am getting a Security Warning: Unsafe expressions are not blocked. How do I resolve this issue in 2003. I have not got Administrator rights. ...

Password , limit the number of trys, is it possible ???

javiernews via AccessMonster.com - 21 Jun 2006 8:14 AM - 4 messages

Hi Is is possible to limit the number of trys entering the User's Pasword ?? (I'm No talking about Global DB password, I'm talking about Users Security) Javier ...

MDB file not opening nor giving error msg

bob engler - 21 Jun 2006 5:26 AM - 2 messages

I have a .mdb database that is set for sharing, the DB file on a network server set to Access2000, open databases using record-level locking, Open Exclusive set, workstations running Access2003, 5 users all setup the same. When 2 users ...

Users Allowed to Run Action Queries

MichaelHughes - 20 Jun 2006 5:35 PM - 2 messages

I have a database that has several append queries to update historical data collection from an ODBC server. I have code that runs the append queries on startup of the database. However, when a user (not the admin) opens the ...

Security - Is my way secure enough?

Gino - 20 Jun 2006 12:58 AM - 8 messages

A couple of weeks ago I was looking for suggestions on how to implement a simple security strategy, mainly to prevent a backend Access database from being opened/read if copied from the office to a home PC. I did get some valuable suggestions (see at the end), mostly referring to ...

Workgroup Security/Electronic Signature (PW *after* logon)

Michelle - 19 Jun 2006 10:41 PM - 2 messages

I have a db (Access 2002) that I have applied workgroup security to. Users login initially with their username and password. Once in the db, I can call their logon with the [CurrentUser] function, but I also need to require a ...

Zipping file

babs - 19 Jun 2006 9:56 PM - 6 messages

I have set up my database to prompt for username and password using the security wizard at work. I emailed the database to home office and made a desktop shortcut with the correct Target Path. Access software, database ...

help me

Wojtek Laskowski - 19 Jun 2006 7:29 PM - 2 messages

[link] screenshoot. What to do next? ...

MDW and linked tables

afleet - 19 Jun 2006 6:24 AM - 5 messages

Folks, I have a successfully secured MDB file (lets call DB A), which I would like an unsecured database (DB B) to be able to link to. I don't care about security in DB B, and the link should be Read Only. I assume that ...

Programmatically bypass startup options like holding Shift key

mike.michelle - 19 Jun 2006 3:18 AM - 2 messages

Hello, I'm working on a VB.Net app that tries to open Access (mdb) files, and I don't want any user interaction. I'm having trouble with databases that have a startup form set, which in turn has links to sources that aren't available - these cause ...