I have been having an ongoing problem with a DB at work concerning people getting "locked out". Access warnings relating to "exclusive" mode
The research I have done and the replies received suggest I split the DB (front-end/back-end).
A working copy of the DB was split and I can see how the DB (back-end) is being updated.
Being such an Access noob (who did not actually build the DB)
I don't know what people mean exactly when they say to give each person a copy of the forms on their desktops. Actually, I know what they mean I just don't know how to do it.
Question, if each person has a copy of the DB on their workstations does the back-end only get updated when they hit save?
Is the back-end only really current when all people have logged out of that DB?
Is there any way for someone to get real time views of the front-end (at a particular workstation) from the back-end?
Thanks for the help
Chuck
Feb 20 '07
28 10258
Set the open mode of the backend to shared.
I checked the BE and the FE and both have their default open mode set to shared. I found it through tool-->options-->advanced tab
What do you think?
I know it is something I am missing I just can't see it...
MMcCarthy 14,534
Recognized Expert Moderator MVP
I checked the BE and the FE and both have their default open mode set to shared. I found it through tool-->options-->advanced tab
What do you think?
I know it is something I am missing I just can't see it...
Check the Record locking is set to Edited Record.
If so it sounds like it might be a network issue.
Mary
Check the Record locking is set to Edited Record.
If so it sounds like it might be a network issue.
Mary
Mary, I set the default record locking to 'edited record' it was 'no locks'
There is also a checked box entitled 'open databases using record-level locking'
I will give it a shot now after changing the default record lock
Thanks,
Chuck
Denburt 1,356
Recognized Expert Top Contributor
I have seen similar situations networks can be fun. You stated that you are an access noob but I don't know if you have any programming experience. I have some code for distributing copies and making updates, but you will need to tailor it a little for your purposes.
What I do is set up my Main menu with a version number I use two tables one linked to the backend and one local table in the front end if I update the servers copy with a new version number my clients will see a message with in about 5 min (using the timer on the main menu). I never close the main menu I always hide/unhide it so the timer is always there. When the message pops up they click yes or no and is yes then they get the newer version (code I use creates a VBS script for copying and reopening the new version for you) all completely automated.
I also added a feature so that a new user can click on the front end located on the server and they get a message requesting them to click ok so it will copy to there local hard drive and open from there.
It also adds a shortcut to the desktop btw.
If you feel up to the task let me know and I will be glad to help.
I have seen similar situations networks can be fun. You stated that you are an access noob but I don't know if you have any programming experience. I have some code for distributing copies and making updates, but you will need to tailor it a little for your purposes.
What I do is set up my Main menu with a version number I use two tables one linked to the backend and one local table in the front end if I update the servers copy with a new version number my clients will see a message with in about 5 min (using the timer on the main menu). I never close the main menu I always hide/unhide it so the timer is always there. When the message pops up they click yes or no and is yes then they get the newer version (code I use creates a VBS script for copying and reopening the new version for you) all completely automated.
I also added a feature so that a new user can click on the front end located on the server and they get a message requesting them to click ok so it will copy to there local hard drive and open from there.
It also adds a shortcut to the desktop btw.
If you feel up to the task let me know and I will be glad to help.
Do you mean you just have them grab a copy of the FE from the server everytime they attempt to open the DB, could this fix this "records opening uneditable" problem for me?
I changed the default open modes but no joy...
Check the Record locking is set to Edited Record.
If so it sounds like it might be a network issue.
Mary
Mary what I am doing is:
I changed the default record locking to shared
on another workstation I navigate to the share where the MDE is
I drag a copy onto their desktop
when I open it does not allow me to enter text...
Ideas???
I am fairly sure it is not the network, the problem probably lies between the keyboard and the chair...
Denburt 1,356
Recognized Expert Top Contributor
Do you mean you just have them grab a copy of the FE from the server everytime they attempt to open the DB, could this fix this "records opening uneditable" problem for me?
That would probably be an easy solution for you just let them copy the front end to their hard drive and then they will have a copy.
I was simply stating that I use VBA to automate the copying process. I got tired of people calling me and saying they copied it but lost it. :)
MMcCarthy 14,534
Recognized Expert Moderator MVP
Mary what I am doing is:
I changed the default record locking to shared
on another workstation I navigate to the share where the MDE is
I drag a copy onto their desktop
when I open it does not allow me to enter text...
Ideas???
I am fairly sure it is not the network, the problem probably lies between the keyboard and the chair...
Just our of curiousity don't drag a copy just create a shortcut and see if you have the same problem.
Mary
Just our of curiousity don't drag a copy just create a shortcut and see if you have the same problem.
Mary
I made a shortcut and stuck it on the desktop, when I clicked it I got a dialog box saying that 'DistributedFE. mde is a read only file you will not be able to edit blah blah blah'
MMcCarthy 14,534
Recognized Expert Moderator MVP
I made a shortcut and stuck it on the desktop, when I clicked it I got a dialog box saying that 'DistributedFE. mde is a read only file you will not be able to edit blah blah blah'
OK copy it down and right click to get the file properties and see if the file is set to read only.
You did say you could open and edit the file directly on the network didn't you?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: delerious |
last post by:
I see some code examples like this:
<DIV onmouseover="this.style.background='blue'">
and other code examples like this:
<DIV onmouseover="javascript:this.style.background='blue'">
Which way is more proper? Or are both ways perfectly fine? Are there any
specifications that discuss when "javascript:" should be put in front of code?
|
by: Steve Juranich |
last post by:
I know that this topic has the potential for blowing up in my face,
but I can't help asking. I've been using Python since 1.5.1, so I'm
not what you'd call a "n00b". I dutifully evangelize on the goodness
of Python whenever I talk with fellow developers, but I always hit a
snag when it comes to discussing the finer points of the execution
model (specifically, exceptions).
Without fail, when I start talking with some of the "old-timers"...
|
by: Douglas Collie |
last post by:
Is there a bug using an untyped memory based data set?
I have a form with a tab control, on one tab is a data
grid linked to a dataset which I add data to at regular
intervals.
I have a second top level window opened by the app.
The app opens with Form1 showing a tab without the data
grid.
I open the second Form and everything is ok.
|
by: Rey |
last post by:
Howdy all.
Was wondering if there is any resolution for err 3734:
"The database has been placed in a state by user X on machine Y that
prevents it from being opened or locked."
I've spent time reearching err and found no real solution but then
maybe I stopped reading posts to soon 8-)
Believe this occurs after either an err has occurred and/or I've
|
by: vijay |
last post by:
Hello,
As the subject suggests, I need to print the string in the reverse
order. I made the following program:
# include<stdio.h>
struct llnode
{
char *info;
| |
by: Jake Barnes |
last post by:
This function has always worked for me just fine:
function nl2br_js(myString){
// 02-18-06 - this function imitates the PHP command nl2br, which
finds newlines in a string
// and replaces them with newlines plus HTML BR tags. Is the easiest
way to create the
// appearance of paragraphs when people are creating web pages by
typing text into a form.
var regXString = "\\n"
|
by: jacob navia |
last post by:
In this group there is a bunch of people that call themselves 'regulars'
that insist in something called "portability".
Portability for them means the least common denominator.
Write your code so that it will compile in all old and broken
compilers, preferably in such a fashion that it can be moved with no
effort from the embedded system in the coffe machine to the 64 bit
processor in your desktop.
|
by: marathoner |
last post by:
I would like to read the following entries of mixed data types from a ascii
text file using C#. This can be easily performed in C using fscanf. Is
there an equivalent function in C#?
1 2 1201 1 -0.417597000000000D+06 0.129600000000000D+06
0.0 0.753000000000000D+03 0.198800000000000D+04
Marathoner
|
by: kevineller794 |
last post by:
I want to make a split string function, but it's getting complicated.
What I want to do is make a function with a String, BeginStr and an
EndStr variable, and I want it to return it in a char array.
For example:
char teststr;
strcpy(teststr, "test:blah;");
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: 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
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |