Very Computer

Hi

I hope this isn't off topic for this group.

I used the Access to SQL Server upsize component to upload the structure of
my tables to a remote SQL Server (on my webhosts machine). I then used the
SQL Server browser to copy and paste data into these tables. This worked
100% OK. However, when opening some fields that were previously memo fields
in Access, my ASP code gives me an error, yet on other pages I get no error.
I don't own SQL Server so all I have is SQL Server browser for Access and
the Visual Basic database connector addon for connection to the SQL server.

Any ideas what went wrong?

     Mads Hilberg
     www.computerprices.co.uk

Mads Hilberg said...

Quote:> Hi

> I hope this isn't off topic for this group.

> I used the Access to SQL Server upsize component to upload the structure of
> my tables to a remote SQL Server (on my webhosts machine). I then used the
> SQL Server browser to copy and paste data into these tables. This worked
> 100% OK. However, when opening some fields that were previously memo fields
> in Access, my ASP code gives me an error, yet on other pages I get no error.
> I don't own SQL Server so all I have is SQL Server browser for Access and
> the Visual Basic database connector addon for connection to the SQL server.

> Any ideas what went wrong?

SQL can be funny with text fields via ADO/ODBC calls.  Make sure that the
text field(s) is the last one in your query and call it last when
fetching the data.  I had the same problem in the past and that was the
solution.