Re: ADO with ACCESS 2007 and EXCEL 2007?

"Chris.Cheney"
I can't understand the problem with use of [ ] - could this be a
localisation issue? Is there a character set issue, e.g. umlauts?

I don't believe the problem is the use of [] becacuse I made another test with FROM [Fakturering] and that worked exactly as all my tests without the brackets around the spreadsheetname. I believe brackets are optional unless required due to special characters being present in the spread*** name?

The problem here seems to be the trailing $ which apparently causes the name to be "invalid"? However, I am not aware of any other situation in Delphi, MS Office or Windows where a $ causes problems, I can (and do) for instance use it as a legal character in filenames and there is no problem specifying hexadecimal values using the $ prefix in my Delphi source.

I have been playing around with an ADODataset (without the ADOConnection)
and have found a difference in use between JET and ACE:

if I set ADODataset.Active := True; in the FormCreate, it's ok with JET but
ACE complains that it is already in use. Moving the assignment to FormShow
and it's ok with both JET and ACE. I can't explain that!

In my program ADODataset1.Active is false until the first time a connection is made. The ADODataset1.Close statement in my code is there only to cater for the possibility that I make another connection.

What really puzzles me is that I have no problem with Jet and Excel version 8 or ACE and Excel version 12, only with the combination ACE and Excel version 8. (And the problem doesn't show until ADODataset1.open when the SELECT statement is processed.)

Please observe that there is no difference in my code for the various alternatives other than the differences in ADOConnection1.provider and ADOConnection1.connectionstring?

I am worried.

regards Sven




.