Access Conflict

[Kassie42 via AccessMonster.com]

Hello,

We have an Access 97 database residing in a shared network folder. Recently
we got new computers. The new computers are running Windows XP SP3, Microsoft
Office 2003, Compatiblitiy Pack for the 2007 Office System, Microsoft Office
Converter Pack, Microsoft Silverlight and Office 97. The original computers
run Windows XP SP2, Microsoft Office 2000, and Office 97. The database works
fine on the original computers. The new computers are a different story. When
we select a specific control in a form, a macro that is not supposed to run
on this control attempts to run. We have to halt it. This does not happen on
the original computers. Some users are using the original computers, while
others are using the new ones. Any ideas? We tried uninstalling Office 2003
and updating net framework. Any help is greatly appreciated.

Kassie

 

[David W. Fenton]

We have an Access 97 database residing in a shared network folder.
Recently we got new computers. The new computers are running
Windows XP SP3, Microsoft Office 2003, Compatiblitiy Pack for the
2007 Office System, Microsoft Office Converter Pack, Microsoft
Silverlight and Office 97. The original computers run Windows XP
SP2, Microsoft Office 2000, and Office 97. The database works fine
on the original computers. The new computers are a different
story. When we select a specific control in a form, a macro that
is not supposed to run on this control attempts to run. We have to
halt it. This does not happen on the original computers. Some
users are using the original computers, while others are using the
new ones. Any ideas? We tried uninstalling Office 2003 and
updating net framework. Any help is greatly appreciated.

Have you decompiled and recompiled the app on the new computers?

BTW, the .NET Framework has absolutely no effect on Access at all.

 

[Kassie42 via AccessMonster.com]

We have an Access 97 database residing in a shared network folder.
Recently we got new computers. The new computers are running

[quoted text clipped - 9 lines]

new ones. Any ideas? We tried uninstalling Office 2003 and
updating net framework. Any help is greatly appreciated.

Have you decompiled and recompiled the app on the new computers?

BTW, the .NET Framework has absolutely no effect on Access at all.
I am sorry. I don't know what you mean by decompile and recompile, but if you can lead me in the right direction I can figure it out. We have another department that sets up the new computers and then they give them to us to distribute and work out the bugs.

I did learn that two other programs are having issues with access as well,
though they are different issues. I am guessing they are related to the image
otherwise it is a wierd coincidence. They also reside in a shared network
folder although the one program has a Windows Network established.

 

[Kassie42 via AccessMonster.com]

[quoted text clipped - 6 lines]

BTW, the .NET Framework has absolutely no effect on Access at all.
I am sorry. I don't know what you mean by decompile and recompile, but if you can lead me in the right direction I can figure it out. We have another department that sets up the new computers and then they give them to us to distribute and work out the bugs.

I did learn that two other programs are having issues with access as well,
though they are different issues. I am guessing they are related to the image
otherwise it is a wierd coincidence. They also reside in a shared network
folder although the one program has a Windows Network established.

One other thing, the "Title Bar" top left corner that normally shows the key
and reads Microsoft Access now shows the key and reads Short Cut. It is not a
shortcut that I am looking at. I created a new database and tried importing
the data, etc., but still have same problem with everything.

 

[Gina Whipp]

Kassie42,

This sounds like it might have to with References. Check for MISSING
References http://www.regina-whipp.com/index_files/References.htm

Also, as Access 97 used a different set of References then 2000, 2003 and
2007 and some are not even needed in the newer versions of Access, list the
References you do see here. Seeing those will help us identify the ones
that no longer need.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

We have an Access 97 database residing in a shared network folder.
Recently we got new computers. The new computers are running

[quoted text clipped - 6 lines]

BTW, the .NET Framework has absolutely no effect on Access at all.
I am sorry. I don't know what you mean by decompile and recompile, but if
you can lead me in the right direction I can figure it out. We have
another department that sets up the new computers and then they give them
to us to distribute and work out the bugs.

I did learn that two other programs are having issues with access as well,
though they are different issues. I am guessing they are related to the
image
otherwise it is a wierd coincidence. They also reside in a shared network
folder although the one program has a Windows Network established.

One other thing, the "Title Bar" top left corner that normally shows the
key
and reads Microsoft Access now shows the key and reads Short Cut. It is
not a
shortcut that I am looking at. I created a new database and tried
importing
the data, etc., but still have same problem with everything.

 

[Kassie42 via AccessMonster.com]

Kassie42,

This sounds like it might have to with References. Check for MISSING
References http://www.regina-whipp.com/index_files/References.htm

Also, as Access 97 used a different set of References then 2000, 2003 and
2007 and some are not even needed in the newer versions of Access, list the
References you do see here. Seeing those will help us identify the ones
that no longer need.
[quoted text clipped - 17 lines]

importing
the data, etc., but still have same problem with everything.

Hi Gina,

I tried to get the references, but I was unable to access "References" list.
Maybe because it is still in 97? I followed the directions in the link, but
I do not get the Reference menu.

I know there is some piece missing to this puzzle.

Kassie

 

[David W. Fenton]

We have an Access 97 database residing in a shared network
folder. Recently we got new computers. The new computers are
running

[quoted text clipped - 9 lines]

new ones. Any ideas? We tried uninstalling Office 2003 and
updating net framework. Any help is greatly appreciated.

Have you decompiled and recompiled the app on the new computers?

BTW, the .NET Framework has absolutely no effect on Access at all.

