Solved

Unique table and deleting a join recordset

Posted on 2002-04-25
4
384 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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 …

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now