[thelist] MS Access and SQL (from ColdFusion)

[jon steele]

Hi,

I'm using ColdFusion to create a table, and I need to know how to work
with all those extra options in Access...like default value, required,
Autonumber, etc. Does anyone have a good link explaining these (besides
the MS help file...they don't explain a thing).

Also, you know how in Access you can use VB commands in the fields you
create in Design View, I need to create a date field, with Now() as the
default value, from ColdFusion. How can I set that default value?

Thanks in advance,
Jon.

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/