![]() |
3 Table MS Access Relational Database. P |
Post Reply ![]() |
Author | |
jetski4419 ![]() Newbie ![]() Joined: 13 June 2005 Location: United Kingdom Status: Offline Points: 2 |
![]() ![]() ![]() ![]() ![]() Posted: 13 June 2005 at 3:53pm |
I have designed a MS Access Database with three tables: CUSTOMERS, BOOKINGS & HOLIDAYS. On coming to the BOOKINGS table (which appears to be an INNER JOIN) I've got the SELECT and DELETE records to work, but I'm having major problems getting the INSERT and UPDATE to work. View the SQL Statements below: I have now generated a SELECT query by going through the OleDbAdapter process and the Following query was produced and works fine:
Regards jetski4419 2005-06-13_155155_vb.NET_DB_Quest.zip
|
|
jetski4419
|
|
![]() |
|
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
Hi,
With your UPDATE query -- set square brackets around each field name, especially around [Date] field, which is also seems to be the reserved word. -- WBR, Serge |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |