MS Project 8.0 Object Library Error

[KyleS]

Hi,
I'm at the end of my wits here...

I've got a database that connects to Project '98 and exchanges information, etc. So obviously I have the MS Project 8.0 Object Library selecetd under 'References'. Everything works fine, but for some reason, if a user does not have Project loaded on their PC they get an error when they encounter the Environ() function (Audit Trail).

I know this is the the VBA library that is at the TOP of the priority list, and Project is at the bottom, so unless I'm not understanding something here, as soon as Access finds the Function it should stop checking references. So how is it that Project is screwing this up?

If you need more info, I'll be glad to supply,

Thanks, Kyle :

 

[KyleS]

Hello again,
This has happened on 2 different machines in the last 2 days. I'm frustrated because only the Environ() function causes this issue, and I need the Project reference in order to use the DB properly.

Thanks again for any help... Kyle :

 

[KyleS]

Anyone...? Kyle :

 

[Guest_imported]

I don't fully understand what you mean.. I'm using Access, Project, Excel and Word in one application and I know that you need to install an application locally just to be able to use a library reference.

So if u need install it and if you don't then remove the reference..

Otherwise there is no way out I believe... please correct me if I'm wrong or in case I don't understand you correctly!

BTW i'm Dutch...
Let me know,

Cereal

 

[KyleS]

Cereal,

I know how all the references work, I was (and still am) confused and frustrated in that I need the Project references for the dB and 90% of our users have Project, so for them it works great. But for the 10% that don't have project the dB essentially won't work, it looks inthe Project reference for the function I'm using even though it exists in the VBA Library which is at the top of the priority list. We've solved this problem by givin Project to the other 10% of the people - Which I'm sure M$ loved since we had to buy a few more licenses. But that's not a god solution, that's a Micro$oft solution. Kyle