>Thanks for the information Eric. Just one last question. I've been looking at the ADOX MSDN page and I can't find the column property that shows whether the field is required or not. Do you know how to get that?
Can you use
Jet OLEDB:Allow Zero Length?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com