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. www.iea-software.com