Microsoft throwing curve balls at Access Developers! ARGH!

[Jozef]

Does anyone know if there is some sort of catch all installation program
that will determine if dependencies were installed properly?

I get the feeling that the Windows boys like to throw curve balls to the
Access boys over there at Microsoft (or the Access boys just like shooting
themselves in the foot by not properly developing/testing). I have an
application that seems to constantly require modification in the set up
procedure to deal with crap that windows throws at it. After going through
a round of error messages as a result of a clean Windows XP SP2 install
(missing dlls that old windows used to have) I'm hit with a whole new round
of problems.

I'm getting reports of what look like a missing reference to the program.
The users of this program are using XP SP2 Version 5.1 and have a
pre-installed version of Access XP. The message is similar to a missing
reference: "error message 3075 function is not available in expression in
query expression 'left (databsae,1)"

Any help would be great.

Thanks!

[Allen Browne]

The problem you describe is typical of bad references.

See:
http://allenbrowne.com/ser-38.html
The article explains which references are needed for each version of Access,
and how to keep them to a minimum.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jozef" <SP**********@telus.net> wrote in message
news:ibRBe.1961517$6l.274030@pd7tw2no...

Does anyone know if there is some sort of catch all installation program
that will determine if dependencies were installed properly?

I get the feeling that the Windows boys like to throw curve balls to the
Access boys over there at Microsoft (or the Access boys just like shooting
themselves in the foot by not properly developing/testing). I have an
application that seems to constantly require modification in the set up
procedure to deal with crap that windows throws at it. After going
through a round of error messages as a result of a clean Windows XP SP2
install (missing dlls that old windows used to have) I'm hit with a whole
new round of problems.

I'm getting reports of what look like a missing reference to the program.
The users of this program are using XP SP2 Version 5.1 and have a
pre-installed version of Access XP. The message is similar to a missing
reference: "error message 3075 function is not available in expression in
query expression 'left (databsae,1)"

Any help would be great.

Thanks!

[Jozef]

Hi Allen,

Yea, I should have added, I never use references for just that reason, only
what's there by default.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...

The problem you describe is typical of bad references.

See:
http://allenbrowne.com/ser-38.html
The article explains which references are needed for each version of
Access, and how to keep them to a minimum.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jozef" <SP**********@telus.net> wrote in message
news:ibRBe.1961517$6l.274030@pd7tw2no...

Does anyone know if there is some sort of catch all installation program
that will determine if dependencies were installed properly?

I get the feeling that the Windows boys like to throw curve balls to the
Access boys over there at Microsoft (or the Access boys just like
shooting themselves in the foot by not properly developing/testing). I
have an application that seems to constantly require modification in the
set up procedure to deal with crap that windows throws at it. After
going through a round of error messages as a result of a clean Windows XP
SP2 install (missing dlls that old windows used to have) I'm hit with a
whole new round of problems.

I'm getting reports of what look like a missing reference to the program.
The users of this program are using XP SP2 Version 5.1 and have a
pre-installed version of Access XP. The message is similar to a missing
reference: "error message 3075 function is not available in expression
in query expression 'left (databsae,1)"

Any help would be great.

Thanks!

[Jozef]

Hi Allen,

Yea, I should have added, I never use references for just that reason, only
what's there by default.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...

The problem you describe is typical of bad references.

See:
http://allenbrowne.com/ser-38.html
The article explains which references are needed for each version of
Access, and how to keep them to a minimum.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jozef" <SP**********@telus.net> wrote in message
news:ibRBe.1961517$6l.274030@pd7tw2no...

Does anyone know if there is some sort of catch all installation program
that will determine if dependencies were installed properly?

I get the feeling that the Windows boys like to throw curve balls to the
Access boys over there at Microsoft (or the Access boys just like
shooting themselves in the foot by not properly developing/testing). I
have an application that seems to constantly require modification in the
set up procedure to deal with crap that windows throws at it. After
going through a round of error messages as a result of a clean Windows XP
SP2 install (missing dlls that old windows used to have) I'm hit with a
whole new round of problems.

I'm getting reports of what look like a missing reference to the program.
The users of this program are using XP SP2 Version 5.1 and have a
pre-installed version of Access XP. The message is similar to a missing
reference: "error message 3075 function is not available in expression
in query expression 'left (databsae,1)"

Any help would be great.

Thanks!

[Jozef]

.....and thanks for the info!

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...

The problem you describe is typical of bad references.

See:
http://allenbrowne.com/ser-38.html
The article explains which references are needed for each version of
Access, and how to keep them to a minimum.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jozef" <SP**********@telus.net> wrote in message
news:ibRBe.1961517$6l.274030@pd7tw2no...

Does anyone know if there is some sort of catch all installation program
that will determine if dependencies were installed properly?

I get the feeling that the Windows boys like to throw curve balls to the
Access boys over there at Microsoft (or the Access boys just like
shooting themselves in the foot by not properly developing/testing). I
have an application that seems to constantly require modification in the
set up procedure to deal with crap that windows throws at it. After
going through a round of error messages as a result of a clean Windows XP
SP2 install (missing dlls that old windows used to have) I'm hit with a
whole new round of problems.

I'm getting reports of what look like a missing reference to the program.
The users of this program are using XP SP2 Version 5.1 and have a
pre-installed version of Access XP. The message is similar to a missing
reference: "error message 3075 function is not available in expression
in query expression 'left (databsae,1)"

Any help would be great.

Thanks!

[Jozef]

.....and thanks for the info!

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...

The problem you describe is typical of bad references.

See:
http://allenbrowne.com/ser-38.html
The article explains which references are needed for each version of
Access, and how to keep them to a minimum.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jozef" <SP**********@telus.net> wrote in message
news:ibRBe.1961517$6l.274030@pd7tw2no...

Does anyone know if there is some sort of catch all installation program
that will determine if dependencies were installed properly?

I get the feeling that the Windows boys like to throw curve balls to the
Access boys over there at Microsoft (or the Access boys just like
shooting themselves in the foot by not properly developing/testing). I
have an application that seems to constantly require modification in the
set up procedure to deal with crap that windows throws at it. After
going through a round of error messages as a result of a clean Windows XP
SP2 install (missing dlls that old windows used to have) I'm hit with a
whole new round of problems.

I'm getting reports of what look like a missing reference to the program.
The users of this program are using XP SP2 Version 5.1 and have a
pre-installed version of Access XP. The message is similar to a missing
reference: "error message 3075 function is not available in expression
in query expression 'left (databsae,1)"

Any help would be great.

Thanks!