|
 |
access thread: Importing textfiles into access 2000
Message #1 by "Ply" <mail_ply@y...> on Wed, 23 Oct 2002 01:15:00
|
|
During imports of textfiles into access, access automatically creates an error table when any conversion
problems occur. This is fine, but this increases the databse by a few Mbytes each time this occurs. How can i
get back to the original size? I've already tried deleting the error table.
Message #2 by "Enzo Zaragoza" <enzaux@g...> on Wed, 23 Oct 2002 10:38:00 +0800
|
|
Tools > Compact&Repair
Enzo
-----Original Message-----
From: Ply [mailto:mail_ply@y...]
Sent: Wednesday, October 23, 2002 1:15 AM
To: Access
Subject: [access] Importing textfiles into access 2000
During imports of textfiles into access, access automatically creates an error table when any conversion
problems occur. This is fine, but this increases the databse by a few Mbytes each time this occurs. How can i
get back to the original size? I've already tried deleting the error table.
Message #3 by "Wesley Kendrick" <wez.k@n...> on Wed, 23 Oct 2002 08:40:16 +0100
|
|
You can also set Access to Compact and Repair automatically
Tools/Options/General/Compact on Close
Regards, Wesley Kendrick
----- Original Message -----
From: "Ply" <mail_ply@y...>
To: "Access" <access@p...>
Sent: Wednesday, October 23, 2002 1:15 AM
Subject: [access] Importing textfiles into access 2000
> During imports of textfiles into access, access automatically creates an
error table when any conversion
> problems occur. This is fine, but this increases the databse by a few
Mbytes each time this occurs. How can i
> get back to the original size? I've already tried deleting the error
table.
>
|
|
|
View Cart
