[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • 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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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