Microsoft DAO and OS versions

[datAdrenaline]

Hello Chris

Thanks for the clarification ... eitherway, with the hidden reference, it is completely possible to code in such a way to NOT require an explicit reference to DAO, as you pointed out earlier in the thread. I just used variables declared as objects, where as you did not to use variables at all ... a very clean technique indeed, and one that I use often. And to give credit where credit is due, I beleive your conversations on the 'With CurrentDb ... End With' construct, are what increased my used of such a technique as I found it to be an effective way to code.

Whenever I have removed the explicit reference (albeit rarely have I HAD to do so ...) I like to put in comments what each object variable will become or what each constant represents, thus my example.

But ... in 98.99% of the apps I create, I have both ADO and DAO explicitly referenced ... but the situation posed by the OP seems to definately call for a dropping of the explicit DAO reference.

 

[ChrisO]

After about 9 years of doing this and about 6 years of understanding why it works (thanks to someone on this site called Jon {it was actually in the A2K help file which I never read because I had the A97 help file and who in their right mind would use A2K help if they had A97 help?}) it has become the standard for me.

No more DAO references and in fact, no more references at all.
I become very uneasy if there are more than the two references that must be there and they can’t be deleted.

I suspect, but can’t prove, that the OP’s problem would simply go away if no references were used or declared.

On the other hand, sharing a FE is an accident just waiting to happen with or without references.

 

[datAdrenaline]

Chris ...

>> who in their right mind would use A2K help if they had A97 help? <<

No kidding, definately the most helpful help was the A97 help system, seems to be written by people who wanted to help database developers. I do like the A2003 system as well, but A97's system still edges out the rest ... A2007's is just plain out awful, if you ask me.

>> I suspect, but can’t prove, that the OP’s problem would simply go away if no references were used or declared.

On the other hand, sharing a FE is an accident just waiting to happen with or without references. <<

Definatey agree with both of these statements! ... Especially the second one.

 

[ChrisO]

You’re welcome.