Access DB failing to do even basic functions, eg left or trim

[Dunk]

I've been working on a Database for the last few weeks, with an SQL server back end and an access front end. Works fine on this machine and also works fine on the other machine in my area, regardless off who is logged in.
However, when you try and run it on some of the other machines around the office, we hit a problem where it refuses to do even the most basic of functions. For example, create a standard query from one of the tables, and return the columns, doing nothing to them and it works fine, however if you try and do any function at all it fails. It does this across several machines, and I have no idea what is causing it.
Im using Access 2000 for the front end and SQL server 7 for the back end.
Any ideas?

 

[Wayne Morgan]

This is usually the problem when you get what you are describing.

http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Wayne Morgan
MS Access MVP

I've been working on a Database for the last few weeks, with an SQL server

back end and an access front end. Works fine on this machine and also works
fine on the other machine in my area, regardless off who is logged in.

However, when you try and run it on some of the other machines around the

office, we hit a problem where it refuses to do even the most basic of
functions. For example, create a standard query from one of the tables, and
return the columns, doing nothing to them and it works fine, however if you
try and do any function at all it fails. It does this across several
machines, and I have no idea what is causing it.

 

[Bruce Pick]

Thank you, Dunk

I've been plagued by this myself. I hope this reference enables me to
clean up the mess in my old Access 97 installation.

+++++++++++++++++++++++++++++++++

 

[zfidjili]

This is usually the problem when you get what you are describing.

http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Wayne Morgan
MS Access MVP


server
back end and an access front end. Works fine on this machine and also works
fine on the other machine in my area, regardless off who is logged in. the
office, we hit a problem where it refuses to do even the most basic of
functions. For example, create a standard query from one of the tables, and
return the columns, doing nothing to them and it works fine, however if you
try and do any function at all it fails. It does this across several
machines, and I have no idea what is causing it.

 

[zfidjili]

This is usually the problem when you get what you are describing.

http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Wayne Morgan
MS Access MVP


server
back end and an access front end. Works fine on this machine and also works
fine on the other machine in my area, regardless off who is logged in. the
office, we hit a problem where it refuses to do even the most basic of
functions. For example, create a standard query from one of the tables, and
return the columns, doing nothing to them and it works fine, however if you
try and do any function at all it fails. It does this across several
machines, and I have no idea what is causing it.