Ok Ive got something funky happening and I'm not sure where to look next. I'm using SQL 2000 and use an Access Front end that holds linked tables from different types of databases. I ran an update query on my sql data. SQL updated fine. My data on the screen, however, only effected 1/2 the data- and my linked sql table sitting on the access table is also only updated 1/2 way. What I've done so far. 1. I looked at my application/server page to check my data source- it says GradeSQL 2. I looked at the cfadmin page. Under GradeSQL it points to the actual SQL server. 3. I looked at my access link in link manager- it points to the SQL database. Is there another place I would've set the database that I may have forgotten about. This is very strange- and the weirdest part- I ran the same update on the development server/development sql and it was fine. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
