scheduling access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have written my vba code, tied code to macros, written my script in notepad
& used ms scheduled tasks to run things.

It works!!!

But (always a but) my accessDB is on a server, while access application,
scheduler and scripts are located on one certain pc so that pc has to always
be on. Is there a way to move all this to the server, so that it is
independent? I'm so confused i don't even know if i am asking the rght
questions. And if this is the right place to ask these questions.

thanks for any & all help.

patti
 
It's possible, although I have heard some reports of problems running Access
on a Windows 2003 server.
 
patti said:
i have written my vba code, tied code to macros, written my script in
notepad & used ms scheduled tasks to run things.

It works!!!

But (always a but) my accessDB is on a server, while access
application, scheduler and scripts are located on one certain pc so
that pc has to always be on. Is there a way to move all this to the
server, so that it is independent? I'm so confused i don't even know
if i am asking the rght questions. And if this is the right place to
ask these questions.

thanks for any & all help.

patti
Click to expand...

You would have to install Access on the server.
 
Hi Patti,

You might want to look into using this application from FMS:

Total Visual Agent
http://www.fmsinc.com/products/Agent/index.html

It is likely more robust than the code you have written (no offense
intended). It does need to be run from a PC that is always turned on, but it
can run as an NT service, so a user does not need to be logged in. I suppose
it could be installed on your server as well.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Thanks for all the input.

I have learned so much about access from this forum. Wrote my first db when
i volunteered at a hospital this year - one dept that needed help tracking
particulatr patients. 6 employees. Data pretty much self-contained. 10
tables. Queries - select, union, inner & outer joins, tabbed forms, menus...
I love access.

Now i am looking into deploying things in a larger environment. Have some
consulting work with a large firm. AccessDB used by one dept. pulling data
from many platforms. I will automate all the depts access imports, queries,
reports, etc.

I will be talking w/ the head IT guy next week. Hoping to get (& sound) more
knowledgeable about server environment.

Thanks again.

patti
 
i have written my vba code, tied code to macros, written my script
in notepad & used ms scheduled tasks to run things.

It works!!!

But (always a but) my accessDB is on a server, while access
application, scheduler and scripts are located on one certain pc
so that pc has to always be on. Is there a way to move all this to
the server, so that it is independent? I'm so confused i don't
even know if i am asking the rght questions. And if this is the
right place to ask these questions.
Click to expand...

Running things on a server is tricky. When the scheduler launches a
task, the task is assumed to run without a user interface, and that
can cause problems.

You might consider putting your script into a VBScript. VBA code is
very easy to port to VBScript, though you don't have predefined
references, so you have to figure out how to create objects that
your code can use to run the same commands.
 
Thank you David-

My code is importing tables, running queries & producing reports - trying to
cut out the user. I am leaning towards the dedicated pc until i get further
insight.

I will research VBScript. Any advice on where to start?

patti
 
I will research VBScript. Any advice on where to start?
Click to expand...

Try just pasting your code into a VBS file and running it. That
should tell you what doesn't work. At that point you'd then need to
find the ProgIDs of the apps you're automating in order to use
CreateObject. It might be easier to do that in combination with
Access and its references (i.e., use the reference dialog to find
the name of the TLB/DLL/OCX in use, then search for that in the
Registry).
 
Here is a short list of some program ID's:

+========================+=========================================+
| Office Server | CLSID Key |
+========================+========================+
| Access.Application | {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} |
+------------------------+-----------------------------------------+
| Excel.Application | {00024500-0000-0000-C000-000000000046} |
+------------------------+-----------------------------------------+
| FrontPage.Application | {04DF1015-7007-11D1-83BC-006097ABE675} |
+------------------------+-----------------------------------------+
| Outlook.Application | {0006F03A-0000-0000-C000-000000000046} |
+------------------------+-----------------------------------------+
| PowerPoint.Application | {91493441-5A91-11CF-8700-00AA0060263B} |
+------------------------+-----------------------------------------+
| Word.Application | {000209FF-0000-0000-C000-000000000046} |
+------------------------+-----------------------------------------+


Source: http://support.microsoft.com/kb/244264


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Here is a short list of some program ID's:
[snip]

Source: http://support.microsoft.com/kb/244264
Click to expand...

Those are quite easy. It's the ProgIDs for less extensive components
like the scripting host that are harder to come by. You have to
search for the executable in the Registry and then figure out which
of the various classes are the correct ProgID for what you need to
do.

There ought to be a reference somewhere, but I've never come across
it. Too bad the references dialog in the VBE doesn't display the
top-level ProgID for each library listed there.
 
Back
Top