Re: Reserved words
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 03/19/05
- Next message: mabond: "List box selection and requery"
- Previous message: Sandy H: "Reserved words"
- In reply to: Sandy H: "Reserved words"
- Next in thread: Sandy H: "Re: Reserved words"
- Reply: Sandy H: "Re: Reserved words"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 19 Mar 2005 18:37:41 +0800
Try enclosing the field name in square brackets, and including the table
name, e.g.:
[Table1].[Time]
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Sandy H" <s.hayman@optusnet.com.au> wrote in message news:423bf8f9$1@news.comindico.com.au... > Hi > I am making some changes to a database that I didn't create and ran into a > problem where the original creator used the word 'Time' as a field. I am > trying to run an INSERT sql statement on this table and naturally, it > doesn't work because of the Time field. Is there a way around this problem > without changing the field name (The database is linked to a data file and > the client is not in the same city as me so changing the field name is > somewhat difficult).
- Next message: mabond: "List box selection and requery"
- Previous message: Sandy H: "Reserved words"
- In reply to: Sandy H: "Reserved words"
- Next in thread: Sandy H: "Re: Reserved words"
- Reply: Sandy H: "Re: Reserved words"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