I am sorry. I don't know what you mean by decompile and recompile,
but if you can lead me in the right direction I can figure it out.

Surely you compile your code in your app, right? If not, you must be
a real novice!

We have another department that sets up the new computers and then
they give them to us to distribute and work out the bugs.

I did learn that two other programs are having issues with access
as well, though they are different issues. I am guessing they are
related to the image otherwise it is a wierd coincidence. They
also reside in a shared network folder although the one program
has a Windows Network established.

I can't say, as there is not enough information to make much of a
guess. Are these computers created by imaging a hard drive, or is
the Access installer being used to create the installation? If the
former, maybe the Access program image is corrupt or incorrectly
installed.

 

[Gina Whipp]

Kassie,

Can you get to the Design of any form? Or perhaps this Access 97 database
is an MDE file?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kassie42,

This sounds like it might have to with References. Check for MISSING
References http://www.regina-whipp.com/index_files/References.htm

Also, as Access 97 used a different set of References then 2000, 2003 and
2007 and some are not even needed in the newer versions of Access, list
the
References you do see here. Seeing those will help us identify the ones
that no longer need.

We have an Access 97 database residing in a shared network folder.
Recently we got new computers. The new computers are running

[quoted text clipped - 17 lines]

importing
the data, etc., but still have same problem with everything.

Hi Gina,

I tried to get the references, but I was unable to access "References"
list.
Maybe because it is still in 97? I followed the directions in the link,
but
I do not get the Reference menu.

I know there is some piece missing to this puzzle.

Kassie

 

[Kassie42 via AccessMonster.com]

We have an Access 97 database residing in a shared network
folder. Recently we got new computers. The new computers are [quoted text clipped - 9 lines]
I am sorry. I don't know what you mean by decompile and recompile,
but if you can lead me in the right direction I can figure it out.

Surely you compile your code in your app, right? If not, you must be
a real novice!

We have another department that sets up the new computers and then
they give them to us to distribute and work out the bugs.

[quoted text clipped - 4 lines]

also reside in a shared network folder although the one program
has a Windows Network established.

I can't say, as there is not enough information to make much of a
guess. Are these computers created by imaging a hard drive, or is
the Access installer being used to create the installation? If the
former, maybe the Access program image is corrupt or incorrectly
installed.

Hi David,

We aren't programmers here just technicians. We don't typically work too much
with access hence the problems. We also didn't create the image another
department did. Believe me, we have tried to speak to a person over there and
also have a service call in, but have not gotten anywhere which is
frustrating. I think we are going to strip the computer down and start from
the basics and go from there. We already uninstalled and reinstalled access,
but that did not work, but then again we are using the access program they
provided us from the shared drive. We will need to request a clean install of
97. I appreciate everyone trying to help me and I am sorry I can't provide
much more information. Kassie

 

[Kassie42 via AccessMonster.com]

Kassie,

Can you get to the Design of any form? Or perhaps this Access 97 database
is an MDE file?
[quoted text clipped - 24 lines]

Kassie

Gina,

I can get to the design of the form.

Kassie

 

[Gina Whipp]

While in Design Mode press the Code button (colored square looking thingy...
thingy = technical term). Once in the Code window go to Tools...
References... A window should open with objects listing in it. Simply
write down those items which have a check check mark and type them here...
in the order in which they are typed.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kassie,

Can you get to the Design of any form? Or perhaps this Access 97 database
is an MDE file?

Kassie42,

[quoted text clipped - 24 lines]

Kassie

Gina,

I can get to the design of the form.

Kassie

 

[David W. Fenton]

While in Design Mode press the Code button (colored square looking
thingy... thingy = technical term). Once in the Code window go to
Tools... References... A window should open with objects listing
in it. Simply write down those items which have a check check
mark and type them here... in the order in which they are typed.

Your instructions are for A2000 and after -- A97 had no seperate
VBE.

All you have to do is hit Ctrl-G and then go to the Tools menu. The
first choice is REFERENCES.

 

[Gina Whipp]

David,

It's been awhile since I had to use Access 97... THANKS for the correction!
I better note that on my website!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[dpminusa via AccessMonster.com]

[quoted text clipped - 16 lines]

former, maybe the Access program image is corrupt or incorrectly
installed.

Hi David,

We aren't programmers here just technicians. We don't typically work too much
with access hence the problems. We also didn't create the image another
department did. Believe me, we have tried to speak to a person over there and
also have a service call in, but have not gotten anywhere which is
frustrating. I think we are going to strip the computer down and start from
the basics and go from there. We already uninstalled and reinstalled access,
but that did not work, but then again we are using the access program they
provided us from the shared drive. We will need to request a clean install of
97. I appreciate everyone trying to help me and I am sorry I can't provide
much more information. Kassie

I have been doing some similar migrations recently:

One suggestion I have is to get into the VBA editor (ALT F11), then use the
DEBUG Menu and the Compile Option to see what ACCESS finds. If it compiles
cleanly (I suspect it may not) then the TOOLS Reference recommendation would
seem a good next idea.

Failing both of these you can set a BREAK POINT by clicking the small left
column on the VBA code page for a convenient line near your suspicious area.
Then use the IMMEDIATE WINDOW (CTL G) and the ? Operator to examine some
variables. In fact Mouse-overs of some of the variables should pop-up values
for you.

It sounds like you may not be too literate in VBA. If not perhaps you could
give it a try and draw the Applications Support group in with a Q&A that way.

Maybe this will provide some direction?