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

Externally Run Access Queries/Function

P: n/a
I have an Access 2000 database in which there are remotely linked SQL tables
and a couple of local tables.

If I have queries in Access that are designed to pass data between these
remote linked and local tables, is it possible to execute these queries
externally (i.e. from outwith Access) using, for example, .NET/C#? Or is it
possible to run an Access user defined function or macro externally which
then in turn deals with the queries?

I need to be able to do this without it being necessary to have Access open
if possible. If this isn't possible does anyone have any other suggestions
as to how I can achieve this?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SA
John:

The only way to run a user defined function is to lauch Access; which of
course you can do using automation and COM instantiating an instance of
Access and then using the Application object's .Run method to run a function
contained in the db. Of course you can open the instance in a hidden
fashion.

Alternately if all you need to do is to run predefined queries that are
contained in an access db, you can use DAO or ADO to run those without
Access at all. The caveat there is that the queries must not contain any
user defined (VBA) functions or Access specific functions because since the
libraries that provide that functionality are Access specific ADO/DAO won't
know what the functions are and will complain.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"John E" <La********@hotmial.com> wrote in message
news:bn*************@ID-83837.news.uni-berlin.de...
I have an Access 2000 database in which there are remotely linked SQL tables and a couple of local tables.

If I have queries in Access that are designed to pass data between these
remote linked and local tables, is it possible to execute these queries
externally (i.e. from outwith Access) using, for example, .NET/C#? Or is it possible to run an Access user defined function or macro externally which
then in turn deals with the queries?

I need to be able to do this without it being necessary to have Access open if possible. If this isn't possible does anyone have any other suggestions
as to how I can achieve this?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.