Problem with ado datatype adVarWChar 
Author Message
 Problem with ado datatype adVarWChar

I have created an access 4.0 database using ado and created a table in
it. The fields in the table are created as adVarWchar data types with
max size of 255.  I then link an access 97 database table into the
access 2000 database and then run an execute statement to copy data for
the old table into the new. The field names in the tables are identical
and the new table does not have any indexes defined.

the statement is like this
"Insert into NewTable Select Name, Address From OldTable"

Well, this works but is not fast and when its finished the database has
become massive compared to the original, I'm talking 50meg becomes
400meg.    Doing a reorganise / rebuild in access 2000 brings the size
back to 50meg. Its like the Var part of the datatype is ignored.

I also have a larger 97 database and doing the same causes a crash when
the new access 2000 database reaches 2.3 gig.

Anyone else seen this, knows why it does it / knows how to fix this?
Any input would be appreciated.


Sent via http://www.*-*-*.com/
Share what you know. Learn what you don't.

Fri, 01 Mar 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. ADO DataType Enum Mapping To SQL DataTypes

2. SELECT DISTINCT problem (adVarWChar VS. adLongVarChar)

3. Problem using Oracle NUMBER datatype in ADO

4. Problem mapping a VB data type to an ADO datatype (and then SQL 2000)

5. Problem using Oracle NUMBER datatype in ADO

6. Problem mapping a VB data type to an ADO datatype (and then SQL 2000)

7. ADO 2.5: Error -2147217887(80040e21) Problem with Datatype adDouble

8. Converting datatype varchar to datatype datetime in SQL trigger

9. ADO datatypes from Excel

10. ADO recordset and the variant datatype in VB

11. ADO -> OUTPUT PARAMETER and Text datatype

12. SQL7 Text Datatype and ADO.


Powered by phpBB® Forum Software