469,963 Members | 1,776 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

Externally Run Access Queries/Function

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

Similar topics

2 posts views Thread by John A. Janes | last post: by
3 posts views Thread by Terry Hancock | last post: by
3 posts views Thread by Jon Ole Hedne | last post: by
17 posts views Thread by Jelmer | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.