Am Sa, den 09.04.2005 schrieb Wolfgang Schaible um 22:17: > 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
I cannot comment on those problems, sorry. Best would be to have a nice weekend and come back to beta testing on monday when the developers are active again... Cheers, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]