CODEWITHSUNDEEP
ms-accessvba
PowerUser
PowerUser

Reputation: 11791

Access's trim() function not recognized on another machine

I built a modest Access DB and asked a coworker to test it on her machine. To my surprise, an error message popped up, saying it didn't recognize Trim(). The query in question is a standard select query that pulls from a MSSQL Server DB. Why isn't it recognized on her machine and how do I get around this?

(We both use MS Office 2003 and have network permissions to the same source tables.)

Upvotes: 1

Views: 1538

Answers (1)

Fionnuala
Fionnuala

Reputation: 91316

Let me guess, you are using Trim with a linked table and it works on your PC but not your colleague's? If so, check the references in the code window for any marked MISSING. Missing references lead to quite odd errors.

Upvotes: 2

Related Questions