473,320 Members | 1,746 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem Tables

I recall in my Paradox days that when appending records to a table or
updating records and data type conflicts or key violations were
automatically placed in tables called "Problem" or "Key_Viol". This was
very helpful in that Paradox performed the requested action while making a
table showing those records which were not included in the requested action
due to some type of conflict. The "Problems" or "Key Violators" could be
seen, analyzed and fixed just by viewing the table. I've been around
MSAccess (A97-XP) for a few years now and haven't seen anything comparable
to this great Paradox feature. When presented with a conflict, MSAccess
provides a 'Warning' that it did not add 'this many records for this reason
and did not add that many records for that reason and so on and so on', but
will not display the affected records. Similarly, Paradox had a "Subtract"
records function which would place the 'Subtracted' records in their own
'Subtracted' table. The closest thing to this that I've seen in Access is
the "Delete" query which does not automatically produce a table of the
subtracted (Deleted) records. Does anyone here know if MSAccess has a
similar feature or some "wizard" that will produce the same result in either
case?

TIA...
Earl Anderson
Nov 12 '05 #1
2 2203
AFAIK, Access does not mimic the useful features you describe in Paradox.
The closest I know of it coming is the "Import_Errors" table it will produce
when some rows of an imported table fail.

You can "roll your own" routines to produce such tables by determining the
conditions and querying for them.
For example, if you want to append the records in TableA to those in TableB,
both with primary key PK, you could create a Select statement like this:
"SELECT * FROM TableA WHERE TableA.PK IN (SELECT PK FROM TableB)"
This will return all records from Table A which already have matches in
TableB.

HTH
- Turtle
"Earl Anderson" <is*****@rcn.com> wrote in message
news:bj**********@bob.news.rcn.net...
I recall in my Paradox days that when appending records to a table or
updating records and data type conflicts or key violations were
automatically placed in tables called "Problem" or "Key_Viol". This was
very helpful in that Paradox performed the requested action while making a
table showing those records which were not included in the requested action due to some type of conflict. The "Problems" or "Key Violators" could be
seen, analyzed and fixed just by viewing the table. I've been around
MSAccess (A97-XP) for a few years now and haven't seen anything comparable
to this great Paradox feature. When presented with a conflict, MSAccess
provides a 'Warning' that it did not add 'this many records for this reason and did not add that many records for that reason and so on and so on', but will not display the affected records. Similarly, Paradox had a "Subtract"
records function which would place the 'Subtracted' records in their own
'Subtracted' table. The closest thing to this that I've seen in Access is
the "Delete" query which does not automatically produce a table of the
subtracted (Deleted) records. Does anyone here know if MSAccess has a
similar feature or some "wizard" that will produce the same result in either case?

TIA...
Earl Anderson

Nov 12 '05 #2
"Earl Anderson" <is*****@rcn.com> wrote in message news:<bj**********@bob.news.rcn.net>...
I recall in my Paradox days that when appending records to a table or
updating records and data type conflicts or key violations were
automatically placed in tables called "Problem" or "Key_Viol". This was
very helpful in that Paradox performed the requested action while making a
table showing those records which were not included in the requested action
due to some type of conflict. The "Problems" or "Key Violators" could be
seen, analyzed and fixed just by viewing the table. I've been around
MSAccess (A97-XP) for a few years now and haven't seen anything comparable
to this great Paradox feature. When presented with a conflict, MSAccess
provides a 'Warning' that it did not add 'this many records for this reason
and did not add that many records for that reason and so on and so on', but
will not display the affected records. Similarly, Paradox had a "Subtract"
records function which would place the 'Subtracted' records in their own
'Subtracted' table. The closest thing to this that I've seen in Access is
the "Delete" query which does not automatically produce a table of the
subtracted (Deleted) records. Does anyone here know if MSAccess has a
similar feature or some "wizard" that will produce the same result in either
case?

TIA...
Earl Anderson

Ms-Access does display the affected records in a table called Paste
Errors. It is an automatic function and usually is preceded by an
Error message. However, anything that you delete is gone, unless you
specifically write a script to save it elsewhere first.
pjac
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mithun Verma | last post by:
Hello All, I have a Windows application that uses Crystal Reports 9 (bundled Version) developed using VS.NET 2003 on a windows server 2003 m/c. The application has to be deployed on the client...
16
by: cody | last post by:
I have to write an algorithm with must ensure that objects are put in buckets (which are always 4 in size). The objects have two properties: A and B. It is not allowed that in a bucket are objects...
15
by: Tamblyne | last post by:
This problem has got to have a simple solution and I can't be the first person who has ever handled it. Perhaps Google is no help because I'm not using the right terms? (I did find one post...
2
by: Robert McGregor | last post by:
Hi all, I've got a Front End / Back End database that was working just fine. One day i opened the FE to find that if I tried to open one of the linked tables from the database window, nothing...
2
by: DataB | last post by:
Hi everyone! I have a forms problem. Bakground: I have created a number of tables. Of these, I have a main parent table (Personal Details) and a number of other child tables (Tax file No.,...
1
by: Terry | last post by:
Hello, Has anyone experienced the following problem following an Upsize from Access 97 to SQL 2000 using the MS Upsize Wizard? Or can anyone see what the problem might be. Before Upsize...
5
by: Jeff | last post by:
IDE: VS 2003 :NET OS: XP Pro My app have a form with a tab-control on it. The tab-control have 2 tabpages. One of the tabpages displays a datagrid, and the other tabpage displays details (order...
0
by: mjsterz | last post by:
I've been working with VB .NET for less than a year and this is the first time I've posted on one of these groups, so let me apologize beforehand if I'm being unclear, not posting my issue...
3
by: shawnews | last post by:
Ok...I'll first describe briefly what I've done. Working from a paper form with over 200 fields - broken into 10 areas, I created a database with 10 tables. I then created a form using those 10...
9
by: HC | last post by:
Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.