Re: [RadiusNT] Microsoft Upsizing tool

Dale E. Reed Jr. ( (no email) )
Thu, 29 Apr 1999 14:13:04 -0700

Jean-Francois Laplante wrote:
> I'm in the process of converting my Access database to SQL. During the dry
> runs to upsize the database, I always end up with a timeout error saying:
> "Server Error 0: Timeout Expired" when upsizing the same table. This
> particular table is rather large and has about 40,000 records. The call
> table is almost empty to facilitate the process. The table in question is
> a transaction table.
> Since Access and the SQL server were on the same machine I tought that
> maybe Access was feeding the data too fast to the SQL server wich is a
> contradiction in terms... A subsequent attemps to do the same from 2
> different machine gave the same results,

Make a copy of the Access database and delete EVERYTHING out of
the copy except the tables. Do a compact and then re-run the Upsize tool
on the compacted copy. I've found that unless the Access database is
fairly clean, the upsize tool always has problems.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.