If it is just information retrieval, why don't you use ACE.OLEDB connection
from Excel and display the required information in an excel sheet itself?
Or why don't you try linked tables? You don't necessarily need to open a
database to show what's in it?
On Wed, Apr 17, 2013 at 3:13 PM, wrote:
>
Hi Sam,
Thanks for the response. The purpose of opening with VBA is simple, it's
just to open it so front end users can use the database for it's purpose of
information retrieval, reporting etc.
The user group requires to access many different Excel reports and
Access databases with many of