Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CGI & Access2002 - 1

Status
Not open for further replies.
schase

schase

Technical User
Sep 7, 2001
1,756
US
A buddy of mine is programming with CGI.

He has an unusual situation where a form through cgi will add records to the database if the ID is not a primary key, but will not write to the database if it is a primary key.

There are no relationships, only one table, no joins, it is autonumber, no reserved fields (at least up to Access2000)

Anybody have any ideas? "Insert witty remark here"

Stuart
 
Sort by date Sort by votes
Um, if there's only one table, it makes perfect sense.
Primary and secondary keys are for linking between tables and indentifying records.

If you have one table, then all you have is a key.
The code looked for the key, didn't find it, so it adds the record.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Triacona
  • Locked
  • Question
like "*"&[Forms]![MainScreen].[cmbSound]&"*" not wor 1
Replies
6
Views
134
Triacona
Triacona
Lexxxa
  • Locked
  • Question
How can I copy an Access table with its column props & constraints?
Replies
4
Views
127
Lexxxa
Lexxxa
stevefutcher
  • Locked
  • Question
Multiple Parent & Child Record Problem
Replies
2
Views
100
stevefutcher
stevefutcher
monkeysee
  • Locked
  • Question
Generate List with MaxofDate & LastofColiSample with more criteria 1
Replies
4
Views
69
monkeysee
monkeysee
1DMF
  • Locked
  • Question
Understanding Union with Join & sub queries
Replies
8
Views
146
1DMF
1DMF

Part and Inventory Search

Sponsor

Back
Top