Jet 4.0 not appearing in references

[Portland Pete]

I just installed Office 2K3 Pro (except for Outlook, Publisher, and
PowerPoint) on the same computer with Office 2K. With macro security
set to Medium, I get the infamous "unsafe expressions are not
blocked..." dialogs; but when I tried to make sense out of what I'm
learning about sandbox mode, etc., I discovered that my VBA References
do not include Jet 4.0--only 3.6. I registered msjet40.dll
successfully, but it still doesn't show up in the references list.
When I try to add it manually using the add reference dialog, it just
tells me "cannot add reference". So how do I turn on Sandbox (if I
even want to) if I can't refer to Jet 4?
Portland Pete

[Portland Pete]

Sorry about the multiple posts..I wasn't getting confirmation that the
message had posted. :-(

[Portland Pete]

Sorry about the multiple posts..I wasn't getting confirmation that the
message had posted. :-(

[Wayne Morgan]

There is no "Jet" reference that shows in the References dialog, never has
been as best as I can remember. For the DAO reference, 3.6 is the correct
one. Make sure you've installed SP8 for Jet 4. If you've install SP2 for
WinXP, you have it already.

As far as sandbox goes, see if this link will help.

http://support.microsoft.com/default...b;en-us;294698

--
Wayne Morgan
MS Access MVP
"Portland Pete" <pr*****@pacifier.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

I just installed Office 2K3 Pro (except for Outlook, Publisher, and
PowerPoint) on the same computer with Office 2K. With macro security
set to Medium, I get the infamous "unsafe expressions are not
blocked..." dialogs; but when I tried to make sense out of what I'm
learning about sandbox mode, etc., I discovered that my VBA References
do not include Jet 4.0--only 3.6. I registered msjet40.dll
successfully, but it still doesn't show up in the references list.
When I try to add it manually using the add reference dialog, it just
tells me "cannot add reference". So how do I turn on Sandbox (if I
even want to) if I can't refer to Jet 4?
Portland Pete

[Peter L Reader]

On Sat, 21 May 2005 18:20:32 GMT, "Wayne Morgan"
<co***************************@hotmail.com> wrote:

There is no "Jet" reference that shows in the References dialog, never has
been as best as I can remember. For the DAO reference, 3.6 is the correct
one. Make sure you've installed SP8 for Jet 4. If you've install SP2 for
WinXP, you have it already.

As far as sandbox goes, see if this link will help.

http://support.microsoft.com/default...b;en-us;294698

Thanks! That clears that up.
OK -- so the question I have is, why does Access 2K3 keep telling me
that I need to download Jet 4 SP 8, when I already have the most
recent version (4.0.8618.0)? That's what confused me about the
references. Also, when I clicked on the link in the warning messages,
I learned that the version on the website was older than the one I
currently have installed! So far, the only way I've figured out to
avoid those "unsafe" messages is to set macro security to Low, which
probably is not a good idea...

Now to research about "sandboxes"....
Peter L. Reader, posting from sunny Portland, Oregon
pr*****@pacifier.com
---------------

[Wayne Morgan]

Actually, you've found the method I believe most of us are using (setting it
to Low). Placing the setting at Low is the same as where it has been prior
to Access 2003.

There have been a few reports of Access not recognizing SP 8 properly if
WinXP SP2 was installed first. The only answer I heard was to uninstall the
WinXP SP, install the Jet SP, then reinstall the WinXP SP. It's probably not
worth the trouble.

Also, one of the possible messages that pops up can be very misleading
unless you read it carefully. Initially, it sounds as if you need SP8, but
it is actually saying something slightly different. I don't remember the
exact wording.

--
Wayne Morgan
MS Access MVP
"Peter L Reader" <pr*****@pacifier.com> wrote in message
news:n8********************************@4ax.com...

Thanks! That clears that up.
OK -- so the question I have is, why does Access 2K3 keep telling me
that I need to download Jet 4 SP 8, when I already have the most
recent version (4.0.8618.0)? That's what confused me about the
references. Also, when I clicked on the link in the warning messages,
I learned that the version on the website was older than the one I
currently have installed! So far, the only way I've figured out to
avoid those "unsafe" messages is to set macro security to Low, which
probably is not a good idea...

Now to research about "sandboxes"....
Peter L. Reader, posting from sunny Portland, Oregon
pr*****@pacifier.com
---------------