ok, i came across a similar problem in another part of my database.. this error "runtime error 3008, the table bookings is already opened exclusively by another user"
this is the general problem..
table1 (stores main details)
query1 (uses fields from table1 to show selected records based on criteria)
form1 (data entry form for table1.. recordset for the Form set to table1)
mainform1 (just a blank form with an open form button which opens form1 and allows records to be entered)
now... i basically wanted to display the results of query1 in a listbox , and place that listbox on my mainform1)
i can view the results in the listbox from the query1 (which is based on table1 remember).. but as soon as i click the openform1 button, it tells me i dont have access..
that means that because i am using a query, based on table1 on my main form, it does not let me access table1 directly...
how can this matter be resolved generally? is there like a general solution to this problem because it keeps propping up..
When I try to open a report or a form in a database I've been working on for the past couple of days, a dialogue box pops up saying that I "do not have exclusive access to the database at this time". Does this mean that I can't access these form because someone else has the database open? I sent a zipped copy of the database to a fellow coworker in zipped format and we work on a common company server, could him having the db open cause this problem?
I have a problem which is really REALLY annoying me.
I have created a brand new Access database. I have created a number of forms. When I run the database and use it everything is ok. Then when I try to go into design mode it says
"You do not have exclusive access to the database at this time...."
The database is on my laptop and it is only me who is using it. Can ayone please help.
I have a small dabase shared by 4 users on the network. when someone opens the db, then someone else opens it there is no problem. when user 1 has a report open and user 2 tries to update a record, user 2 gets the following error
You do not have exlcusive access to the database at this time. If you proceed to make changes you may not be able to save them later
I have split the database into 2 seperate Db's one is the tables only the other is the objects.
I have just had a very frustrating morning. Recently upgraded to MS Access 2003. started having a strange problem, MS Access kept notifying me a another user was using the access database I was in. I switched off and rebooted, still the same..... ?
Read a bit on the Internet, checked my settings, made sure I was exclusive user, made sure user was set to owner, Rebooted, still the same.
I noticed that occasionally the *.ldb file would suddenly appear when I've tried to move or copy a database in explorer from one folder to another? Something was shadowing me, something was recording when I was using an MS Access database.
I checked to see if I had inadvertently added any strange Add-in's, none Listed. I checked visual source safe, I haven't set that up yet it's not doing anything.
Then I remembered! I had installed MS Access crawler which works with Google desktop to record where your MS Access files are. I uninstalled access crawler and I have not had any problems since.
I have inheritted a database that works very well. I need to change addresses on some of the Reports and make some changes to the forms but I am having extreme difficulty in obtaining exclusive access because I do not have the correct permissions. I have spoken to the originator who says he didn't set any secirity on it. Can anyone help me either get permission to edit it or get the database working by some other means.
I was just wondering if anyone can explain to me the difference between setting the database to open in shared mode in the Tools-->Options menu vs. checking or unchecking the Open Exclusive box under the user security section? Is it just two different ways to do the same thing or are there different implications for using one over the other?
We have shared MDE, when second user opens gets message: [B]You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later. The message seems to repeat for each compiled object (Form, Report and Module). Helptext states occurs when in design mode - but not in design mode! Any ideas as to how we can suppress the warning?
I have an Access DB that 3 different Analysts use on a daily basis. I need to be able to have more than one person in the DB and be able to design Reports, Querry's, and Tables. If I try to open the DB, and someone else already has it open, I am unable to modify the design of anything. Anyone know a way around this?
I am getting the message "You do not have exclusive access to the database at this time" whenever I try to make changes to my forms.This problem only happens after I run the following statements and I get the message "Cannot access C:SALON-NETDataSalon-Net_be.mdb; file already in use"Dim wrkJet As WorkspaceDim db As Database Set wrkJet = CreateWorkspace("NewWorkSpace", "admin", "", dbUseJet)Set db = wrkJet.OpenDatabase("C:SALON-NETDataSalon-Net_be.mdb", True, False, "MS Access;PWD=test01")Although I have 3 PC's on the network, the database is not shared, and the folders are not shared, and no one else is accessing the database.If I bypass the statements above then I do not have a problem at all, but I need to run those statements as they are at the start of the main form and they do any updates to the backend database that are requried such as adding fields ect. This is just version control so that if I install the application on another PC it does the same updates to the backend database on that PC also if you see what I mean.I haven't always had this problem.I have looked for answers on this forum and the internet for weeks now and still cannot get it sorted out.I tried unistalling Adobe Accrobat which I have seen suggested (Could something still be hanging around) although another PC has the same problem and that has never had Adobe Acrobat installed on it..!I have also tried following the advise on the Microsoft site. Renaming the files/moving it to another folder ectAny ideas?
If I have one access mdb file called "DATA" that contains tables and two access applications as mdb files: "app1" and "app2". Both applications has links to tables in access mdb file "DATA". Is there a way to open access file "DATA" exclusively when I open "app1" and open it shared when I run "app2"?
I have a BE DB on a network server at work. I was making changes to the database and closed it, but it still says that I have exclusive rights (when I try to compact and repair, it shows that my network log-in ID has rights to the DB).
Folks,I've got one file that I would like to make a copy of in a different format (.mdb to .accdb).Everytime I try the "Save As" within a different file type, I think Access treats the new file like it's being opened. Because of this, I am getting this error:Cannot save the database because it has been opened exclusively by 'Admin' on "my machine"I've checked both previous versions of the file (2000 & 2003), and both of them have a default open mode of "shared". I am trying to save it as a .accdb file from either the 2000 or 2003 version. Both files throw the error.What could be going on here?
I was just wondering what the drawbacks for using Shared and exclusive databases. id like to create a shared database but has anyone come across any problems?
what happens when 2 people at the same time access the same row and save at the same time? is the first persons work get overwritten?
I have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'. Is there a way of opening the database over the LAN and allowing the Internet to see it?
I'm having problems with a count expression in a report. I have a series of items listed, with subdata against each one, in some cases this subdata is one rows, in others it is many rows.
Anyways, having listed these items and there subdata sets, I want a count of the number of items listed.
Unfortunately, a count on Equipment ID returns the total number of sub data items listed, as for each sub data item, the Equipment ID is associated. Is there a way of making the COUNT expression count exclusive values?
I'm having problems with a count expression in a report. I have a series of items listed, with subdata against each one, in some cases this subdata is one rows, in others it is many rows.
Anyways, having listed these items and there subdata sets, I want a count of the number of items listed.
Unfortunately, a count on Equipment ID returns the total number of sub data items listed, as for each sub data item, the Equipment ID is associated. Is there a way of making the COUNT expression count exclusive values?
I work for a real estate company that uses Access to keep up with showing requests. I designed the database and I'm an amature. The database is fully functional but I would like to create some sort of log-on screen switchboard to restrict access to tables and such to me alone. I've got the idea behind the switchboard wizard but I want 2 or 3 passwords depending on who is accessing the database.
Also, I was trying to split the database but when I try to copy the forms etc.. database to another computer I can't edit the tables. I had the tables in a shared folder and allowed editing of it, but it wouldn't edit. Does the form database have to be stored on the same computer as the table database?
When a certain button on a form is click it makes a sub form become visible, I am trying then to make this form exclusive aka, must be complete and stop the user clicking on the main form until this sub form has been complete.
I'm planning to use the "compact on exit" functionality to keep my db's neat. I have understood that I also have to grant "Exclusive mode" to the database object to the users of my db (not to Users group, but my own users group). Does this have a security implication?
As I'm running a FE/BE solution, does the compact and repair only do my FE or both. If only the FE, is there a good way of triggering the BE to be C&R as well?
I have a simple Access database with a number of linked tables to Excel spreadsheets located in the same directory.When I open the Access database from two networked machines, I get an error on the second machine when I try to open a form that uses the linked tables. It says that the linked table has been opend in Exclusive mode.Any idea how I can prevent Access from opening the linked tables in exclusive mode?thanks
Hi, I am extracting data from linked db2 table using access make table query. First I create a select query and can view the linked db2 data, but when I change to a make table query I get an error message, "invalid argument", when I run the make table query. There is no selection critera specified. Has anyone had this happen? and Do you know a solution?
Hi, I new to access and I just started using it for a group project in one of my classes. We are supposed to make a database for our "business" so we decided to pick a small independent movie theater.
After some trouble we finally figured out that we had to link the tables with some relation ships. Our basic tables are:
So I made a query that would get the revenue for each product sold in the inventory by multiplying the price and the amount sold.
I was wondering if it would be possible to create a query that would total all the revenue and all the ticket sales and divide them to create a per-person spending ratio.
Can you do a pivot table from a query in Access 2000? I found links that shows new features in Access 2003 that allows it, but no definitive information if it can be done from Access 2000. My tables can pivot fine, but no luck on my queries? If not, is there an easy way to get a query to a table in order to do a pivot table?
I want update a table (in Access 2010) based on the results from a pass-through query that pulls data from an old Fox Pro database.
With the following query I push data into my access table (everything works fine):
Code:
INSERT INTO Bolle ( esercizio, numero_documento, ...) SELECT Bolle_Arca.[esercizio], Bolle_Arca.[numero_documento], Bolle_Arca.[testata_codice], ... FROM Bolle_Arca WHERE Bolle_Arca.[testata_codice] NOT IN (SELECT Bolle.testata_codice FROM Bolle)
When I try to update the same table using the same pass-through query:
Code: UPDATE Bolle INNER JOIN Bolle_Arca ON Bolle.riga_codice = Bolle_Arca.riga_codice SET Bolle.esercizio = Bolle_Arca.esercizio , Bolle.numero_documento = Bolle_Arca.numero_documento, ... WHERE Bolle.spedito = False and Bolle.data_invio_mail_spedito is null and (Bolle.tracking is null or Bolle.tracking = '') and Bolle.testata_codice = Bolle_Arca.testata_codice;
I get this error: "Operation must use an updatable query"
