Hope you can help a beginner - I have had problems with the DB and therefore had left it alone for a while. I have returned (having used a system restore) and cannot open any of the files through Access (okay through explorer). The message is "failure creating file". Each time the DB is opened a run time error of "connection of object failed" comes up. Any ideas ?
Revisiting Access
- Thread starter BF1
- Start date
mdemarte
Computer Wizard
- Local time
- Today, 16:11
- Joined
- May 8, 2001
- Messages
- 138
Can you open the sample DB's, like Northwind? If so, then perhaps you should check your version -- Help, About Microsoft Access. See if it is the same version of Access as what you started developing in. If not, then a reload of at least Access, possibly all of Microsoft Office is your next bet. One other thought, did you restore from CD? Your files could be Read Only. Within My Computer, Explore do a right-click on the file and look at its Properties. If Read Only is checked, uncheck it and try again.
HTH
HTH
- Local time
- Today, 10:11
- Joined
- Feb 28, 2001
- Messages
- 30,560
Please read the two items below very carefully to see if they really apply:
1. You can open the database by double-clicking on it when exploring the disk. It appears to open normally.
2. You cannot open the database by running Access, going to the list of databases in the "Open Database" dialog box, and selecting one of the listed entries. You get your connection error.
If the above list is correct, your problem is that when you removed the databases and restored them, you didn't restore them to the same place you had originally built them. Access stores the locations of its "most recently opened" list in the registry including full path names. In the "Open Database" dialog box, Access reads the list from the registry but DOES NOT VERIFY ITS VALIDITY. So if you follow the pointer and the database ain't where it used to be, you get an error.
1. You can open the database by double-clicking on it when exploring the disk. It appears to open normally.
2. You cannot open the database by running Access, going to the list of databases in the "Open Database" dialog box, and selecting one of the listed entries. You get your connection error.
If the above list is correct, your problem is that when you removed the databases and restored them, you didn't restore them to the same place you had originally built them. Access stores the locations of its "most recently opened" list in the registry including full path names. In the "Open Database" dialog box, Access reads the list from the registry but DOES NOT VERIFY ITS VALIDITY. So if you follow the pointer and the database ain't where it used to be, you get an error.
mdemarte
Computer Wizard
- Local time
- Today, 16:11
- Joined
- May 8, 2001
- Messages
- 138
If I understand you correctly, you can get into the database, because the Switchboard opens. Then, when you click on the selections on the Switchboard, nothing opens. Sounds like you need to see to where your Switchboard is pointing.
1. Push PF11. Close the Switchboard form. This should put you into design mode.
2. The forms should be under the Forms heading, if you want to look at them. To edit the Switchboard, then from the Menu Bar at the top, select Tools, Database Utilities, Switchboard Manager. Edit the Switchboard and any Selections on the Switchboard that are necessary.
HTH
1. Push PF11. Close the Switchboard form. This should put you into design mode.
2. The forms should be under the Forms heading, if you want to look at them. To edit the Switchboard, then from the Menu Bar at the top, select Tools, Database Utilities, Switchboard Manager. Edit the Switchboard and any Selections on the Switchboard that are necessary.
HTH
Similar threads
- Deleted Bruce 182381
- General
