Howdy Stephen, Friday, October 4, 2002, 1:29:01 AM, Stephen Kellogg wrote:
SK> I have been trying to upsize an Access 2000 DB to SQL 2000 using the SK> upsizing wizard in Access. Things look like they are proceeding along SK> nicely and then I get an error message for every table in my Access DB. The SK> error says: SK> Server Error 208: Invalid Object Name You've probably already been to MS's support knowledge base, but I ran a search on your error and got the following results (watch the wrap): http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&withinResults=&QuerySource=gsfxAdvancedSearch_Query&Product=sql2k&Queryc=Server+Error+208%3A+Invalid+Object+Name&Query=Server+Error+208%3A+Invalid+Object+Name&KeywordType=ALL&maxResults=150&Titles=false&numDays= Also, when you ran the upsizing wizard, did you select Use DRI or Use Triggers under the Table Relationships section? If you selected Use Triggers, you might want to try running the wizard with Use DRI selected just to see what happens. This would mean having to manually recreate constraints and triggers, but it may be worth a try. Chris Montgomery monty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
