Access 2007 alters my query

[jal]

If I write a query like this:

UPDATE Customers SET FirstName = UCase(FirstName), LastName = UCase(LastName)

and then save it in Access 2007, it prefixes the table name:


UPDATE Customers SET Customers.FirstName = UCase(Customers.FirstName), Customers.LastName = UCase(Customers.LastName)

I don't like it because I sometimes change my table names on the fly. Anyway to stop this prefixing?

 

[SOS]

Just leave it alone and use code to fix your SQL whenever you need to.

Use this set of functions (courtesy of Access MVP Armen Stein) to do fix any query at any time (including swapping out the Where clause). It is pretty cool code.

 

[MSAccessRookie]

If I write a query like this:

UPDATE Customers SET FirstName = UCase(FirstName), LastName = UCase(LastName)

and then save it in Access 2007, it prefixes the table name:


UPDATE Customers SET Customers.FirstName = UCase(Customers.FirstName), Customers.LastName = UCase(Customers.LastName)

I don't like it because I sometimes change my table names on the fly. Anyway to stop this prefixing?

I am not aware of any method of disabling this feature of MS Access.

I would, however be interested in hearing more details regarding the reason for the need to change the Table names "on the fly" that creates this request, because something tells me that there may be another way to handle the situation.