Run Macros without MS ACCESS loaded

[Reg]

At present I'm running a number of macros with a schedular on my
computer to update and maintain databases within our network. All my
backends contain the tables that the macros update. But all the
backends are on servers that do not have access loaded on them. I
don't think it's possible to activate these macros from the servers
schedular without access being present. Is this true?

Thanks

Reg

[Chris Moore]

Yes, it is true. You can't fire up Access and run a macro unless Access
is installed ;)

Reg wrote:

At present I'm running a number of macros with a schedular on my
computer to update and maintain databases within our network. All my
backends contain the tables that the macros update. But all the
backends are on servers that do not have access loaded on them. I
don't think it's possible to activate these macros from the servers
schedular without access being present. Is this true?

Thanks

Reg

--
--------------------------------------
Chris Moore
cdmwebs [at] no_spam_hotmail [dot] com
http://cdmwebs.com

[Tom van Stiphout]

On 14 Jul 2004 20:22:33 -0700, re**********@go v.ab.ca (Reg) wrote:

You need at least the runtime version installed.
-Tom.

At present I'm running a number of macros with a schedular on my
computer to update and maintain databases within our network. All my
backends contain the tables that the macros update. But all the
backends are on servers that do not have access loaded on them. I
don't think it's possible to activate these macros from the servers
schedular without access being present. Is this true?

Thanks

Reg

[Ray]

re**********@go v.ab.ca (Reg) wrote in message news:<9e******* *************** ****@posting.go ogle.com>...

At present I'm running a number of macros with a schedular on my
computer to update and maintain databases within our network. All my
backends contain the tables that the macros update. But all the
backends are on servers that do not have access loaded on them. I
don't think it's possible to activate these macros from the servers
schedular without access being present. Is this true?

Thanks

Reg

Hello Reg,

Seems to me all you need to do is make an .mdb file for every mdb
on the servers in one folder and link the tables from the servers to
the new mdb file and then run your macros in relation to the new
mdb files. This way you don't have to worry about Access not being
loaded on each of the servers.

Regards,

Ray

[Don Leverton]

Hi Reg,

I think that this could be done from any one of the workstations that has
Access installed, if I understand this correctly.
(I'm thinking that it doesn't matter HOW the data gets updated, as long as
it DOES get updated.)

1.) Use the Window Task Scheduler (on the workstation) to start up a totally
seperate, new, Access .MDB file.
2.) This MDB is specifically designed, and it's sole purpose is, to update
the tables in the backend database(s)
3.) It contains an Autoexec macro / code that updates the tables that are
stored in the backend, using the UNC file path to the backend with the
Linked Table Manager. This MDB should do it's thing, and then use
Application.Qui t to close itself when finished.
4.) I'd also consider using a DOS batch file that first uses Jetcomp (the
latest version accepts command-line parameters) to back up and compact these
files, then opens the MDB file above to do the updates.
5.) Use a .PIF file to run the .BAT file, which will allow you to use a
"Close on Exit" on the DOS window, making the whole sequence transparent to
the person who de-activates the screensaver in the morning. (Avoids the
"What the heck is this?" factor. )

All of the above is theoretical, and is also something that I am considering
for my own use.

Comments, anyone?

Don

"Reg" <re**********@g ov.ab.ca> wrote in message
news:9e******** *************** ***@posting.goo gle.com...

At present I'm running a number of macros with a schedular on my
computer to update and maintain databases within our network. All my
backends contain the tables that the macros update. But all the
backends are on servers that do not have access loaded on them. I
don't think it's possible to activate these macros from the servers
schedular without access being present. Is this true?

Thanks

Reg

[david epsom dot com dot au]

Well, theoretically the server scheduler could fire up a
remote instance of Access (installed on a workstation
somewhere) People have done that kind of thing for backup
and update. But firing up a remote instance of Access
would be a big ask: I don't think I've met anyone who
has done that before.

However, presumably the macro's just run a sequence of
update and append queries.

You don't need macro's or Access to do THAT.

What you want is VBscript, using ADO or DAO objects:

set obj = createobject("d ao.dbengine.36" )
....
db.Execute "select * from tbla into tblb ...."
....

(david)

"Reg" <re**********@g ov.ab.ca> wrote in message
news:9e******** *************** ***@posting.goo gle.com...

At present I'm running a number of macros with a schedular on my
computer to update and maintain databases within our network. All my
backends contain the tables that the macros update. But all the
backends are on servers that do not have access loaded on them. I
don't think it's possible to activate these macros from the servers
schedular without access being present. Is this true?

Thanks

Reg

[Mark]

David,

You have my interest!!

Where do I enter VBScript?
How do I execute it?
In your example code, is there anything needed preceding the Set Obj line?

Thanks for any help!

Mark
"david epsom dot com dot au" <david@epsomdot comdotau> wrote in message
news:40******** *************** @news.syd.swift dsl.com.au...

Well, theoretically the server scheduler could fire up a
remote instance of Access (installed on a workstation
somewhere) People have done that kind of thing for backup
and update. But firing up a remote instance of Access
would be a big ask: I don't think I've met anyone who
has done that before.

However, presumably the macro's just run a sequence of
update and append queries.

You don't need macro's or Access to do THAT.

What you want is VBscript, using ADO or DAO objects:

set obj = createobject("d ao.dbengine.36" )
...
db.Execute "select * from tbla into tblb ...."
...

(david)

"Reg" <re**********@g ov.ab.ca> wrote in message
news:9e******** *************** ***@posting.goo gle.com...

At present I'm running a number of macros with a schedular on my
computer to update and maintain databases within our network. All my
backends contain the tables that the macros update. But all the
backends are on servers that do not have access loaded on them. I
don't think it's possible to activate these macros from the servers
schedular without access being present. Is this true?

Thanks

Reg