I have a question. We used to have an Access app set up under Access 2.0 that we use here at work to keep track of our progammers inventory, etc. I just converted this app to Access 2000 recently, and am having issues with the references. There is a reference to an add-in file (utility.MDA) that shows up under Tools|References under the new 2000/VBA. (Under 2.0 I guess AccessBasic took care of everything)
The problem is that the refernce contains the network address for the drive that the mda is on, which is our K: drive. Now, half the workplace is on one server, and the other half on a separate one. Since the reference refers to the server address (ie: SHY294\\K:\blah blah) only one set of people have access to the app. When someone from the other server tries to click on a button in the app, they get booted to VB with a "project or library not found" since VB is looking for the mda on server 294, but they are on server 293(which is a mirror of 294)
I tried to fix this by removing the references under the TOOL menu, and hardcoding the reference on the FormLoad like this:
Private Sub Form_Load()
Dim ref As Reference
Set ref = References.AddFromFile("k:\off2000\pfiles\msoffice\office\1033\utility.mda"
End Sub
which referes to the drive letter directly, which I thought would get me around my problem.
However, now I get a runtime error 32813, "name conflicts with existing module, library, or project". This is because the reference under the TOOL menu is BACK even after I've removed it and put my hard coding in.
Am I missing something? Does anyone have any experience with a similar environment where librarys and object files are on different servers with the same drive letters?
Any help would me appreciated!
The problem is that the refernce contains the network address for the drive that the mda is on, which is our K: drive. Now, half the workplace is on one server, and the other half on a separate one. Since the reference refers to the server address (ie: SHY294\\K:\blah blah) only one set of people have access to the app. When someone from the other server tries to click on a button in the app, they get booted to VB with a "project or library not found" since VB is looking for the mda on server 294, but they are on server 293(which is a mirror of 294)
I tried to fix this by removing the references under the TOOL menu, and hardcoding the reference on the FormLoad like this:
Private Sub Form_Load()
Dim ref As Reference
Set ref = References.AddFromFile("k:\off2000\pfiles\msoffice\office\1033\utility.mda"
End Sub
which referes to the drive letter directly, which I thought would get me around my problem.
However, now I get a runtime error 32813, "name conflicts with existing module, library, or project". This is because the reference under the TOOL menu is BACK even after I've removed it and put my hard coding in.
Am I missing something? Does anyone have any experience with a similar environment where librarys and object files are on different servers with the same drive letters?
Any help would me appreciated!