Upsized Access DB not playing friendly

HCSG wrote:
> have a small applicaiton that used ms access as a backend and builds
> a simple repeating table. I used the data objects from the gui in
> dreamweaver to build and connect to the db (DW CS3, .asp vb). The
> repeating table has 8 columns and has simple values like Name, dept,
> id, etc....They wanted to upsize the db to SQL. We did the upsize, I
> did a few connection tests with no problems (read and write).
> Established the new dsn. Now, back to my repeating table app. My
> thought was to just change the dw connection file (that currently
> points to Access) and point to the new dsn (SQL). Did this and
> everhitng worked great. No errors. Except the repeating table only
> returns 4 of the 8 fields in the table. Meaning, the table is intact
> but for some reason it will only pull 4 of the 8 bindings from the
> recordset. (????). It doesnt matter which 4 they are, just the first
> 4 from left to righ in the repeating table. Again, no errors to work
> off of. The other cells in the tables are empty.
>
> -I run the select statmenet in query analyzer and everything returns
> perfectly
> - dreamweaver crashes now if I try to work with the application panel
> and the database
>
>
> Anyone experience such a thing?

Have you double checked all your datatypes in the tables in MSSQL?
Upsizing doesn't always get it right.

Dooza