Detecting Required Fields in Access Databases

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Detecting Required Fields in Access Databases

Logged in as: Guest

arrSession:exec spGetSession 2,2,788

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Detecting Required Fields in Access Databases
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Detecting Required Fields in Access Databases - 2/26/2003 12:48:28 PM

aaronw_1999

Posts: 1
Score: 0
Joined: 2/26/2003
From: USA
Status: offline

I've got a tool i'm building, an HTA, that will open an Access database, list all of the tables and queries in it, and then based on user selection populate a list of fields in the table or query. The purpose is to provide a list of fields for a user to construct a simple SQL statement for use with another class I built for ASP page interaction for dummies (hahahaha).

Anywho, the only thing i'm really having trouble with is detecting if a field is required either some sort of key or any other way. I can get field name, field type, max size, etc, but not whether it is required or not.

I'm using an ADO Connection.

Any help would be appreciated!

Edited by - aaronw_1999 on 02/26/2003 18:56:41