By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,939 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,939 IT Pros & Developers. It's quick & easy.

Currentdb in access 2000

P: n/a
Hi

In Access 2000 I have the following code;

Set dbs = CurrentDb

<some code to access database here>

Set dbs = Nothing

Would the last line cause any problem with my currently open access
application/database?

Thanks

Regards
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
No because Set dbs only establishes *another* reference to the currend
database. When you do Set dbs = nothing it removes that reference you've
created, not the one opened by the application object. As long as at
least one reference is valid the object will persist.

Pavel

John wrote:

Hi

In Access 2000 I have the following code;

Set dbs = CurrentDb

<some code to access database here>

Set dbs = Nothing

Would the last line cause any problem with my currently open access
application/database?

Thanks

Regards

Nov 12 '05 #2

P: n/a
> In Access 2000 I have the following code;
Set dbs = CurrentDb
<some code to access database here>
Set dbs = Nothing Would the last line cause any problem with my currently open access
application/database?


No, you're just destroying a reference to CurrentDB. See also:

http://groups.google.com/gr*********....microsoft.com

Peter

--
No mails please.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.