Excel sql, recordset & connection

[Snoopy2003]

Hello,

I have an excel application with data file (xlsx) and forms.
Before opening a form I establish connection to the data file and retrieve information.
I pass result recordset to the form.

I need to keep result recordset active during the form life
but I need to close the connection to the data file.

My problem: After I close the connection to the data file, result recordset is no longer available.

After executing a query how can I keep the results and close the connection to the DB file ?

Thank you for your help

[DGagnon]

you could create/use a worksheet that is used as a temp data store, then work with the data out of that sheet. then when you are ready to send it back to the DB file you can reopen the connection.

[Snoopy2003]

Thank you for your help.

Can I store query results in recordset which is not depending on the connection ?

Thank you

[OnErrorGoto0]

If you set the recordset's connection to nothing before you close the connection it should be fine.

[tkowal]

You may look at "Disconnected Recordsets" there are plenty of good articles on them.
http://www.4guysfromrolla.com/webtech/080101-1.shtml

Still in using them you would have to re-establish a connection to your datasource to re-sync the data..

[Snoopy2003]

Hello,

Thank you for your help. tkowal I will read it now.

I have a strange problem. If 2 users are trying to open a different copy of my application and open a form which is based on the same excel data file. The second user gets an excel crash.
Can I use access DB in order to allow multiple excel users to work with the same data source ?
Why sharing excel data file did not solve this problem and did not allow 2 users to establish connection to the data file (xlsx) ?

Thank you