Am Samstag 09 April 2005 21.35 schrieb Marc Santhoff: > 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... agree
Table name was given as String Variable. Then I wrote to be shure the name direct in quotes. After changing the table names and in the command to JOURNAL etc. in Uppercase all tables respond. and the tables are not longer accessible... and no idea how to restore Regards Wolfgang --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
