473,809 Members | 2,610 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to establish relationsips(on e-many) by using adox

Hello Sir,
i have done the funtionality to create a JET Database by Using ADOX. now my
problem is to establish relationship between the tables. i have one master
table and 3 child tables basing on the contact_id field in the master table
as a primary key and in child tables as foreign key and cascading to delete
property. how to maintain relationships with in the database at the creation
of the JET Database file only.

Thanks for your help
Gaffar.

Nov 21 '05 #1
2 1116
Gaffar,

The most change on your question I give you in the newsgroups

Microsoft.publi c.data.* where one of those is
Microsoft.publi c.data.ado

That are not that active newsgroups anymore as the dotnet newsgroups,
however you want to do it only with ADO(X).

I hope you find your answers soon

Cor
Nov 21 '05 #2
Gaffar,

I answered this question for you several days ago.

Is there some reason that the following article does not answer ALL of your
many questions about using ADOX with Access?

http://www.vbcity.com/forums/topic.asp?tid=41536

Kerry Moorman
"gaffar" wrote:
Hello Sir,
i have done the funtionality to create a JET Database by Using ADOX. now my
problem is to establish relationship between the tables. i have one master
table and 3 child tables basing on the contact_id field in the master table
as a primary key and in child tables as foreign key and cascading to delete
property. how to maintain relationships with in the database at the creation
of the JET Database file only.

Thanks for your help
Gaffar.

Nov 21 '05 #3

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

Similar topics

2
5794
by: desc | last post by:
I am trying to create an access db using ADOX in C# and I am finding difficulties to find documentation on this in msdn library. Does anyone have any documentation or samples of creating an access db programatically in c#? THANKS.
2
8659
by: Tim Frawley | last post by:
I am attempting to change the ODBC Link Provider String in an Access database linked to an Oracle server using ADOX in VB.NET. I created some code using the example from post: http://groups.google.com/groups?q=RefreshLinkedTablesWithADOX()&hl=en&lr=&selm=qb1ctvcdoftenojhpp34lb6fjb9ss8qd9c%404ax.com&rnum=1 My code simply replaces the DSN, UID, PWD and DBQ values in the ADOXTable.Properties("Jet OLEDB:Link Provider String").Value string...
3
1714
by: gaffar | last post by:
Sir, Using ADOX I am developing an application in vb.net and the backend database is ms-access. i have created ms-access databse and tables and assigned primary keys to the tables through the vb.net application(code is below) by using ADOX. Now my problem is i want delete one record from master table, that deleted record automatically deleted from child tables. so, i want the code how to establish relation ships between the tables and...
2
3072
by: gaffar | last post by:
Hello Sir, i need the funtionality of Using ADOX to create a JET Database and tables in it and one to many relationship between the tables. Thanks for your help Gaffar.
1
1551
by: Gaffar | last post by:
Hello Sir, i have created ms access database file by using ADOX. in which i have created 4 tables. 1 master table and 3 child tables. in the master table i have assigned primary key and in the child tables i have assigned foreign key. now my problem is deleting a record in the master table can not be deleted if there exists a record in the child tables. so, to solve this problem i have to give the property update and delete cascade rule...
2
5526
by: genojoe | last post by:
Using ADOX to update a Property does not work. I want to change the Access database for a linked table. My abridged code is: Dim oCAT As ADOX.Catalog oCAT = New ADOX.Catalog oCAT.ActiveConnection = goConnection Dim t As ADOX.Table Dim p As ADOX.Property
4
10748
by: Frank Rizzo | last post by:
I am using ADOX to make changes to an Access database that would be difficult to do via the System.Data.OLEDBClient. So far I have no trouble actually doing the work, however, I have trouble closing the connection to the Access database. //open connection ADOX.CatalogClass connection = new ADOX.CatalogClass(); connection.let_ActiveConnection(this.ConnectionString); //do the work
0
1189
by: swatijogdand | last post by:
Hi..... Again, it's really very urgent. does nebody have the code for connecting a SQL Server table to an access database using ADOX ??? Thanx in adavance, Regards, Swati
0
1157
by: Andyxis | last post by:
Hello experts, I am making a vb6 program that needs to create a Foxpro 2.5 table using ADOX. I know this is quite old. You see, our company's still using these tables. And we need to make a program from vb6 that can create a dbase III table w/ it's structure copied from an existing dbase table. Now, I had codes that does create the table w/o errors. My problem is with the numeric fields(adinteger, adnumeric, addecimal, etc.). I can't set the...
0
9721
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9603
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10640
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10387
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
6881
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5689
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4332
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.