Charlotte Foust
cfoust at infostatsystems.com
Tue Jun 19 11:13:22 CDT 2007
Wait, are you using an mde front end? I've had problems changing attached back ends when using an mde front end. It seems to be something like changing references in an mde, not a simple task. If it finds the correctly named file in the right location, it plays nicely. If not, it throws up because it needs to be recompiled with the new attachment location, and you can't do that in an mde AFAIK. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav Sent: Monday, June 18, 2007 2:00 PM To: accessd at databaseadvisors.com Subject: [AccessD] Problem with Intial Reattach Hey Bryan I'd bet a week of Arthur's salary :) that that is the problem. Well Byran checked with the user and the dev machine, both have the most current Windows XP and Jet 4 SP updates. I suggest you donate a week of Athur's salary to the list. Just kidding. Ran my test with 3 different versions of the simple Access97 tester, everything worked fine. Then created 2 simple Access 2003 mde tester versions 1. App already linked to the backend folder, simple main menu and form displaying a list of one the tables in the backend. Worked fine. 2. Attach table form appears and asks the user to indicate the path to the backend. User types in the path and the error message appears "Active X component can't create object". This app does not have any Active X controls. Still looking into a possible subtle SP difference but I think I have hit a "DLL from hell" problem. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com