Detect Primary Key in Access

Wrox Programmer Forums

		Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Detect Primary Key in Access

Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

December 11th, 2004, 05:01 PM

TSEROOGY

TSEROOGY is offline

Authorized User

Join Date: Aug 2003

Posts: 54

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Detect Primary Key in Access

Is there a technique/method for determining whether an INSERT INTO entry will cause a Primary Key violation without first looping through the entire table to check for possible duplicates?

Read a post on doing this with msSQL, but not sure how or if it applies to an ACCESS 2000 database.

Best regards,
TSeroogy

Old

December 13th, 2004, 09:12 AM

stu9820

stu9820 is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,110

Thanks: 0

Thanked 3 Times in 3 Posts

Default

Is the primary key set to Autonumber?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Foreign key not updating with Primary key	xavier1945	BOOK: Access 2003 VBA Programmer's Reference	2	July 4th, 2007 09:48 PM
Checking for duplicate primary key in Access	Indo77	ASP.NET 2.0 Basics	2	November 29th, 2006 12:19 PM
FOREIGN KEY and PRIMARY KEY Constraints	junemo	Oracle	10	June 15th, 2004 01:00 AM
Get primary Key Columns From Access Table	MeSaqi	Access VBA	0	July 18th, 2003 08:20 AM