Front End Back End

[DS]

Maybe a dumb question, maybe not.
I have a split database, a frontend on one computer a backend on another
computer. Do I have to start Access on the computer where the backend
resides? Also I want a different/seperate frontend on the backend
computer that will be launched by Windows Scheduler. Won't there be 2
instances of Access running then? A little confused! Any help is
appreciated.
Thanks
DS

 

[Tom Lake]

Maybe a dumb question, maybe not.
I have a split database, a frontend on one computer a backend on another
computer. Do I have to start Access on the computer where the backend
resides?

No. Access will run on the front end computers which have the tables from
the
back end .mdb file linked in.

Also I want a different/seperate frontend on the backend computer that
will be launched by Windows Scheduler. Won't there be 2 instances of
Access running then? A little confused! Any help is appreciated.

Since the back end computer won't need to run Access to allow the front end
computers to work, there will only be one instance of Access running on the
back end computer. Even if there were two instances, it wouldn't be a
problem.
Access can do that just fine.

Tom Lake

 

[Rick Brandt]

Maybe a dumb question, maybe not.
I have a split database, a frontend on one computer a backend on
another computer. Do I have to start Access on the computer where
the backend resides? Also I want a different/seperate frontend on the
backend computer that will be launched by Windows Scheduler. Won't
there be 2 instances of Access running then? A little confused! Any
help is appreciated.
Thanks
DS

The computer where the back end is can be thought of as a remote hard drive at
the end of a long wire. All processing is on the PC where the front end is
running. Think of opening a Word doc file that is on a network share. Would
Word need to be running (or even installed) on the other computer? No. Same
concept applies here.

When the scheduler opens Access on the other computer then there will be two
instances of Access running. Just as there would be another instance of Access
running if someone else on the network opened Access. Neither have anything to
do with what might be going on with your PC.