I am in a situation where my supervisor doesn't want the mdb split
into front end and back ends, as he sees it as being impractical. I
also see it as being impractical, as it will only recieve moderate
usage and the number of records should be around 5000. There will be
around 25 different people using the db, but only a handful at a time.
I am coming across the situation while testing that access says that
the db is corrupt and needs repaired for some users, while it
functions just fine with other users still in the database. What can
be done to alleviate this? If a user changes a global variable, will
it be changed for another user?
7  1271 
"isaphrael" <id******@yahoo .com> wrote in message
news:54******** *************** ***@posting.goo gle.com... I am in a situation where my supervisor doesn't want the mdb split
into front end and back ends, as he sees it as being impractical. I
also see it as being impractical, as it will only recieve moderate
usage and the number of records should be around 5000. There will be
around 25 different people using the db, but only a handful at a time.
I am coming across the situation while testing that access says that
the db is corrupt and needs repaired for some users, while it
functions just fine with other users still in the database. What can
be done to alleviate this?
Split the app.
If a user changes a global variable, will
it be changed for another user?
No
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com id******@yahoo. com (isaphrael) wrote in message news:<54******* *************** ****@posting.go ogle.com>... If a user changes a global variable, will
it be changed for another user?
I would just add to Rick's answer that a common source of frustrating
for Access developers using Global (aka Public variables) is that an
unhandled error will reset all those variable to default values.
There are several approaches to solving that problem - but the bottom
line is that global variables are a "Bad Thing" to be avoided for
several reasons besides this issue.
You could store values in a table or in database properties and use a
class to handle the interface to code that needs those values.
'---------------
' John Mishefske
'---------------
Hi,
Your boss is totally wrong about the practicality of splitting the database.
Keeping it as a monolithic whole will lead to more problems that splitting
it. There will also be issues that arise from splitting it but they are all
solvable.
He has made a decision in your domain that isn't his to make unless he is
taking full responsibility for the fitness and quality of your application.
By that, I mean really taking responsibility as when HIS boss asks why it's
so buggy and hard to use, he will step up and say "It's my fault because I
dictated the design". Would he hire a carpenter to put an addition on his
house and then insist that the carpenter could use neither hammer nor saw?
HTH
--
-Larry-
--
"isaphrael" <id******@yahoo .com> wrote in message
news:54******** *************** ***@posting.goo gle.com... I am in a situation where my supervisor doesn't want the mdb split
into front end and back ends, as he sees it as being impractical. I
also see it as being impractical, as it will only recieve moderate
usage and the number of records should be around 5000. There will be
around 25 different people using the db, but only a handful at a time.
I am coming across the situation while testing that access says that
the db is corrupt and needs repaired for some users, while it
functions just fine with other users still in the database. What can
be done to alleviate this? If a user changes a global variable, will
it be changed for another user? id******@yahoo. com (isaphrael) wrote: my supervisor doesn't want the mdb split
into front end and back ends
Is he/she an Access developer? I doubt it, else they would not have made
the statement. They shouldn't care whether or not it's split, just that it
works. It will only work if you split it and provide each user with their
own front end.
Regards,
Keith.
"almish" <mi****@execpc. com> wrote in message
news:95******** *************** ***@posting.goo gle.com... id******@yahoo. com (isaphrael) wrote in message
news:<54******* *************** ****@posting.go ogle.com>... If a user changes a global variable, will
it be changed for another user?
I would just add to Rick's answer that a common source of frustrating
for Access developers using Global (aka Public variables) is that an
unhandled error will reset all those variable to default values.
There are several approaches to solving that problem - but the bottom
line is that global variables are a "Bad Thing" to be avoided for
several reasons besides this issue.
You could store values in a table or in database properties and use a
class to handle the interface to code that needs those values.
This doesn't happen with MDEs however; and unhandled errors should be
extremely rare anyway. I use lots of public variables and have never seen
a problem with them.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Well, my question has pretty much been answered, and that is that for
multiple people to use an access database concurrently, it has to be
split. I'm a relative novice with Access, so that was the big
question hanging at the back of my mind. I just wasn't able to find a
definative answer to "does it have to be split?" anywhere.
It would 'glitch' after 2 people opened it, but nothing was corrupted,
just access saying that it was corrupt.
Thanks for your responses!
> I am in a situation where my supervisor doesn't want the mdb split into front end and back ends, as he sees it as being impractical. I
also see it as being impractical, as it will only recieve moderate
usage and the number of records should be around 5000. There will be
around 25 different people using the db, but only a handful at a time.
I am coming across the situation while testing that access says that
the db is corrupt and needs repaired for some users, while it
functions just fine with other users still in the database.
It's not impractical at all, nor is it difficult or time consuming to
implement, and is much more stable. Split the app. You won't regret
it. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Greg Lindstrom |
last post by:
Hello-
I have a base class which does the heavy lifting associated with creating,
modifying, and writing record segments for an application I've developed.
One of the requirements of the app is I must track how many segments have
been written to the output stream. Since the Write() method is in the base
class, I'd like to add a member in the base class, but I would like to
"share" it across all objects created with the base class....
|
by: cybertof |
last post by:
Hi !
What is the common use of sharing a single .cs across multiple project
files ?
I think it's to share common classes between projects.
I have actually a .cs file shared accross multiple projects in a same
solution. It's nice to have a common "set" of Classes.
Is this the only way to share classes between projects ?
|
by: Robert W. |
last post by:
I'm embarking on a project that will have both a desktop application and a
Pocket PC application. It seems logical to have as much code as possible
sitting in a shared project, which would be referenced and utilized by both
the Windows Forms application and the Mobile Device application.
Are there any "gotchas" (ie. warnings) that anyone knows about in following
this approach?
Robert W.
Vancouver, BC
|
by: Cowboy \(Gregory A. Beamer\) |
last post by:
Background:
-------------
The idea started as a single sign on type of application. Having tested it
before, I knew we could institute single sign on using the same
Authentication Cookie name (in this case "AuthenticationCookie" -- yeah,
original, I know) and the same machine keys for the applications.
<authentication mode="Forms">
<forms name="AuthenticationCookie" path="/"
loginUrl="login.aspx" protection="All" timeout="10" />
|
by: BPearson |
last post by:
Hello
I would like to have several sites share a single web.config file. To accomplish this, I would point the root of these sites to the same folder. Is there any reason why I might not want to do this? (IIS 5 or 6
In case you're wondering why I would do this, we have many web sites on a single server, and there are groups of sites that need to share common configuration information. I'd like to ease some administration by having one...
| | |
by: qube3 |
last post by:
We have applications written by JSP/Servlet and ASP.NET. All our future
development would be based on ASP.NET.
We wants to develop a single user interface so that users would not be aware
that some of the modules they are using are implement by JSP or ASP.NET
(e.g. no need to login both JSP and ASP.NET applications)? Are there any
suggestions to share the session in formation among JSP and ASP.NET, or some
single-sign on solution.
|
by: Daniel P. |
last post by:
http://danutp.blogspot.com/
Web Services - sharing data between client and server
Dealing a lot with web services a friend of mine (Ehsan Samani) and I ran
into another issue: when we move data from web services to the smart client
and back the classes created by the proxy are not identical with the ones on
the web services side. If the types we create are really complex then the
code associated is complex too. Sharing the code between...
|
by: Max Vit |
last post by:
I have deployed few Access apps splitting it in Front End and Back
End. Our environment uses Win XP SP2 for clients, Win 2k3 for servers
and Access 2003. The max. number of clients is about 50 (concurrent
users is estimated around 10).
Whilst the Back End always lives on a server, I am not quite clear
where the Front End should live.
I have searched the web and find contradicting views.
|
by: limperger |
last post by:
Hello everybody!
I have just found out that the sharing properties of a single database (mdb file on a network), accessed by 3 users, change depending on the user accessing the database. That is, with the file opened by 2 users at the same time, in my computer, the sharing properties appeared as set to share (not exclusive) and single entry-lock. Nevertheless, in the computer of the other user, the sharing properties are set to exclusive mode...
|
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: 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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
