Problems in downloading data from Sql-Server to Ms-Access

[Guest_imported]

Hello Sir,

I have a problem in down loading the data from MS-Sql Server to MS-Access.

I have a database in Web Server with three tables. I have the same copy of database(maintained in MS-Access) in my local system. One of the fileds in my table in Sql-Server is of type " text " of 16 bits. I placed a relevant field of type
" memo " in MS-Access. I am using MS-Access 97 as the local database.

I created an interface in VB 6.0 through which i am downloading the data from Sql-Server to MS-Access.

I am able to open the record sets of all the three tables. But while transferring the data to local database(Ms-Access) at the above field i am getting problem.

i am getting an error here.

can any one give me the solution for this. i need to have
" text " data type in Sql-Server because that field should contain a huge number of characters. I need to have MS-Access only as the local database.


I request ur help

 

[Cagliostro]

use SQLServer export wizard. John Fill

ivfmd@mail.md