Thanks for the code snippet oh1mie

I'm having trouble with this:

tbl.Columns(Name).Properties("Nullable") = True

I'm getting this error.

-2147217887 Multiple-step OLE DB Operation generated errors. Check each OLE DB status value, if available. No work was done.

Here's my connection string, as you can see it's access 2000.
Also, (this is just a side issue for me) do you know if there's a SEEK function anywhere out there for SQL Server/Oracle?

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=D:\idt_fa\fa-temp2\37309000.MDB;Mode=ReadWrite;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False