by Mauree » Thu, 12 Sep 2002 05:47:43
Anybody knows MS Jet OLEDB 4.0 still valid to make
connection to Access XP and Excel XP?
And I'm debugging a VB App which builds a histogram in
Excel from a data file, but how can I totally terminate
the connection to Excel after I'm done with it?
Thanks,
Maureen
by Val Mazu » Thu, 12 Sep 2002 23:40:20
As far as I know, yes it works with Access XP and Excel XP. If you need to
close connection to previously opened database, then just call Close method
of opened connection and set connection variable to Nothing
MyConnection.Close
Set MyConnection=Nothing
--
Val Mazur
Microsoft MVP
Quote:> Hi,
> Anybody knows MS Jet OLEDB 4.0 still valid to make
> connection to Access XP and Excel XP?
> And I'm debugging a VB App which builds a histogram in
> Excel from a data file, but how can I totally terminate
> the connection to Excel after I'm done with it?
> Thanks,
> Maureen
1. How to set Format property in ACCESS2k thru ADOX using JET OLEDB 4.0 provider
Dear All Hay!!!
Following is a limitation faced by us
regarding ADOX:
How to set 'Format' property in ACCESS 2000 through ADOX
using JET OLEDB 4.0 provider.
We are able to get other properties viz. "JET OLEDB:Allow
Zero Length", but not for FORMAT.
Could you please help us to do this...
Thanks for your time and consideration...
Yours truly and spiritually...
Amit kumar
3. help - ADO and Jet OLEDB 4.0
4. problems with a recursive procedure and the creation of a temporal table
6. What type is this database?
7. ADOX: Jet Oledb 4.0: How to set Format property for a column
8. jdbc output
10. Jet OLEDB 4.0 Text Engine - DisabledExtensions and adSchemaColumns
11. Detecting the presence of Jet OLEDB 4.0 provider
12. help - ADO and Jet OLEDB 4.0
13. How can I add Microsoft Jet OLEDB 4.0 Provider with my PDW Setup Files