I recently started a job at a medical staffing company, a database used to keep information was built by a lady there who has very limited Access experience (even less than me)
They run Access2k3, on WinXP desktops
The files and DB reside on the corporate server.
She complains that in the mornings the first person who opens the DB locks all others out, once they logout and the others log in everyone can begin working.
Through research I figure that the first person is opening the DB in "exclusive" mode therefore locking all others out.
1. How can I fix this "lockout" problem?
Some research says that the DB data should reside on the server, while the "frontend" should reside on the individual workstations.
2. Is this something that can be done after the fact?
Another problem is the caution box...
***Microsoft office access cant save design changes or save to a new database object because another user has the file open. To save your design changes or to save to a new object, you must have exclusive access to the file.***
3. Would the implementation of a DB users and groups schema help things?
For instance, setting having one DB admin and having the rest of the others set up as users.
The research I did online and in this forum helps a little, but most of it is over my head
Thanks in advance for any help...
Feb 10 '07
35  24460 
If you go into the VBA window (Alt-F11) you will have various windows available to you.
Press Ctrl-R to select the Project Explorer window. This can show up to three main folders :- Microsoft Office Access Class Objects
- Modules
- Class Modules
You need to open these three (or those that exist anyway). Each object within this structure can be selected and, using F7, the code opened. Let us know if you find any code more than the defaults :
- Option Compare Database
-
Option Explicit
Well I took a look
-I pulled up the VBA window, then project explorer
-in the VBA window on the left (project explorer) the name of the DB is listed
-there are no main folders eg. class objects, modules, class modules
-I highlight the name of the DB and use F7 but nothing comes up
-If I right click the DB name the option for "check code" is grayed out
Any ideas...
NeoPa 32,576
Recognized Expert Moderator MVP
If the Project Name doesn't have a little + in a box to the left of it then you don't have any code objects. Try the Macros (though I doubt they could change design).
If the Project Name doesn't have a little + in a box to the left of it then you don't have any code objects. Try the Macros (though I doubt they could change design).
Yeah, there is nothing there...
Now I cant get the DB unlocked, I have had the other users log out and restart but nothing seems to work.
Right before the "lockout" problem when they tried to open a form a dialog box appeared asking for them to "enter a parameter" and it gives the name of a column
(number)
I followed the instructions here: http://support.microso ft.com/kb/303134
I thought someone had changed the name of a field by accident but after I changed it the DB locked me out and said that I couldnt make design changes anymore...
NeoPa 32,576
Recognized Expert Moderator MVP
I'm sorry, but there's nothing you've told me so far that would explain why this is happening. I know that's a little along the lines of "Hands up all those pupils not here today..." but I can't think of anything that explains this without you're telling me something I need to know, or my looking at the database itself - which is not practical (unless you secretly live next door).
Did you check the Macros?
I'm sorry, but there's nothing you've told me so far that would explain why this is happening. I know that's a little along the lines of "Hands up all those pupils not here today..." but I can't think of anything that explains this without you're telling me something I need to know, or my looking at the database itself - which is not practical (unless you secretly live next door).
Did you check the Macros?
Don't be sorry, I understand it's a bit like me trying to explain why my dog is sick having never seen a dog...
I looked for the macros but they are not even in the window???
I tried to look at the code but there is none, it's probably me doing something wrong.
NeoPa 32,576
Recognized Expert Moderator MVP
Does your database use linked tables?
How large is your database? Including the linked tables?
Does your database use linked tables?
How large is your database? Including the linked tables?
That's the funny thing
-the DB's tables are not linked
-there are about 15 tables in the DB
-each table is stand-alone
Excuse me if I am not using the right terminology
when I open MS Access,
i open a db (widgetDB),
inside of that DB there are ~15 tables (widget1,2,3,et c.) (when I view them it looks like a spreadsheet wit the primary key on the left)
I look at the forms and it is a matrix of the column names, and the records
NeoPa 32,576
Recognized Expert Moderator MVP
What is the size of your WidgetDB.Mdb file?
What is the size of your WidgetDB.Mdb file?
That I can tell you as sson as she comes back...
What is the size of your WidgetDB.Mdb file?
Sorry about the delay.
In about an hour I will post the output of Documenter, hopefully someone will be able to see where the change in field names is making the "enter parameter value" box pop up.
This may also give NeoPa a better idea as to the structure of the DB.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Kent P. Iler |
last post by:
Hi,
I have an application that watches a directory using FileSystemWatcher.
When a specific type of files comes over, I want to parse it and then move
it.
However, these files can be somewhat large, and the FTP process isn't
complete when I try to access the files. In those instances, an exception
is thrown when I try to access the file.
|
by: Dave Reid |
last post by:
Hi everyone...
I'm trying to open a text file in exclusive mode (meaning I want to
lock out any other processes from accessing the file while I'm working with
it).
Here's my code:
ifstream fs_infile("field_summary.dat", filebuf::sh_none)
|
by: Wayne |
last post by:
Can someone please help with this problem. When referring to opening a
database in Exclusive mode the Access 2003 help says:
"Under Default open mode, do one of the following:
If you want others to be able to open the Microsoft Access database at
the same time you have it open, click Shared.
If you want sole access to the Access database when you have it open,
click Exclusive."
>From my experience and from what I have read on the...
|
by: Kobu |
last post by:
My question is about the use and meaning of the terms "declaration" and
"definition" as it pertains to the C language.
I've read sources that mix the two up when talking about such things as
setting aside storage for an object, defining/declaring a struct, parts
of a function, referencing an external variable in another module.
sourcefile1.c
==============
extern long globalfoo; /* declaration? */
|
by: Dave Benjamin |
last post by:
There's been a lot of discussion lately regarding Ruby and the notion of a
"humane" interface to objects like arrays and maps, as opposed to
"minimalist" ones. I believe the article that started the debates was this
one by Martin Fowler:
http://www.developertesting.com/archives/month200512/20051218-HumaneInterfaceOfMinimalInterface.html
And this one was posted in response by Bruce Eckel:
...
| | |
by: Jacek Dziedzic |
last post by:
Hi!
I often find that my programs need to store information on
"current mode of something" with two or at most several
mutually exclusive "modes" to choose from, e.g.
- datafile: is it in a) read-only mode or b) write-only mode,
- a function picking points a) above, b) below or c) contained
on a plane in 3D,
etc.
|
by: teddysnips |
last post by:
One of my clients has asked me to make a change to one of their Access
applications.
The application is a Front End/Back End standard app. I didn't
develop it, but looking at it tells me that it was done entirely using
the Wizards. There is no log-in procedure.
They want to amend it so that only one person can be logged in at any
one time. So, if Joe Bloggs tries to open the application, and Fred
Jones has already connected, Joe...
|
by: Samuel R. Neff |
last post by:
When is it appropriate to use "volatile" keyword? The docs simply
state:
"
The volatile modifier is usually used for a field that is accessed by
multiple threads without using the lock Statement (C# Reference)
statement to serialize access.
"
But when is it better to use "volatile" instead of "lock" ?
|
by: stefan.albert |
last post by:
Hi folks,
we have a little discussion about lock escalation...
What is better for performance: To have an escalation "early" (smaller
locklist) or aviod the escalation with a big lock list?
We don't care about concurrency - because the changes have to be done,
other SQL waiting for this is OK.
Anyhow - I think: A lock table in exclusive mode would be the the most
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
