I am a real newby at this so forgive me if I don't give the right information, but here is my problem:
I've created a shared MS Access database for my clinic, which we use for patient check in. At some times it is used by up to 20 people at a time. Intermittently, the file will become locked by an "Admin" and it will list which computer they are working from. The file is not split (I just learned about that), but I know it is set to be a shared file and it is saved on a shared network drive. The computer that becomes the "Admin" is not the first to open the db. Those that are already logged in are not affected by the lock, but anyone else that tries to open it after the fact are not able to get in. Sometimes the problem sporadically solves itself, and sometimes we have to exit the program on the "admin" computer and then reopen. Then everyone is able to get in. The times I've been able to find the "admin" computer that is taking exclusive access, the user is simply on the DB making their changes and using it as usual, which should not cause it to be locking up like that. HELP!
4  1156 
Splitting the database into a front-end and a back-end is not an option. It's not just a nice idea. If you don't do it, you're going to have this problem and worse, much worse.
Give each user their own, personal front-end copy.
Do that, then come back here if you have more problems.
Jim
I thought that might be the case... In that case a have a couple more questions...
I have over 100 potential users, each of whom may use any one of dozens of PCs. If the front end is saved on the shared network drive, will that work for everyone, or do I really need to distribute to each user, each PC? I also can't email the db or use flash drives, plus we will be using a new db each quarter so it would be a real hassle to have to install it on every PC every 3 months.
I will be the main back end user but I will be training in a secondary person in case I'm gone. Can the back end be saved on the shared drive as well, in a separate (locked?) file? Also, I would potentially be working on it from any of those PCs.
Can I make design changes to the back end (including to the forms and reports) while front end users are using the db? That would solve some problems for me too.
I really appreciate your help. Thanks!
Everyone must have their own copy of the front-end. Your queries, reports, forms and macros are only in the front-end. The back-end is only data and the back-end must exist only once; that is, it must be on a shared network drive.
Give everyone a batch file or other tool to automatically update their copy of the front-end from time to time. You might want to add some versioning logic to enforce updates when needed. Make sure to educate them about being OUT of the program when they copy the new version to their PC.
Make all the program updates you like on your own copy of the front-end. Don't be tinkering in the back-end while others are trying to use the system.
Jim
I agree with everything that Jim has provided. You can tell he's been doing it for a while.
I wanted to add a link as there are varied approaches to splitting the Database ( http://bytes.com/topic/access/insigh...ront-back-ends ) and this might help you with building your process.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Megan |
last post by:
Hi-
I have a question about the Microsoft Access Record-Locking
Information Icon.
Whenever I, or my friends, open my MS Access database, the Microsoft
Access Record-Locking Information Icon...
|
by: eddie wang |
last post by:
Hello,
I am working on an Access database. For some strange reason, my query
keeps getting erased by itself. The SQL view of my query object looks
like this: SELECT *
FROM emp
WHERE...
|
by: TS |
last post by:
in my web project's bin folder, the dll, that comes from a project reference
of a class library in same solution, can't be deleted. it says it has a
sharing violation. i also cannot delete the...
|
by: john |
last post by:
When I copy an Access record to the clipboard it automatically copies the
field names along with it. In this particular case I don't want that to
happen. Is there by any chance a way to only copy...
|
by: tricard |
last post by:
Good afternoon all,
I have recently been trying my hand out at the ADO model as before I
have only used DAO (just thought I would expand my knowledge a bit).
The problem I am having is that...
|
by: DR |
last post by:
I set my database to trustworthy and deployed this clr stored proc as unsafe
ok but when i run this it returns 1 each time. as if ival keeps getting set
back to 0 each time i call this clr stored...
|
by: mailtofinny |
last post by:
Hi
This is my first post to this forum.
I am struck up with a problem.
We have a perl script which deals with creation/deletion of files. This perl script is trigerred through a java...
|
by: matrekz42 |
last post by:
Good morning Guru's
I have a form that has a combo box and the source of a combo keeps getting changed by itself.
I haven't found the pattern if it happens after compact and repair or after...
|
by: =?Utf-8?B?VHVybnBpa2UgSVQ=?= |
last post by:
So we have a Xerox x65 set up in all of our business centers. There is a an
account ono the server called scanuser. Our networking guys cant figure out
why ths account is getting locked out for no...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
|
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,...
| |
