I have an update table which I automatically would like to add to the master
table which is in use by other users. My idea is to add the records via an
update query. Is this a reliable method or can I run into problems and
should I do it another way?
Thanks,
john
4  1610 
On Sat, 16 Jun 2007 16:33:05 +0200, "John" <jo@hn.comwrote:
>I have an update table which I automatically would like to add to the master
table which is in use by other users. My idea is to add the records via an
update query. Is this a reliable method or can I run into problems and
should I do it another way?
Should work fine, the only problem being if a user has one or more of your tables locked (i.e. they're doing data entry
work, saving the data, etc).
>Thanks,
john
Scott McDaniel scott@takemeout_infotrakker.com www.infotrakker.com
"Scott McDaniel" <scott@NoSpam_Infotrakker.comschreef in bericht
news:3m********************************@4ax.com...
On Sat, 16 Jun 2007 16:33:05 +0200, "John" <jo@hn.comwrote:
>>I have an update table which I automatically would like to add to the
master
table which is in use by other users. My idea is to add the records via an
update query. Is this a reliable method or can I run into problems and
should I do it another way?
Should work fine, the only problem being if a user has one or more of your
tables locked (i.e. they're doing data entry
work, saving the data, etc).
Thanks Scott. I just realize I accicentally mentioned UPDATE query while it
should be an INSERT query. With an insert query, can record locking also be
a problem?
john
On Sun, 17 Jun 2007 13:44:06 +0200, "John" <jo@hn.comwrote:
>"Scott McDaniel" <scott@NoSpam_Infotrakker.comschreef in bericht
news:3m********************************@4ax.com.. .
>On Sat, 16 Jun 2007 16:33:05 +0200, "John" <jo@hn.comwrote:
>>>I have an update table which I automatically would like to add to the
master
table which is in use by other users. My idea is to add the records via an
update query. Is this a reliable method or can I run into problems and
should I do it another way?
Should work fine, the only problem being if a user has one or more of your
tables locked (i.e. they're doing data entry
work, saving the data, etc).
Thanks Scott. I just realize I accicentally mentioned UPDATE query while it
should be an INSERT query. With an insert query, can record locking also be
a problem?
Same scenario, although I'd say that Insert queries would tend to have less tendency to cause record lock issues, since
they would always be inserting new records (and obviously no one could be editing a new record).
>
john
Scott McDaniel scott@takemeout_infotrakker.com www.infotrakker.com
You also need to look at whether to use record level locking and how
the other users are accessing hte master table.
What version of Access are you using, and is the backend on a windows
2003 server or XP box?
Regards,
Tom Bizannes
Sydney, Australia
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: * ProteanThread * |
last post by:
but depends upon the clique:
...
|
by: Terri |
last post by:
I have a form with a multi-select combo. I dynamically build a SELECT
statement, open a report, and set the recordsource to my dynamic SELECT
statement. I count the records returned in the report...
|
by: Paul |
last post by:
I have a simple database - 3 fields (Parent,Component,Qty)
and I link this table to itself using Master File Parent and Link File
Component.
This creates a multi-indented table which I would...
|
by: doncee |
last post by:
Using a multi select list box to open several records in a
pre - defined form. Most of the code that follows is taken
from a posting by Alan Browne on his web site. The click
routine is supposed...
|
by: Dazbear |
last post by:
Hi There
Have been on a massive learning curve today creating an Access database
without having even started the software before this morning! All
going well and have learned to create table,...
|
by: mctime |
last post by:
Hello,
I am attempting to split a raw data table into a new table that has
split out a specific field in the raw data and created a new record
for each split but I have come to an impasse due to...
|
by: Dave |
last post by:
On my form I have combo boxes. These combo boxes, after updating
them, populate respective listboxes that are located below the combo
boxes on the same form. I am trying to use a "generate...
|
by: Hamilton sucks |
last post by:
Hi:
I need to add some records in a table called location(primary key:
loc_id). What I want to do is for each location in the table, I add
the same record but with a different loc_id, which can be...
|
by: zenosan |
last post by:
SunOS bsm1b 5.9 Generic_118558-09 sun4u sparc SUNW,Netra-440
This is perl, v5.6.1 built for sun4-solaris
I have listed the platform/OS information for your reference.
I need to extract...
|
by: Gun Slinger |
last post by:
Hi guys,
I have a quick question which i have pondered for a little while. I'm not sure if its even a good idea (so maybe advice on whether or not to do it would be helpful as well).
I want to...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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: 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,...
|
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...
| |
