Left (Right) Join vs Left (function)

I recently got updated to Access 2007 from 2003. My datbase sits on an
out-of-house server, and I have administrator permissions for Office 2007,
but not for the server.
Problem: Access does not recognise my old SQLs and my old funtions. Wherever
there is table joining, "LEFT" of "RIGHT" are not recognised in the
FROM-clause as part of it. And hence, returns the message "unidentified
function LEFT in expression".
AND where there IS an expression, "LEFT" is not recognised at all.
However, inseide the SQL there is no problem and it runs without error.
Errors occur when [job] is started outside the SQL.

Help anybody?

It sounds like you're missing some library references after the switch to
2007. Open the VBA editor and check Tools menu - References. If any say
"Missing" then find the correct reference.

"John F" John wrote in message
...
I recently got updated to Access 2007 from 2003. My datbase sits on an
out-of-house server, and I have administrator permissions for Office 2007,
but not for the server.
Problem: Access does not recognise my old SQLs and my old funtions.
Wherever
there is table joining, "LEFT" of "RIGHT" are not recognised in the
FROM-clause as part of it. And hence, returns the message "unidentified
function LEFT in expression".
AND where there IS an expression, "LEFT" is not recognised at all.
However, inseide the SQL there is no problem and it runs without error.
Errors occur when [job] is started outside the SQL.

Thanks Paul,
I already did, and utility.mda was mising, but not allowed back again. is
there a way around?


"Paul Shapiro" wrote:

It sounds like you're missing some library references after the switch to
2007. Open the VBA editor and check Tools menu - References. If any say
"Missing" then find the correct reference.

"John F" John wrote in message
...
I recently got updated to Access 2007 from 2003. My datbase sits on an
out-of-house server, and I have administrator permissions for Office 2007,
but not for the server.
Problem: Access does not recognise my old SQLs and my old funtions.
Wherever
there is table joining, "LEFT" of "RIGHT" are not recognised in the
FROM-clause as part of it. And hence, returns the message "unidentified
function LEFT in expression".
AND where there IS an expression, "LEFT" is not recognised at all.
However, inseide the SQL there is no problem and it runs without error.
Errors occur when [job] is started outside the SQL.

You shouldn't need utility.mda (I don't believe it's actually been required
since Access 97)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"John F" wrote in message
...
Thanks Paul,
I already did, and utility.mda was mising, but not allowed back again. is
there a way around?


"Paul Shapiro" wrote:

It sounds like you're missing some library references after the switch to
2007. Open the VBA editor and check Tools menu - References. If any say
"Missing" then find the correct reference.

"John F" John wrote in message
...
I recently got updated to Access 2007 from 2003. My datbase sits on an
out-of-house server, and I have administrator permissions for Office
2007,
but not for the server.
Problem: Access does not recognise my old SQLs and my old funtions.
Wherever
there is table joining, "LEFT" of "RIGHT" are not recognised in the
FROM-clause as part of it. And hence, returns the message "unidentified
function LEFT in expression".
AND where there IS an expression, "LEFT" is not recognised at all.
However, inseide the SQL there is no problem and it runs without error.
Errors occur when [job] is started outside the SQL.

Thank you,
I have read something about this, but as it's the only missing item, I've
tried to install it, and to no avail.

"Douglas J. Steele" wrote:

You shouldn't need utility.mda (I don't believe it's actually been required
since Access 97)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"John F" wrote in message
...
Thanks Paul,
I already did, and utility.mda was mising, but not allowed back again. is
there a way around?


"Paul Shapiro" wrote:

It sounds like you're missing some library references after the switch to
2007. Open the VBA editor and check Tools menu - References. If any say
"Missing" then find the correct reference.

"John F" John wrote in message
...
I recently got updated to Access 2007 from 2003. My datbase sits on an
out-of-house server, and I have administrator permissions for Office
2007,
but not for the server.
Problem: Access does not recognise my old SQLs and my old funtions.
Wherever
there is table joining, "LEFT" of "RIGHT" are not recognised in the
FROM-clause as part of it. And hence, returns the message "unidentified
function LEFT in expression".
AND where there IS an expression, "LEFT" is not recognised at all.
However, inseide the SQL there is no problem and it runs without error.
Errors occur when [job] is started outside the SQL.

