Access Security

Hi, I'm a web developer student.  Many of us are getting an error message when trying to open an Access database saved on the school server.  The message is that 'Access cannot open the database because it is not on your ...

Since hotmail eats mdb-files I had someone rename his "dbname.mdb" to "dbname.dat" and email it to me. When I copy to my harddrive and rename the file to "dbname.mdb" and try to open it I this message: ...

I'm testing setting up user-level security on an a2002 mdb...i set-up new workgroup, made new user in admin group,  moved 'admin' user out of admin group, removed permissions for 'user" group, set-up custom groups...all seems ...

I am using the script that TC wrote regarding by passing the security warning.  However, I need to force the maximization of the access application.  It currently starts in normal window mode. How can I force the application to use the whole screen?? ...

I am feedup with someone going into the database and modifying it all the time.  I would like to setup a password so that noone is able to modify the tables, queries, reports, forms, etc... How Do I do that? ...

I am using version 2003. I want to distribute my database to a number of people and give them log on usernames and permissions but don't know the best way to go about it. Should I split my database first of all so that the tables are separate from ...

I have a (VB) application that creates a database with user-level security. The user can choose when creating the database whether to encrypt it or not. When I programmatically compact the database using the JRO CompactDatabase routine, JRO decrypts the database.  I would like the compacted DB to be ...

Hello, I have a situation that when more than two users use the same table in Access 97, then nobody can open that table again unless one of the users close the table. I want to know if there a place or a file that I can set to avoid this ...

I'm working with a database that is shared by a number of users.  Occasionally when I go into the internet explorer to pull up the database, a duplicate file is listed with a tiny lock in the title.  Can anyone tell me ...

Hi there. I have an Access 2000 database and would like to make it accessible to only one user at a time.  Is there a way to do this - perhaps incorporating a message to say somebody is already in the database? ...

I have forgotten my password. I renamed the system mdw file. On logging on to Access the software thinks that I need some update, However I do not have any CD to do the update. Is it possible to update via the web? ...

Hello to all, Is it a known virus? Wwhat is the cure ? Thanks ...

Please ignore this message. I am learning to post a message on a newsgroup. ...

Does anyone know if it is possible to set MS Access macro security settings to low for all users. I have noticed it is profile related and i do not want each user to change this setting manually. I need this setting to be low for ...

I have an old Access 97 database that I need to put back into use. I want to open it up in Access 2003. The problem is that I can't because the 97 database was secured using the workgroup administrator. I don't have the mdw file anymore and am not sure what happened too it. Is there a way I can access the mdb file and get the tables, queries, forms....etc.... out into another mdb file? I have tried doing an import into another mdb but it errors saying I don't have the rights. I have tried just opening the file with the same results. I set the system.mdw file to what I believe the admin and password should have been. I get a login prompt but am still not able to get past it. Is there something that I am missing. Can someone please help me out? ...

The users of my database complain that they receive a dialog box for each hyperlink stating, "Hyperlinks can be harmful to your computer and data.  To protect your computer, click only those hyperlinks from trusted sources.  Do you want to continue?".  Is there a security setting to hide this box? ...

HELP, I AM LOCKED OUT!! I tried to apply security to the database using the wizard and I am locked out!!  I wanted one group to be read only and me to stay as admin.  Now no-one can open it.  It just says that I do not have permission to open ...

Hello, I need to log a secured databse from another totally unsecured database. I think I have to go with the ADMIN user, which is the only one available in my unsecured databse. But this wont work since in the secured database the ...

How does compiling work? I found this: [link] and find it somewhat troubleing. I know it's not an available program, but if they can make, why shouldn't others...? Regards /Snedker ...

Hi Is it possible to programatically create a new mdw (with the same ids etc) which I can then use to link to a secured database? For example I have an existing user level secured database (and associated mdw somewhere but lets assume its not always available), and create a ...

I'm trying to delete as user from a workgroup file using DAO. Maybe someone has a snippet that does this. I'm starting with something along the lines of: Dim ws As Workspace Dim usr As User Set ws = DBEngine.CreateWorkspace("", "dbadmin", "dbadmin") ...

i have an access2003 database that is only going to have 1 user. i want the user to put a password in before the main switchboard is opened. i know i can go to tools - security - set database password, which works fine. ...

Hello, How do I create a database that requires the User to login with username & password? ...

I am trying to set up read-only data access pages on an intranet, which would allow those employees in our firm (30-40) who do not have Access on their machines to look up basic data (like phone numbers and addresses).  ...

I have a well-functioning secured database, but now I'm trying to create a workgroup file allowing a trusted user to add/delete other users. I originally created an mdw-file called "developer.mdw" with the groups: AppAdmins, AppUsers, Developer. I'm in the "Developer" group as the only one ...

I have two different databases, one is secured by a workgroup file (DB1), the other is secured by another workgroup file (DB2). I want a way to enable me to link a table from the first secured DB (DB1) , while  in the other DB (DB2). and being able to read its data. ...

Hi everyone, I'm having a very difficult time with the Access security and I'm hoping someone can point me in the right direction. I have an Access 2000 database that I need to secure, but for the rest ...

I set up security permissions for a database some months ago. That database has been working fine and has been installed on the network with using the security wizard. But I've just tried to create a new database project and it asks me for a ...

I have a 2 computer network. The BE resides on one computer and each computer has a FE.  The BE is opened shared as are both FE.  In Options only Admins and Users with full rights, except "Open Exclusively" is not checked.  ...

When signing out of hotmail recently, I get the message that I cannot sign out "WeeMee on MSN". Why??? Is this hacking, spamming or what? ...

If ANY MVP wishes to post cracks to Microsoft Access Security, be they Jeff Conrad or Tony Toews, then let it be stated clearly in this security newsgroup. Chris ...

I have Microsoft Office Suite and I also have Microsoft Office xp for students and teachers (version 2002).  Can I pay an additional fee, and install either one of these on additional computers, or do I have to purchase ...