Solved

Unique table and deleting a join recordset

Posted on 2002-04-25
4
398 Views
Last Modified: 2007-12-19
Hi;
In VB6. I've an ADO recordset which its recordsource is like this:
Select *.Document , AccountName.Accounts From Documents Left Join Accounts
On Document.AccountID=Account.AccountID
 How can I delete a record in document without deleting its AccountID in
Accounts?
I heard about Unique Table but I don't know how it works.
My data base is Access, I did something like this:
 ADOdc1.Recordset.Properties("Unique Catalog") = strDBFileName
 ADOdc1.Recordset.Properties("Unique Table") = "Document"
but after deleting a record I get this:"unique table is nonexistent or not
completely specified."
What's wrong here?
Thanks in advance

0
Comment
Question by:nima
4 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 6968238
Hi Nema
Try
DELETE * FROM Documents
WHERE ((([Documents].AccountID)=99));

99 being the recordid you wish to delete
0
 

Author Comment

by:nima
ID: 6969176
Thanks! I know that. It was an example, I've to do it using this properties.Anything else?
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7183037

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 7199454
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question