Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2004-08-25 : 17:40:39
|
| I have an Access 97 app. It used to rely on a code module sitting on a network drive. A recent storm crashed the network storage. There is another copy of the code mod. I want to reset the reference. However, I could not get to the Tools, References screen. It was gray out.I went in the code module of some of the forms, as well as in the design mode, but none of them let me to the place I wanted to go.I guess in Access IDE, it does not give you enough control on compilation. It does not have run without compilation.I am stuck. Your help is appreciated. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-25 : 19:29:51
|
| You can't get into the references screen in a compiled .mde file. You'll need to get the source .mdb and re-set the reference in there. |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2004-08-26 : 10:09:50
|
| I suspect the same, but how? They are all .mde files. Which is a source mde vs a compiled one? |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-26 : 10:18:23
|
| MDE files are the compiled ones.MDB files are the source ones |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2004-08-26 : 10:33:35
|
| Problem solved!It cannot be in break mode. I used menu Run, End, then got in a form's design mode, and got into a code module. Then I have another battle I need to fight. At this stage, my menu has changed to a custom one that does not even have Tools in it. I have to unhide the development windows, and then used the context menu, startup..., menu bar, to change it back to default. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-26 : 19:09:16
|
| Access is fun..... |
|
|
|
|
|
|
|
|
hot to reset ref?