I have copied a work database onto my flash drive and then onto my laptop to do some work in it.
Now I can not open the database because it has the error message.
You do not have the necessary permissions to use the database etc...
I have copied the Application file, the Data file and the Workgroup information file and the only one I can open is Workgroup information file. I have tried holding the shift key down as well.
Any suggestions as I have heaps of work to do and I have tomorrow away from work to do it.
i was told i could use statements like GRANT SELECT ON Accounts TO Web_User, only i dont know WHERE to write the statement and how to write it so it grants read only permission to all web users.......im using Microsoft Access 2013.
I have very nearly completed designing and making a database for stock control for my company, and am now a little concerned on how it is going to be implemented. It is going to be done over a network, with only a handful of users. The idea is to have every user log in but with each person having different permissions. i.e onl;y being able to access maybe one or two forms, but also having an administrator that can view every form. Now, i am aware of the security settings in the tools menu, would this be the appropriate way, or would i have to creat an empl;yee table and set permissions thropugh vb? This is the first database i have constructed and need a little help!
The second problem is that the database will be over a network. Would i have to put the backend in one place and then have the front end installed on all the pc s and just access the backend when i its needed? Forgive me if this sounds a bit stupid but as i have said this is new to me..
I have some Databases that were created back in Access 97 and have managed to upgrade these databases to work in Access 2013, fixing any modules and forms which broke when upgrading the databases.User access and permissions within the database were controlled by User Level Security (the Workgroup.mdw file) which is not secure anyway I guess, as someone could easily copy the entire database.
The database as it stands now works perfectly in Access 2013, however anyone can do anything with the database which is my main issue. Im wanting to limit access for certain forms / tables / reports to certain users, then out right deny other users from accessing the database.
Ive seen the SQL Server 2014 Migration Assistant for Access, which looks to store the tables on SQL server then map these to the Access database, so i guess i could deny certain users from accessing tables that way, or only allow them to read the tables. However I'm not sure how that would lock them out of certain forms / reports and queries in the databases?
I want to set permissions in Access, how can I restrict an employee in my key checkout database from checking out keys that are not in their department. What kind of table do i create or is it visual basic coding?
I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
What is the best place to have opendatabase statement ? Currently I have opendatabase in all of my forms. I dont have any modules in my application. I am new to access programming. Is module really necessary in an application? If I can put the opendatabase statement in one place, it will be easier for me to change the database name and path, if I have to..I dont know how to do it.
Can anyone help..I hope this one should easy for many of you people.
I've run across a couple issues with our database. The most immediate issue is that I have been unable to open the database on any networked (or non-networked) computer. Me and a assistant typically enter data into this database from two seperate computers. She works on a wireless networked computer with the file on my computers hard drive. I work directly with the file. My computer is wired to the router. (in case that information helps)
We keep getting errors about "cannot access remote computer" and such, they seem to occur when she's entering data and I have the database open, then close Access. It will often give her the error and not allow her to save the record.
But just today she entered something, I closed my database window, then reopened it and I could not get in. All network computers rebooted, and still cannot get into the file. I can enter the password and then it goes to just a blank area (like when your first open access with no database). Older backup versions of the database still work, so it doesn't seem like an Access error. I also noticed that the little "LockFile"s are not being created (I ever faked one just to try it out and it deleted it after i entered the database password)
I can't repair, or convert or anything, it just asks for the password, I give it...and then nothing.
I can't open my database... It was open yesterday and after a power failure computer turned off... 2day I can't open it... Messege box says something like ---database was open--- not properly closed--- etc. etc. and can't perform auto repair...
I tried to import the objects in other database but can't do that as well...
I have problem once each day when I open Access for the first time. I get an error message "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.". It asks for a file name and insists on compacting (I think) and saving the database. I go through this several times saving it under a diferent name each time until I get the warning "Security warning Some active content has been disabled. Click for details." with a button to disable it.
I'm changong computers and at prestne (for a few days) I am using a borrowed computer. When I edit any of my db's I now get a message telling me that I haven't got permission do carry out what I am doing & the permissions will be erased (can't remember exact message cause I'm on another computer). The edits I have made work ok but I really don't know anything about permissions:confused: It's something I have not been bothered with because this is the first time I've changed computers with all my db's. I use acess 2003. The computer I'm seeing the mesages on is using the version of jet that came with it, my old one had an updated version of Jet (probably not the latest though). Any suggestions?
Hi - I wonder if anyone can help. In my haste today I ran the security wizard on an Access DB and I've locked myself out. Using Win XP home and Access 2003. Now when I try to open the DN it tells me I don't have the necessary permissions. I've hunted through the forum and there seems to be tons of postings on this, and I have tried creating a new .mdw file etc, but just can't get into it. Can anyone help me please in giving the exact steps I need to take to unsecure the DB again, as there is dozens of manhours work in it, and I desparately need to get it opened again. Thanks.
Hello. I haven't seen this before with Access; I've searched the forum and haven't found anything yet...
I have an Access database that was being used by about 9 different people. Everything was going along okay, but one day it became read-only for no reason. Once everyone got out of the DB it said it needed repairing. So with only one person in I ran the repair, but the horror-inducing message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." appears and when I click "OK" on the message nothing happens whatsoever.
Luckily backups existed, but some data was lost. Is there anyway to run a repair on the database that won't open? Or is it a lost cause?
On opening my database, I have a switchboard that opens up.
How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a report automatically after that.
"This database is in an unexpected state; Microsoft access cannot open it.
"This database has been converted from a prior version of Microsoft access by using the DAO CompactDatabase method instead of the Convert Database command on the tools menu. This has left the database in a partially converted state.
"If you have a copy of the database in its original format, use the convert database command on the tools menu to convert it. If the original database is no longer available, create a new database and import your tables and queries to preserve your data. Your other database objects can't be recovered."
The database is on the server. Nothing was changed. Someone in our IT department says they simply opened it and then closed it. I think that they had their access program set to compact and repair on close.
I have tried to import the tables but am gettting the same errors.
I have the original database but it is an old backup that is missing data.
I created the database, which shared by multi-user. But, my user have a problem to open it. When user1 open the database, user2 cannot open it, I did not remember the error message, it is said that Admin (computer name) prevent you to open the database. But, if the user1 switch another application program (the database file is still opened), user2 can open the database, then both users can access the same database file.
I have a user who is having trouble opening a database he created. Here is his description. I am having an issue with Access that has occurred today and once several weeks ago.
First, I build a complex database for Safeway report. It functions correctly, I can access it from excel.
Problem, I go to update or modify the databases, Access gives me the macro message which I override.
The access database window will not open, no error appears, just a blank access screen with tool bars above. I have tempted to do a compact and repair of the database which did not help.
Microsoft Online help says the issue can be cause by old Anti Virus Software.
The database will permit excel to pull data from it. Does anybody have an answer.
Is it possible to open a database from a form in a different database? Not necessary to do so; it would just be handy to do from the form I already have up and looking at rather than having to go open another instance of access and go to that database.
I have two databases, one is much larger than the other, but both have the same start up code. The larger database opens quickly, but the smaller database takes forever. I tried compacting and repairing the front end and the back end of the database, but that did not help. Any ideas on how I can speed this up?
hi i get the error "The database is already opened exclisively by another user" after running the following code. i ran the same code under the same conditions on my home pc and it worked fine.
Private Sub Command1_Click()
Dim dbs As Database Dim qdf As QueryDef Dim strSQL As String
Set dbs = CurrentDb strSQL = "update Emp set Salary = 786+ val(text2)- val(text3) where EmpID = '& val(text1) &'" Set qdf = dbs.CreateQueryDef("", strSQL)
I've inherited a database and I need to export the data to a new program. I can access the DB through a front-end program, but it doesn’t give an option to export the data. I have a username/password for the program, but I can’t open the DB in access. I can't even get to the point of entering a password. The program is 8 years old and the company has been acquired by another company. I tried contacting the new company and they’ve never heard of the version that I have. I’ve even tried contacting a supervisor.
On opening the db immediately gives the error:
“You do not have the necessary permissions to use the ‘C:.....mdb’ object. Have your system administrator or the person who created this object establish the appropriate permissions for you.”
I’ve tried the following with no luck:
1. Create a shortcut to use an alternate mdw file. "C:XXXMSACCESS.EXE" "C:XXXdata.mdb" /WRKGRP "C:XXXSystem.mdw" 2. Holding down the shift key while opening the file 3. Compact and repair 4. Converting it to prior version 5. Creating a new database and importing all objects
Is there a way to "read" the db file to see if there is a valid user name?
I found the following suggestion, but have no idea how to do it:
http://www.vba-programmer.com/Access_Code/List_Groups_Users.txt and this http://www.vba-programmer.com/Access_Code/Security_Listing_Permissions.txt and try the .mdw files again, using the users(and/or groups) that have permission
If it's still not working?, there might be a way to jerry these http://www.vba-programmer.com/Access_Code/Security_User_to_Group.txt http://www.vba-programmer.com/Access_Code/Security_Group_Account.txt http://www.vba-programmer.com/Access_Code/Security_User_Account.txt
I'm not a programmer so if anyone has any easy solutions (or even better a sample!) I’d greatly appreciate the help!
