database relations

gaffar

Sir,

I have created ms access database and tables with in that database at
runtime using vb.net code.
now i would like to establish relationship between the tables.
how to do this, please help me.

Thanks for your help.

Jul 21 '05 #1

Subscribe Post Reply

975

Cor Ligthert

Gaffar,

Has it any sense to give you an answer, I have given an answer yesterday to
you where you asked the same question in a message with the subject
Establishing relationships

I see not any reply there.

Cor

Jul 21 '05 #2

Nick Malik [Microsoft]

I answered on your other thread.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"gaffar" <sa********@yahoo.co.in> wrote in message
news:e$**************@TK2MSFTNGP12.phx.gbl...

Sir,

I have created ms access database and tables with in that database at
runtime using vb.net code.
now i would like to establish relationship between the tables.
how to do this, please help me.

Thanks for your help.

Jul 21 '05 #3

Nick Malik [Microsoft]

Sir,

I have created ms access database and tables with in that database at
runtime using vb.net code.
now i would like to establish relationship between the tables.
how to do this, please help me.

Thanks for your help.

Nov 22 '05 #4

by: Bose | last post by:

Hi I have to make export of SQL Server Database to MS Access and I have done it with the tables but now I need to transfer(export) the relations, keys and indexes. Can any1 tell me how to read...

Microsoft SQL Server

How to fill a dataset with an unknown database...

by: Walter | last post by:

Hello, I want to fill a dataset with a random database (mdb-database or SQL-server database), from which a don't know the tables, relations or anything. So after this, the dataset will be 1:1...

.NET Framework

Visual database structure browser for postgresql?

by: Bart | last post by:

Hello I am looking for something like visual database structure browser. I need to see all tables and relations beetween them. Something like "Relations" window in Microsoft database products...

PostgreSQL Database

Can I use PostgreSQL to develop a self-organizing database system?

by: Rada Chirkova | last post by:

Hi, at NC State University, my students and I are working on a project called "self-organizing databases," please see description below. I would like to use an open-source database system for...

PostgreSQL Database

Relations not visible

by: Jef De Rycke | last post by:

Hi access group, I have written code to create relations between tables according to a corresponding relations information table. At first I thought my code was not working properly because...

Microsoft Access / VBA

database not updating

by: Nir Amber via DotNetMonster.com | last post by:

I cant seem to get the databse to update the tables. i get the following error "System.InvalidOperationException: Missing the DataColumn 'description' in the DataTable 'Transactions' for the...

ASP.NET

Help constructing a database-type view from a DataSet object

by: Gary | last post by:

I have a DataSet where two tables have a relation (the parent / child relationship is also successfully added to the DataSet Relations collection). I am looking for a way to programmatically...

Visual Basic .NET

Dataset relations, MSAccess database

by: peter mpa | last post by:

Greetings. I am building a c# windows forms app to show tables from a ms access database. I am using OleDbConnection with Microsoft.Jet.OLEDB.4.0 , 5 datagrids and some data relations to show on...

C# / C Sharp

Where do I put my Database relations... at DATABASE level or in PROGRAM LEVEL?

by: mesut | last post by:

Mybe it's a stupid question but : I'm starting to learn VB.NET. I have some basic skills. I'm from Mainframe world and I have same question to make my DATABASES (tables and relation) I would like...

ASP.NET

family database

by: Cliff Chapin | last post by:

I want to create a Family database some of these "families " are single fathers with children some are single women with children they will be assigned Rooms /w children. what would be the best to...

Microsoft Access / VBA

How to Become a Cyber Security Engineer

by: Rina0 | last post by:

Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...

Security

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to Use CodiumAI's pr-agent?

by: erikbower65 | last post by:

Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...

General

Speedup your spring application

by: linyimin | last post by:

Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...

General

How to insert a new record in a database

by: Taofi | last post by:

I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...

DB2 Database

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How to calculate date of retirement from date of birth

by: Mushico | last post by:

How to calculate date of retirement from date of birth

Data Management

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Similar topics