• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

Unique table and deleting a join recordset

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
nima
Asked:
nima
1 Solution
 
tbsgadiCommented:
Hi Nema
Try
DELETE * FROM Documents
WHERE ((([Documents].AccountID)=99));

99 being the recordid you wish to delete
0
 
nimaAuthor Commented:
Thanks! I know that. It was an example, I've to do it using this properties.Anything else?
0
 
nico5038Commented:

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
 
NetminderCommented:
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now