I have created a script thru SQL Server 2000 into a vb.bas file to execute a DTS transfer into an access database. Everytime I run the code the size of the access database is different. After checking out the tables in a very random fashion the Access database tables are missing record that the SQL Server Database has. There are about 70 tables in the SQL database and in access the tables missing records changes randomly. Any help would be appriciated.

Does anything show up in the import errors tables in Access? are you
importing into existing tables or into empty work tables? If the
former, consider the latter. Also, be aware that some versions of
Access/Jet don't support exactly the same ranges of data and data
types, so if a record is out of bounds, it may not show up. Although
mostly that happens going the other way with date/time bc Jet supports
a wider range of dt values.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Fri, 13 Feb 2004 13:36:08 -0800, Brian Brooks
<brian5973 (AT) hotmail (DOT) com> wrote: