Hello i serach for an sql command which creates a 1:1 relation in an access database. I think i can do this wiht CONSTRAINT but how? In the access help i found this: CREATE TABLE Bestell (BestellId INTEGER PRIMARY KEY, KundId INTEGER, BestellNotiz NCHAR VARYING (255), CONSTRAINT FKBestellKundId FOREIGN KEY (KundId) REFERENCES Kunden ON UPDATE CASCADE ON DELETE CASCADE but this creates only 1:N relation!

Hi My Program use the CADOX Classes from Carlos Antollini to connect itself to a access database via ADO. Is there any way to start the Access file import wizard over ADO to import new tables from csv files to my database? Please help!

Hi i mean this: round(y,x) y = value to round for example 4,6793233 x = position after ',' to round round should look after y at position x+1 if y at positon x is > 5 then 4,68 forget the rest of numbers!

Hi i search for a function which can do this: double value = 4,6793 value = round(value,2) //after that value should be 4,68 in which library can i find this function???

Hi how can I get a list of tables from a database by using the CADO Classes from Carlos Antollin?http://www.codeproject.com/database/caaadoclass1.asp) Greetings Thomas

Hi, how can i get a list of tables with columns from a access database by using cdatabase and crecordset? I want to use the list in a CTreeCtrl!

Hi, how can i get a list of tables with columns from a access database by using cdatabase and crecordset? I want to use the list in a CTreeCtrl!