So what happens when you remove the reference to it? Does your application
run correctly?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"John F" wrote in message
...
Thank you,
I have read something about this, but as it's the only missing item, I've
tried to install it, and to no avail.

"Douglas J. Steele" wrote:

You shouldn't need utility.mda (I don't believe it's actually been
required
since Access 97)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"John F" wrote in message
...
Thanks Paul,
I already did, and utility.mda was mising, but not allowed back again.
is
there a way around?


"Paul Shapiro" wrote:

It sounds like you're missing some library references after the switch
to
2007. Open the VBA editor and check Tools menu - References. If any
say
"Missing" then find the correct reference.

"John F" John wrote in message
...
I recently got updated to Access 2007 from 2003. My datbase sits on
an
out-of-house server, and I have administrator permissions for Office
2007,
but not for the server.
Problem: Access does not recognise my old SQLs and my old funtions.
Wherever
there is table joining, "LEFT" of "RIGHT" are not recognised in the
FROM-clause as part of it. And hence, returns the message
"unidentified
function LEFT in expression".
AND where there IS an expression, "LEFT" is not recognised at all.
However, inseide the SQL there is no problem and it runs without
error.
Errors occur when [job] is started outside the SQL.

On Fri, 2 Jan 2009 10:18:02 -0800, John F
wrote:

Thank you,
I have read something about this, but as it's the only missing item, I've
tried to install it, and to no avail.

Simply uncheck it. If you're not using it (and it's very unlikely that you
are!) nothing should break. If something does break, you'll need to either
find a copy of the utility, or change the code to use newer libraries - but if
you uncheck it, compile the database, and everything compiles correctly, you
should be good to go.
--

John W. Vinson [MVP]

"Douglas J. Steele" wrote in
:

You shouldn't need utility.mda (I don't believe it's actually been
required since Access 97)

It wasn't a reference even then. Indeed, I think it dates back to
Access 2.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

That's right. Thank you for the very simple and (to me, not so) obvious
solution. Everything runs just as I like it.
I'm taking the rest of the day off.

"Douglas J. Steele" wrote:

So what happens when you remove the reference to it? Does your application
run correctly?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"John F" wrote in message
...
Thank you,
I have read something about this, but as it's the only missing item, I've
tried to install it, and to no avail.

"Douglas J. Steele" wrote:

You shouldn't need utility.mda (I don't believe it's actually been
required
since Access 97)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"John F" wrote in message
...
Thanks Paul,
I already did, and utility.mda was mising, but not allowed back again.
is
there a way around?


"Paul Shapiro" wrote:

It sounds like you're missing some library references after the switch
to
2007. Open the VBA editor and check Tools menu - References. If any
say
"Missing" then find the correct reference.

"John F" John wrote in message
...
I recently got updated to Access 2007 from 2003. My datbase sits on
an
out-of-house server, and I have administrator permissions for Office
2007,
but not for the server.
Problem: Access does not recognise my old SQLs and my old funtions.
Wherever
there is table joining, "LEFT" of "RIGHT" are not recognised in the
FROM-clause as part of it. And hence, returns the message
"unidentified
function LEFT in expression".
AND where there IS an expression, "LEFT" is not recognised at all.
However, inseide the SQL there is no problem and it runs without
error.
Errors occur when [job] is started outside the SQL.

Thanks a lot. The application now runs as it should.

"John W. Vinson" wrote:

On Fri, 2 Jan 2009 10:18:02 -0800, John F
wrote:

Thank you,
I have read something about this, but as it's the only missing item, I've
tried to install it, and to no avail.

Simply uncheck it. If you're not using it (and it's very unlikely that you
are!) nothing should break. If something does break, you'll need to either
find a copy of the utility, or change the code to use newer libraries - but if
you uncheck it, compile the database, and everything compiles correctly, you
should be good to go.
--

John W. Vinson [MVP]