Command problem with Access XP on a machine with Office 2007

[David Teich]

My oldest computer finally died. On it, I'd used Office XP, while I have
2007 on the new computer. All I need from the old one is Access XP, and I
only have Office 2007 Standard, so i installed Access only from the CD. After
it installed, Word, pp and Excel all started w/o problems. Outlook had an
error, so I ran repair and it seems fine.

The only problem is w/Access XP. It starts fine and I can see the tables,
forms, etc. The problem is that VB doesn't seem to be working properly, I got
an error when OnCurrent" ran that DoCmd.GoToControl "Title" wasn't good
because ""The expression On Current you entered as the event property setting
produced the following error: Object or Class does not support the set of
event"

This is a command that has run for years, even before XP. It's not the
command . In fact, I commented it and the next command gave me the same error.

What conflicts do you see between VB XP and an install of 2007 that doesn't
include Access?

 

[David Teich]

It is already set to 2.

Check your sandbox mode. It should be set on 2 to allow Access VBA code to
work with unsafe expressions. Check this registry key:

\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engines\SandboxMode

Chris
Microsoft MVP

 

[David Teich]

That one lost me. I've never customized any libraries. All I did was, years
ago, go to code builder and do very simple commands. There's nothing fancy,
they're just very simple data entry forms.

Do you have a reference to any sources that tell me what libraries should be
linked and where I check their status? Hopefully ones that will describe what
the DAO and ADO libraries are...

thanx,
David

Check your library references. Are any of them missing? Reset them if
they're missing.

Is your code not disambiguated, so that it depends on the libraries being in
a certain order of precedence? A common problem is to use objects that occur
in both the DAO and ADO libraries, forget to disambiguate the code, and just
move one library above the other in the references for a quick fix. That
isn't a permanent fix.

Chris
Microsoft MVP

It is already set to 2.

Check your sandbox mode. It should be set on 2 to allow Access VBA code to
work with unsafe expressions. Check this registry key:

[quoted text clipped - 22 lines]

What conflicts do you see between VB XP and an install of 2007 that doesn't
include Access?

 

[Rick Brandt]

That one lost me. I've never customized any libraries. All I did was,
years ago, go to code builder and do very simple commands. There's
nothing fancy, they're just very simple data entry forms.

Do you have a reference to any sources that tell me what libraries
should be linked and where I check their status? Hopefully ones that
will describe what the DAO and ADO libraries are...

The standard thing to do is open Access and create a new blank file and then
look at its references. Those will be the defaults with which I have never
encountered any problems (either machine to machine or version to version).
Some have reported issues with different versions or patch levels in these,
but I have personally never encountered that.

Compare that list with the references in the file you have problems with.
Any more? Any less? If any more you should see if the extras can be
removed and still allow the entire project to compile without errors. If it
can then you didn't need that reference. Any missing from the default
should probably be added.

The exceptions to this are the DAO and ADO object libraries. Depending on
which version of Access you use to create the new blank file some will have
DAO, but not ADO, others ADO, but not DAO, and one version might even
include both(?). Not sure about that last. The point being that the
developer of a file will normally use one of these two, but not the other so
in certain versions that means deviating from the default references.

Other than the DAO/ADO issue you mostly want to stick to the default
references particularly if you will be sharing the application with other
users on other PCs.

 

[David Teich]

I'm sorry, but that added nothing. As I said, i'm looking for references to
urls that explain references, DAO and ADO, not a repeat of what Chris was
kind enough to say.

David

 

[Rick Brandt]

I'm sorry, but that added nothing. As I said, i'm looking for
references to urls that explain references, DAO and ADO, not a repeat
of what Chris was kind enough to say.

Well, I just looked at what Chris posted and nothing was said about which
references you should have. My post does say that (the defaults and nothing
else). If you would prefer to see that same information at some web site
rather than where you asked the question then I suppose Google is your best
option.

 

[David Teich]

Now, you see, on plenty of other support groups, people have pointed me
towards the right resources. Why?
1) They know how hard it is to search the knowledgebase
2) They know how difficult internet searches are on basic words such as
"word" or "access"
3) They're skilled at their jobs and really do know answers and places where
they are answers.

They don't think a title proves anything, they use knowledge. You might wish
to take some pointers from them.