am I going mad - table names and errors
In access 97 changing the name of the table meant that a query that used the table would no longer work because the table reference would be wrong
In access xp changing the name of the table automatically updates the reference in the query.
Can this be turned off? its really not what I want especially as i'm using a lot of code from 97 that makes assumptions about that kind of thing not happening!
secondly, in one of my databases when I run this query
select right(name,4) from table1 it returns an error saying function right not recognised.
HELP!
WB
In access 97 changing the name of the table meant that a query that used the table would no longer work because the table reference would be wrong
In access xp changing the name of the table automatically updates the reference in the query.
Can this be turned off? its really not what I want especially as i'm using a lot of code from 97 that makes assumptions about that kind of thing not happening!
secondly, in one of my databases when I run this query
select right(name,4) from table1 it returns an error saying function right not recognised.
HELP!
WB
