Pros and cons of the "OpenCurrentDatabase" VS "Shell"

[stburkeuk]

Hi,

I am building a menu system in an intermediary database to control the way users open a selection of other databases.

I want to open one of the databases exclusivly if the data needs refreshing, once the refresh is complete close the database and open as Shared again.


The method I am looking at is to create a new Access instance and then use OpenCurrentDatabase.

Question - a) What are the relative benifits to using this method or the Shell method?

Thanks in advance for any advise/experiance that may be offered.

 

[PHV]

Simply the easer automation.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244