Showing Field Properties of a Database

[Gram]

Hello,

Can anyone help with the following:

I wrote an ASP script with allows me to select an MS Access database
from a folder, and it shows the tables in this database. If I click a
table, the fields are displayed. And then I have a button to create a
HTML form to suit this table.

My problem is, fields that are essential. I would like to mark
appropriate form fields as 'essential' . Is there any way I can get the
attributes of a field, so I know if it will accept null values?

Any help or advice is greatly appreciated.

Gram.

[Bob Barrows [MVP]]

Gram wrote:

Hello,

Can anyone help with the following:

I wrote an ASP script with allows me to select an MS Access database
from a folder, and it shows the tables in this database. If I click a
table, the fields are displayed. And then I have a button to create a
HTML form to suit this table.

My problem is, fields that are essential. I would like to mark
appropriate form fields as 'essential' . Is there any way I can get
the attributes of a field, so I know if it will accept null values?

Any help or advice is greatly appreciated.

Gram.

http://www.aspfaq.com/show.asp?id=2177
http://www.aspfaq.com/show.asp?id=2244

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Gram]

Hi Bob,

Thanks for your help with this, however;

What im looking for is some way for the code to tell me if a field in a
database is essential to fill in, ie, that it won't accept a null value

Sorry if Im explaining this badly.

Gram

Bob Barrows [MVP] wrote:

Gram wrote:

Hello,

Can anyone help with the following:

I wrote an ASP script with allows me to select an MS Access database
from a folder, and it shows the tables in this database. If I click a
table, the fields are displayed. And then I have a button to create a
HTML form to suit this table.

My problem is, fields that are essential. I would like to mark
appropriate form fields as 'essential' . Is there any way I can get
the attributes of a field, so I know if it will accept null values?

Any help or advice is greatly appreciated.

Gram.

http://www.aspfaq.com/show.asp?id=2177
http://www.aspfaq.com/show.asp?id=2244

Bob Barrows

[Bob Barrows [MVP]]

I'm pretty sure one of the articles I cited explained about using ADOX to do
this. If not, go to msdn.microsoft.com/library and look up the ADOX
documentation which will explain how to get the custom (Access-defined)
column properties. Here's a direct link to the documentation:
http://msdn.microsoft.com/library/en...ireference.asp

You will probably find the Programmer's Guide more helpful:
http://msdn.microsoft.com/library/en...dloverview.asp
Bob Barrows
Gram wrote:

Hi Bob,

Thanks for your help with this, however;

What im looking for is some way for the code to tell me if a field in
a database is essential to fill in, ie, that it won't accept a null
value

Sorry if Im explaining this badly.

Gram

Bob Barrows [MVP] wrote:

Gram wrote:

Hello,

Can anyone help with the following:

I wrote an ASP script with allows me to select an MS Access database
from a folder, and it shows the tables in this database. If I click
a table, the fields are displayed. And then I have a button to
create a HTML form to suit this table.

My problem is, fields that are essential. I would like to mark
appropriate form fields as 'essential' . Is there any way I can get
the attributes of a field, so I know if it will accept null values?

Any help or advice is greatly appreciated.

Gram.

http://www.aspfaq.com/show.asp?id=2177
http://www.aspfaq.com/show.asp?id=2244

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Gram]

Hi Bob,

Thanks for your help, I'll tear into em and see what I can do.

Thanks again.

Gram.

Bob Barrows [MVP] wrote:

I'm pretty sure one of the articles I cited explained about using ADOX to do
this. If not, go to msdn.microsoft.com/library and look up the ADOX
documentation which will explain how to get the custom (Access-defined)
column properties. Here's a direct link to the documentation:
http://msdn.microsoft.com/library/en...ireference.asp

You will probably find the Programmer's Guide more helpful:
http://msdn.microsoft.com/library/en...dloverview.asp
Bob Barrows
Gram wrote:

Hi Bob,

Thanks for your help with this, however;

What im looking for is some way for the code to tell me if a field in
a database is essential to fill in, ie, that it won't accept a null
value

Sorry if Im explaining this badly.

Gram

Bob Barrows [MVP] wrote:

Gram wrote:
Hello,

Can anyone help with the following:

I wrote an ASP script with allows me to select an MS Access database
from a folder, and it shows the tables in this database. If I click
a table, the fields are displayed. And then I have a button to
create a HTML form to suit this table.

My problem is, fields that are essential. I would like to mark
appropriate form fields as 'essential' . Is there any way I can get
the attributes of a field, so I know if it will accept null values?

Any help or advice is greatly appreciated.

Gram.
http://www.aspfaq.com/show.asp?id=2177
http://www.aspfaq.com/show.asp?id=2244

Bob Barrows