scheduling access

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"patti" wrote in message
...
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

patti wrote:
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

You would have to install Access on the server.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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/ex...tributors.html
__________________________________________

"patti" wrote:

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

What's wrong with having a dedicated pc to do this task?

"patti" wrote:

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

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

patti wrote in
:

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.

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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

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

"David W. Fenton" wrote:

patti wrote in
:

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.

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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Hi Patti,

Now i am looking into deploying things in a larger environment.

Perhaps this article will be useful to you:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/mu...lications.html



Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"patti" wrote:

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

patti wrote in
:

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

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).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/