Currentdb in access 2000

[John]

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

[Pavel Romashkin]

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

[Peter Doering]

> 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.