access on server

[patti]

Access is installed on one server. The db is on another.
We will be using windows server to launch the batch file that will run
import macros. Do the app and the db have to be on the same server?

thanks.

patti

 

[Douglas J. Steele]

Access is installed on one server. The db is on another.
We will be using windows server to launch the batch file that will run
import macros. Do the app and the db have to be on the same server?

No. And Access doesn't need to be installed on the server: it only needs to
be on the client.

 

[patti]

Thanks for the response.

I want to run the macros independent of a pc. Is this possible? I can't
depend on the client pc always being on or not hanging on some windows issue.

And what is the file name i would look for to find that access is on the
server? Would it still be msaccess.exe? Obviously, servers aren't the
environment i usually deal with except for back ends.

patti

 

[Douglas J. Steele]

Whether it's on a server or a workstation doesn't matter: it's the same
version of Office, and the same msaccess.exe executable.

If you're running it on the server through the Scheduler, make sure that you
know the security context under which the task will be running, and that
that ID has the appropriate permissions for the folders where the front-end
and back-end mdbs reside.

 

[patti]

Thanks Doug.

The ID that you refer to, is that something with the scheduler? Someone else
is in charge of the scheduling on the server.

I was told that access was installed on a certain server but i did not see
the executable file which is why i questioned the name. I guess it's on
another server.

patti

 

[Douglas J. Steele]

I believe you can pass a user id and password to the scheduler, or you can
have the jobs run as a system id. You'll need to talk to the individual in
charge of scheduling, I guess.

 

[patti]

Thanks for the help!

patti

I believe you can pass a user id and password to the scheduler, or you can
have the jobs run as a system id. You'll need to talk to the individual in
charge of scheduling, I guess.