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?
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 4 databases that share 3 tables.
Each database is used for different purposes and other tables which do not relate to the other databases.
My question is: how do I set up the back ends so each database can retrieve and enter data into the 3 shared tables without conflicts??
I know how to split each of the databases to front and back ends but how would I link them all to the 3 tables they share? Should I create one back end with only the 3 shared tables and link the separate back ends for each database???
Any help much appreciated!
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?
View 6 Replies View RelatedIs there a way to have the db open exclusive normally?
I set the Tools -> Options -> Advanced -> Default Open Mode = Exlusive
But when you double click on the Application it open normally, i.e. shared use?
Any 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"?
View 3 Replies View RelatedHey guys,
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?
Thanks in advance for the help
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).
How can I resolve this?
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.
Vista Ultimate
Access 2007 Professional Plus
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.
Please advise this is getting frustrating
Thanks
:mad:
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.
View 1 Replies View RelatedFolks,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?
View 14 Replies View RelatedI 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?
Dear all,
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?
Thanks,
Stephen
Dear all,
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?
Thanks,
Stephen
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?
View 7 Replies View RelatedI 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.
View 5 Replies View RelatedHi all :)
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?
(should apply to 2K, XP and 2003)
Thanks
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..
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
View 3 Replies View Relatedcan anybody tell me why my colleague cannot add records to a DB I set up on my pc.
i have a DB with 3 tables linked (all one-to-one).
i can add records into it fine on my pc but when my colleague tries on her pc it allows her to enter data but when it comes to moving onto the next record it wont allow her to save the record.
To explain further. there are 3 tables as mentioned before. lets call them Table 1, Table 2 and Table 3. When my colleague uses the form to add a record it wont let her save it as it says a related record is needed in table 2.
any ideas why it works perfectly on mine but not on hers?
Hi, i've a problem
there's a database in a shared folder (two pc connected NOT in a LAN).
the database is on the pc called "A", i'm in the other (called "B") ; i open the db and i've a message "read only". so i cannot enter, modify, ...
how can i give to the pc "B" the possibilty to modifiy the db??
thx in advance
bye
Hello,
I have an exrternal shared drive "E:"where I put my be files (which are constantly accessed by users with fe's from different terminals). Everytime
I reboot the computer that I am working on (where the external drive is), I have to set up the permissions of the shared drive "E:" all over again, otherwise other computers have no access to E. Is there a way that I could
fix this and not having to set permissions every time I reboot my computer?
For some reason, the permissions are lost.
Hello,
Im having some problems sharing a database. I need multiple users to be able to open the database at the same time. I have check TOOLS - OPTIONS - ADVANCED and my option is set to shared, but for some reason it will still only allow 1 user to open it at a time.
Does anyone know why this could be?
Thanks