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?
Hi 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
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 RelatedHow can I get a form to open when the database opens?
View 5 Replies View RelatedI have a FE DB that I have been opening and closing at various times without incident. Now all of a sudden it only opens as READ ONLY. I can't find anyone with a BE open that might be causing this. What will cause this? If I save a copy and then replace the original will I lose my data?
View 6 Replies View RelatedI am sure this has come up a thousand times and I searched but could find nothing about this. I have a database with one main form and many queries. When the database is opened by users I would like for only the form to show. I do have queries in a dropdown list on the form to run. Basically, I only want the form to show when the database is open but I want to be able to get to the menu's etc when I need to.
Please help.
Hi,
When the user clicks on the file name, I want the form to load automatically & also at the same time minimize the database window (i.e. the window where all the tables, queries etc are listed). Any suggestions?
Thx in advance,
Jatz
I have several subform tabs and one that I have updated no longer shows up when I run the form on Form mode. The tab is there but no content or details of the subform
View 3 Replies View RelatedWe have a database on a PC located on our network. The database is located in this computer's shared folder. Another database grabs data from this database occasionally. We're running into a problem where we cannot open the DB located in the shared folder (permissions granted) without it being a read only instance even with no users accessing the DB.
View 6 Replies View RelatedI am having problems opening my databases. Access automatically opens them in 'Read Only' mode, and I cannot find a way to avoid this - so I can never add data to the original tables ....
View 2 Replies View RelatedI would like to be able to check if a db is open and if it is to prevent the user from proceeding.
I use the Access 2013 Runtime. I can check if a db is open by trying to open Exclusively, using something like
Code: [URL] ....
But if the db is already open Not exclusively and I try to open it exclusively it does not raise an error and it allows the user to open the db in Read Only mode.
I would like to be able to prevent this, because careless and/or inexperienced users may open several instances of the db.
Of course, if the db is already open exclusively it does not allow you to open it exclusively another time.
I'm working in Access 2010. I created a database that I want to post in a server on the read-only mode, so that users can not change forms or querys. How can I do this in Access 2010?
View 11 Replies View RelatedI just finished a small Access-2013 database (accdb format).
Now I want to make it available to users.
How do I make an 'executable' (meaning that tables, forms, ... cannot be opened in design mode)?
I have two separate database files, a front end with all my forms and a back end with all my tables. The backend is stored on a network drive, is there any way of being able to store the frontend on the drive with the backend? Users do not use the actual computer to store information or access files, everything is usually saved on the network drive. I have created a shortcut that launches the front end database in the read only kiosk mode.
View 5 Replies View RelatedIs it possible to open multiple forms when the database opens? Currently only one form opens. I am using Access 2010.
View 5 Replies View RelatedHi,
I've been given an existing database to modify, and I'm struggling somewhat to see how the author has implemented certain functions.
On a main menu form (autoexecs on starting the database), there are various "Search By" option buttons to generate a report, ordered in various ways. The "On Click" field for each of them refers to a macro, called Buttons, and a line in that macro dependant on the type of search (e.g. OnClick = Buttons.byPerson).
The Buttons macro runs an OpenReport command, the report corresponding to the search type (e.g. Buttons.byPerson has an OpenReport command for the "Report by Person" report).
However, when I click the search buttons (or indeed run the corresponding reports) I instead get another form which allows the search criteria to be specified - this then generates the report (I would assume based on the relevant query - e.g. Person Query), but I cannot understand how this works.
Google searches have not helped much as I can't seem to find an adequate search phrase to use, and I've been staring at the thing for some hours now. Any help getting me off in the right direction would be much appreciated!
Is 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 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?