I am attempting to move a secure database location. How do you change the location of the security since it is still trying to read off the old location. The database opens up fine with the passwords. Then I deleted the old folder it was in and try to log back in and give me the security upon startup error. So my problem is how to I change the security upon startup. I see you can change the location of the unsecure through a wizard but how about the other way??? I think I am trying to change the Workgroup information file but how do i do that??
I have a database that I've created for someone else to use. It's split into a front and back end. The user will be placing the front end on her desktop PC and the back end on a network server.
She also will be taking the database home to use from time to time. My problem is that when the database is split, upon opening, it looks for the back end on the network drive, which is unavailable when she's away from the office.
Is there a way to tell the Access to look in a directory relative to the one it's in?
I have created a few split multiuser databases in Access 97 that my company has used over the past few years. Currently, we are trying to move everything to a new network server. When I did a simple copy and paste on Friday moving everything to the other server it seemed to work fine. Until I tried to open any of the databases. I kept getting the message that they all were read only.
Do I need to bring the database back together before transferring it? I also plan on converting the databases to Access 2003. What precautions should I take in doing this?
Thanks for any and all information you can pass along.
I am working in Microsoft Access 2010 and wanted to move tables from a number of databases to a "Master List of Tables" without having to manually recreate them. The purpose is to have this "Master List" available when we are creating new databases covering similar topics.
I was hoping to use the import tool but it appears to address only data not tables.
Hi Everyone, I am attempting to move a password protected database to a different folder on our shared drive but I am not sure the steps that are needed to do so. The database is already split. Can someone please assist???
I am new to Microsoft access. I have a database moved from another computer. it is split into the backend and the front end..
However, when i click on the forms in the front end, I get an error message. It is trying to use a path from the old computer, to the database, but its on a different computer.
So, this brings me to my question, how do i change the path, to the new location
I'm using Access 2007 which I built a database that runs queries off of tables using ODBC. The database is all done in ms access, I've used no visual basic programing on it. I'm now trying to move a copy of the database to another computer's local drive in the office. When we try to open it on the other computer it gives me an error that says "There was a problem sending the command to the program" and Access hangs, which I then have to run task manager to end the program.
Specs Are: Windows 7 64bit (the db was created on Windows 7 32bit)
Currently I have an Access dB that was developed in A2003 but we are currently using A2010, it is accessed by multiple users that all have a frontend locally on there own networked PC's, with the backends etc on an old NT server, we are having problems with new technology accessing the NT server so it's well past time we got shut of it
We have a share on our network that has been made available to us to migrate all our NT server files to, Here's my problem, on testing the procedure I copied the database backend and .mdw file over to the share then tried to open the dB where upon i got the following error message
Cannot open microsoft Access database information file
On further investigation it seems that both the back end and the .mdw file have copied over with no content i.e filesize is 0kB, not only that the originals also seem to have had there content "deleted" a simple copy shouldn't have done this (I did have a backup btw)
So the database I have right now is split, with the back end on our server. Everything has been going great, however there are several second time delays when loading large forms, queries, etc. I've heard that moving the back end to an sql server is the way to go for speed.All forms and queries are on front end of database. Tables are located on the back end which is sitting on the server.
Hi, My access database's tables are currently linked to an excel document. My question is, how do I move my database to the network? Currently when I move the the database to the network no one can open my tables because the link goes to my documents on my computer which they can't access on the network. So how do I move the database and maintain the link between the database and my tables?
I have a client that is using a split database. I am working on an update to the program and need to transfer a table to the backend that has the correct structure and information included in it. My thoughts are to make a one time use program that transfers the table to the backend. I have seen DoCmd.TransferDatabase and DoCmd.CopyObject as possible ways to go.
Moving to new computer, both under Win XP pro, Access 2003. New computer is MacBook Air running Parallels. Transferred Access database via an external hard drive. Now the data shows up as Read Only. Is there a procedure to run down the cause and make the data accessible?
I have a very basic Access Database that is a contact resource for vendors. I have a Switchboard manager form when you open the database with the option to take you to a Form for the supplier contact information or to 2 different reports.
I have set up security so that I have full access and then a Data Entry user is allowed to edit, add and delete data but no make changes to design of the database. I also have just the minimum toolbars showing.
I set up the security and work group file with no problems. It works great on my computer but when I try to transport it to another computer, I get an error stating: "You do not have the necessary permissions to use H:/File Name.mdb. Have the system administrator or whoever created this object establish the appropriate permissions for you."
How do I set up the database security and still have the database be portable and be able to be used on any computer?
Also, is there a way to restrict the toolbars for the common users and have the full toolbars for the administrator?
Hello. Prior to MS Access 2003 a different workgroup information file (system.mdw) could not be joined unless the user had access to run the workgroup administrator utility with the file WRKGADM.exe to create a new or join another existing workgroup information file. With the 2003 version of Access there is now a command (Tools menu then Security then workgroup administrator) to run the workgroup administrator utility within the MS Access menus. This could allow any user, once they are able to log in to MS Access, to change the workgroup information file to one that doesn’t require them to log in and has no restriction on rights for users for any database. My question is: How can I make it so users can’t run the “workgroup administrator” utility from the menu? Note: If you remove it from the menu then any user can also customize the menu to bring it back so that is not a problem solver. Any suggestions would be greatly appreciated.
I have an old Database which someone had created and they stopped using it. Now they would like to get the information from it. The problem is whenever I try to open it, it says
'You do not have the necessary permission to use the c:SGSS Database.mdb object. Have your system administartor or the person who created this object establis hthe approprirate permissions for you'
I have the secure.mdw file. when I open it all it has is a few queries with the usernames and the groups.
Is there anyway I am able to get into this database? I have looked around in the forums here, but I didnt' really get a straight answer or the solution was for a different circumstance.
Hi, I'm working on a piece of coursework which is due in pretty much tomorrow. I've finalized everything except security. I need my database to prompt for a user name and password when a user loads up the database. If a user name and password is given that is correct, then it'll open up the database with that user's permissions. But if an incorrect username/password is given then it should deny access.The help files weren't very helpful on this, I'd be very grateful if anyone could tell me how to set up this security.[Edit] Also, I dont know how to make the database automatically open up an input form (in this case, the main menu form) when the database is opened. How do I do this?
Thanks to all the folks in this forum who helped me to develop my fist access database application. Access is a great product and I really enjoy working.
I need to put this db for full scale production use and I would like to brainstorm some of your experiences on the security issues I need to address. I have like 12-15 users and everyone has a standalone version of MS Access 2003 full edition installed on their local hard drive. We do have a shared network drive (s :). I have few questions as follows:
1. Is it a good idea to split the database into front end and back end and install only the FE on individual user machines or just run the .mdb file from shared ‘s’ drive? I don’t have any experience with how the BE and FE works.
2. Currently I don’t have any user workgroup and permissions set to run on the database. Anyone can just open the .mdb file like any MS office suite applications(.xls, .doc) and start using (navigate, input data into the table through forms, search database, print reports, access to DB window, etc). Can some one advise what kind of security level should I incorporate as a minimum?
3. Under Tools-Option-Advanced TAB, I have selected No Locks under Default Record Locking and also checked “Open databases using record level locking” option box. Is it safe to keep it this way? Is it possible to lock only few records on a table? I have a situation that on a particular project (this is a decision supporting db application) after the project (project here refers to a record) is done, I want to lock these data so that no one can modify the existing data. At the same time, if they are working on a current project (record) then the user should have add/edit/delete access to that particular record. I am not sure if this (record level locking on a table) can be done.
4.In future I know that I need to modify the table design, forms, reports, modules. Is it good idea still to consider creating MDE file?
Your input is greatly appreciated and thanks a lot for your support.
I have built a database for my employer which is held on a server and accessed by 8 terminals. This arrangement has been in place and worked well for 3 years. The database is secured and is accessed by users using individual user id's and passwords. Recently I have had to replace a faulty terminal. The new terminal has access to the main server but seems to bypass the security element as it gives access to the database without asking for user id and password. What do I need to do to correct this position? All the other terminals are working as they always have done.
How can I keep a user from accessing a database file from the directory? I've seen it before where if a user tries to open the database from the directory without being attached to the workgroup file it gives them a permissions error. I've set the users up with shortcuts to the database with the workgroup parameter but some users still go through the directory to open the file. When they do this, the currentUser property isn't captured. It logs them as the Admin. I want to keep this from happening. What can I do?
I have been searching your wonderful forum and I have found the answers to all my questions - or so I thought.
I have 5 people who need to use the database and I need to know who signed on and added/changed data etc etc etc. So I looked up workgroup security and hey presto :) I have security when I open the database I need to put in my username and password.
However..... when I asked my co-workers to sign on to the database they can just open it :eek: - no questions no "hows the family" no nothing!!!! So here I am the poor administrator having to put in passwords when the rest of the world can reek havoc on my defenceless database:D Any help greatfully appreciated
My husband and children keep telling me humour is not my strong point and having read some of the other threads about how to ask etc etc I may well have fallen in the ignore category.
However I think I have found the answer to my question (for anyone interested) I used the User level security wizard - which has given me a shortcut to the database and identifies each user by virtue of their sign ons. (I had been warned off using this wizard previously).
So I can recommend to anyone who want to do control access to try this - make a backup copy of your db youself but the real beauty of this is it makes another copy for you as well.
If I make my database a MDE file, will it allow me to do maintenance? As I have a date query that removes records that are passed a curtain date and appends them to another table, which will be ok for this year but will need to modify the query next year. If the file is locked totally then I won't be able to modify when it is running.
So I need a way that the database design is locked off to normal users allowing them to use it but will need a password for design so they can't mess with it. The password which will allow me into the workings to modify queries ect. Is that posible?
I have just upgraded the works network and software. INstead of using Access 97 i am now using 2003. I hav lost all of my security setting whilst converting it from 97 to 2003. I hav used the Security Wizzard to re-create the permissions. On my PC all usernames and permissions work fine 'But' when i go to another work station it doesnt ask me for any username / password. I hav got the database set to 'Shared' on a shared drive. The last time i did this i created it all myself and didnt use the wizzard and it worked fine.
i just created a simple access db with table, query, form, report. i want to distribute this database to different users at different location. i do not want to create workgroup.
i don't want to view/modify any of my object's design. i just want them to add new records in the form, view and print report only.
I recently used the access security wizard to setup user accounts etc.. and now I want to reset and go back to opening all databases without having to use a username & password.
Hi all i'm really confused. I have tried to use the user-level security wizard to set my database security which works fine from my computer. However, when someone else logs into the database through my shared area where it is kept, they do not encounter any of my security settings that I set up for them. From this it looks to me that the security settings only apply when someone opens the database directly from my computer and not when they open it over the network from my shared area.
Could someone please explain to me why this is happening and offer a solution to it please. Your help will be greatly appriciated.