We have a database that was created in Access2000 and when opened in (or converted to) Access2003, commas in the query criteria fields change to vertical bars. The query still runs OK, but when you try to modify it (by adding another table or something) you get an error message: "Invalid use of vertical bars in query expression 'IIf(Abs([Data1])<8|""|L1Z")'. (the vertical bars ( | ) appear where there were commas in the original version).
Does anyone know a "fix" or "workaround" for this issue? The big problem is that two people are working on developing this database using the two different versions of Access, and for the time being, there isn't really a way around that.
Thanks in advance!
Does anyone know a "fix" or "workaround" for this issue? The big problem is that two people are working on developing this database using the two different versions of Access, and for the time being, there isn't really a way around that.
Thanks in advance!
