Hi - I have a database on a network, and each user logins using a
shortcut from his PC to the shared database. There is a table created by
a make-table query that locks up whenever more than one user is in the
database. It doesn't matter that the users open completely different
clients, forms, etc, as long as there are more than one user opens the
database this table locks up. And the function that recalculates the
amount doesn't work.
Any idea how to solve this problem? I would appreciate it very much.
Noni 8 2105
Noni,
Problems such as the ones you describe usually clear up as if by magic when
the database is split into a Front-End and a Back-End.
The Front-End contains all Queries, Forms, Reports, Macros, Modules and
local-use tables. The Front-End contains links to the tables in the
Back-End, which contains only Tables containing data which is to be shared.
Each Front-End is then distributed to and run from each user's hard drive.
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
"Noni Ledford" <NO********@NOs tretchSPAMphoto graphy.com> wrote in message
news:NO******** *************** *******@news03. east.earthlink. net... Hi - I have a database on a network, and each user logins using a shortcut from his PC to the shared database. There is a table created by a make-table query that locks up whenever more than one user is in the database. It doesn't matter that the users open completely different clients, forms, etc, as long as there are more than one user opens the database this table locks up. And the function that recalculates the amount doesn't work.
Any idea how to solve this problem? I would appreciate it very much.
Noni
In article <#5************ *@TK2MSFTNGP10. phx.gbl>,
"Cheryl Fischer" <ch***********@ NOSPAMmsn.com> wrote: Noni,
Problems such as the ones you describe usually clear up as if by magic when the database is split into a Front-End and a Back-End.
The Front-End contains all Queries, Forms, Reports, Macros, Modules and local-use tables. The Front-End contains links to the tables in the Back-End, which contains only Tables containing data which is to be shared. Each Front-End is then distributed to and run from each user's hard drive.
--
Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX
"Noni Ledford" <NO********@NOs tretchSPAMphoto graphy.com> wrote in message news:NO******** *************** *******@news03. east.earthlink. net... Hi - I have a database on a network, and each user logins using a shortcut from his PC to the shared database. There is a table created by a make-table query that locks up whenever more than one user is in the database. It doesn't matter that the users open completely different clients, forms, etc, as long as there are more than one user opens the database this table locks up. And the function that recalculates the amount doesn't work.
Any idea how to solve this problem? I would appreciate it very much.
Noni
Thanks Cheryl. I appreciate yor suggestion. This database doesn't have
any local-use tables, all the tables are shared. Would it be a good
idea if I split the database Front-End: Queries, Forms, Reports, Macros,
Modules, and Back-End: all tables? Or is there any other way to split
it?
Thanks so much,
Noni Ledford
The split of your database as I described it earlier would be considered the
"best practice", although I think there might be some room for exceptions.
I have not myself seen such an exception, but it's possible.
I wonder about your Make-Table query. What is its purpose?
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
"Noni Ledford" <NO********@NOs tretchSPAMphoto graphy.com> wrote in message
news:NO******** *************** *******@news03. east.earthlink. net... In article <#5************ *@TK2MSFTNGP10. phx.gbl>, "Cheryl Fischer" <ch***********@ NOSPAMmsn.com> wrote:
Noni,
Problems such as the ones you describe usually clear up as if by magic
when the database is split into a Front-End and a Back-End.
The Front-End contains all Queries, Forms, Reports, Macros, Modules and local-use tables. The Front-End contains links to the tables in the Back-End, which contains only Tables containing data which is to be
shared. Each Front-End is then distributed to and run from each user's hard
drive.
--
Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX
"Noni Ledford" <NO********@NOs tretchSPAMphoto graphy.com> wrote in
message news:NO******** *************** *******@news03. east.earthlink. net... Hi - I have a database on a network, and each user logins using a shortcut from his PC to the shared database. There is a table created
by a make-table query that locks up whenever more than one user is in the database. It doesn't matter that the users open completely different clients, forms, etc, as long as there are more than one user opens the database this table locks up. And the function that recalculates the amount doesn't work.
Any idea how to solve this problem? I would appreciate it very much.
Noni
Thanks Cheryl. I appreciate yor suggestion. This database doesn't have any local-use tables, all the tables are shared. Would it be a good idea if I split the database Front-End: Queries, Forms, Reports, Macros, Modules, and Back-End: all tables? Or is there any other way to split it?
Thanks so much, Noni Ledford
Noni Ledford <NO********@NOs tretchSPAMphoto graphy.com> wrote: Hi - I have a database on a network, and each user logins using a shortcut from his PC to the shared database. There is a table created by a make-table query that locks up whenever more than one user is in the database. It doesn't matter that the users open completely different clients, forms, etc, as long as there are more than one user opens the database this table locks up. And the function that recalculates the amount doesn't work.
1) I'd agree with Cheryl. Split your MDB.
See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp.htm for more info. See
the Auto FE Updater downloads page http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.
2) I'd suggest you create a temporary MDB and store the table created
by your make table query in there instead.
See the TempTables.MDB page at my website which illustrates how to use
a temporary MDB in your app. http://www.granite.ab.ca/access/temptables.htm
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony and Cheryl, thanks so muh for your suggestions. I've been reading
more about database split from your links, and finding more information
about it. It makes sense. I appreciate your expertise. Once I split
the database I may ask you other questions. Thanks again.
Noni
In article <kt************ *************** *****@4ax.com>,
Tony Toews <tt****@teluspl anet.net> wrote: Noni Ledford <NO********@NOs tretchSPAMphoto graphy.com> wrote:
Hi - I have a database on a network, and each user logins using a shortcut from his PC to the shared database. There is a table created by a make-table query that locks up whenever more than one user is in the database. It doesn't matter that the users open completely different clients, forms, etc, as long as there are more than one user opens the database this table locks up. And the function that recalculates the amount doesn't work.
1) I'd agree with Cheryl. Split your MDB.
See the "Splitting your app into a front end and back end Tips" page at http://www.granite.ab.ca/access/splitapp.htm for more info. See the Auto FE Updater downloads page http://www.granite.ab.ca/access/autofe.htm to make this relatively painless.. It also supports Terminal Server/Citrix quite nicely.
2) I'd suggest you create a temporary MDB and store the table created by your make table query in there instead.
See the TempTables.MDB page at my website which illustrates how to use a temporary MDB in your app. http://www.granite.ab.ca/access/temptables.htm
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Noni Ledford <NO********@NOs tretchSPAMphoto graphy.com> wrote: Tony and Cheryl, thanks so muh for your suggestions. I've been reading more about database split from your links, and finding more information about it. It makes sense. I appreciate your expertise.
You're quite welcome.
Once I split the database I may ask you other questions.
Please ask. That's what we're here for.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
I have a similar problem. I am using a billing program (Office
Therapy) that is based on Access and intermittently it locks up and
will not let the server enter numbers. Others on the network
accessing the server have no problems. The program will take one
letter, then writes over that letter, indicating only one field is
available, but it will not take any numbers. No error message is
generated. I know nothing about Access and am at a loss as to what to
try and the program no longer provides technical support. Any help
would be appreciated.
Thanks,
Ed ea****@aol.com (Ed) wrote: I have a similar problem. I am using a billing program (Office Therapy) that is based on Access and intermittently it locks up and will not let the server enter numbers. Others on the network accessing the server have no problems. The program will take one letter, then writes over that letter, indicating only one field is available, but it will not take any numbers.
Ah, so Access only allows you to enter one character into that field. You enter
another one and it overwrites that character?
That is wierd. Let us think on that one for a bit.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sean C. |
last post by:
Helpful folks,
Most of my previous experience with DB2 was on s390 mainframe systems
and the optimizer on this platform always seemed very predictable and
consistent. Since moving to a WinNT/UDB 7.2 environment, the choices
the optimizer makes often seem flaky. But this last example really
floored me. I was hoping someone could explain why I get worse
response time when the optimizer uses two indexes, than when it uses
one. Some context:
|
by: sql-db2-dba |
last post by:
We have DB2 UDB v8.1 fixpak3 on AIX 5. Production and Development
configuarations (at least for DB2) are identical albeit production is
a 2-way server while development has only one processor. Tables and
indexes have the same schema. In fact, the dev database was taken from
a prod backup recently. Size of the tables differ slightly. Yet, on a
given query (with 4 tables joined), it took 30-50 times longer to run
in prod than on development....
|
by: MHenry |
last post by:
Hi,
We were going merrily along for 6 years using this database to record
all client checks that came into our office, including information
about what the checks were for.
Suddenly, network computers cannot access the database.
The message is...
|
by: Noni Ledford |
last post by:
Hi - I have a database on a network, and each user logins using a
shortcut from his PC to the shared database. There is a table created by
a make-table query that locks up whenever more than one user is in the
database. It doesn't matter that the users open completely different
clients, forms, etc, as long as there are more than one user opens the
database this table locks up. And the function that recalculates the
amount doesn't work.
...
|
by: Roy Padgett |
last post by:
I have a combo box where users select the customer name and can either
go to the customer's info or open a list of the customer's orders.
The RowSource for the combo box was a simple pass-through query:
SELECT DISTINCT , , ,City,
Region FROM Customers ORDER BY Customers.;
This was working fine until a couple of weeks ago. Now whenever
someone has the form open, this statement locks the entire Customers
table.
| |
by: Fabio R. |
last post by:
To support a webfarm scenario, I'd like to store a global array (serialized)
in a file on a network share.
In this array there is a list of pages "locked" by other users so I need to
read this array at every page access to detect if the page is "free" so the
user can access it; when the user can access the page, the page is added to
the array so the next user can't access.
What's the best way to lock this (network) file so when 2 users...
|
by: adri4n |
last post by:
as wat ive mentioned in the title.. im would like to know whether the a
particular record/table is being locked in my program. some of the
methods which i would like to develop are as below:
Lock(KEY, SQLCODE)
- to create a lock. Returns 0 on success, 1 if a lock already exists
and -1 on failure with SQLCODE. There is no necessity to use IsLock()
for checking if a lock exists or not, just insert the record and check
for
|
by: NEWSGROUPS |
last post by:
I work for a large organization were my team has developed 2 very
substantial databases in Access 2000. These databases have been working fine
for the last 6 years with minimal issues or problems. About 1 week ago today
we have started experiencing the error "Microsoft Visual Basic Run Time
Error 3043 Disk or Network Error" just about every day around the same time
each day (activity starts to increase at this time in the databases)....
|
by: ThePhenix |
last post by:
Hi everybody,
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified...
|
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: 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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |