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 RepliesHi 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
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?
View 14 Replies View RelatedI 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 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 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 RelatedWe 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?
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 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 RelatedI've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
Hi,
I setup a Security. And different user,
then it creates 2 files: Account.bak, and Secured.mdw
I can open it, but it cannot be opened on another computer, why??
I already setup.
Thanks.
every time i open .mdb file, i get a security warning that the file may be not safe to be opened if it conatins some code that might harm my computer.
in order to open the file' i have to press open.
how can i avoid this warning?
thank you.
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?
View 5 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 RelatedI 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 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?
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 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 RelatedI am new to databases so please bare with me on my question.
Question:
I have two Access databases (db1 and db2). Db1 needs information from certain Db2 fields (i.e. first name, last name). So I created a link table to Db2. I also created a query with the fields that is needed but I want to restrict access to the other fields in Db2 so that the user only has access to certain fields in Db2 such as the first and last name. Is there a way to set security to fields only and restrict the user to have access to those fields? If so, would this prevent them from editing the query that I created and adding those restricted fields?
Thank you,
BishopZ