I have been trying to upsize an Access 2000 DB to SQL 2000 using the upsizing wizard in Access. Things look like they are proceeding along nicely and then I get an error message for every table in my Access DB. The error says: Server Error 208: Invalid Object Name and then it has the name of one of my tables and it does this for every table. All of my tables start with tbl and then the name of the table like tblNameOfTable. It appears to be bombing when writing the Triggers to support the Cascade updates and deletes. The end result is a new db in SQL server with none of my tables in it.
Any help is appreciated! Thanks Stephen Stephen Kellogg CC Intelligent Solutions, Inc. 3301 Woman's Club Drive, Suite 150 Raleigh, North Carolina 27612 (336) 260-7308 Cell (best number to use) (919) 785-9655 Office (919) 785-0360 Fax email: mailto:[EMAIL PROTECTED] www.CCIntelligentSolutions.com ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
