Did you creat the table in one database and upload it to your SQL using an account? look at the DB owner. example: Create a table in SQL has the name dbo.tablename Create table in local SQL or Access and import/Export it you get username.tablename Rick
-----Original Message----- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wed 5/15/2002 5:12 PM To: CF-Talk Cc: Subject: sql error ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists