Am Sa, den 09.04.2005 schrieb Wolfgang Schaible um 20:51: > Hi, > > Have table names (UpperLower chars mixed) defined with the tool > 'Base', used in Queries and Forms w/o problems. Was happy. > > Writing > <snip all necessary statements> > oQuery.Command = "SELECT * FROM " & "Journal" > the table (also all other names) was not found.
I'm only guessing here, but I think if you put quotes around the table name, it should work: oQuery.Command = "SELECT * FROM " & "'Journal'" This is the normally annoying behaviour of many tools in databasing... HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]