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

Run Macros without MS ACCESS loaded

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
On 14 Jul 2004 20:22:33 -0700, re**********@gov.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


Nov 13 '05 #3

P: n/a
Ray
re**********@gov.ab.ca (Reg) wrote in message news:<9e**************************@posting.google. 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
Nov 13 '05 #4

P: n/a
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.Quit 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**********@gov.ab.ca> wrote in message
news:9e**************************@posting.google.c om...
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

Nov 13 '05 #5

P: n/a
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("dao.dbengine.36")
....
db.Execute "select * from tbla into tblb ...."
....

(david)

"Reg" <re**********@gov.ab.ca> wrote in message
news:9e**************************@posting.google.c om...
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

Nov 13 '05 #6

P: n/a
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@epsomdotcomdotau> wrote in message
news:40***********************@news.syd.swiftdsl.c om.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("dao.dbengine.36")
...
db.Execute "select * from tbla into tblb ...."
...

(david)

"Reg" <re**********@gov.ab.ca> wrote in message
news:9e**************************@posting.google.c om...
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


Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.