J
jason K
I made a access database and split the backend to network drive but if i get
a server can i run update queries on the server through the backend E.g.
When a contract is entered in to the system it run about 5-6 append Queries
and 5 update queries would it be possible to run them on a server through the
backend i was thinking of copying the queries to the back end file then
putting the backend on a server and make sure it get opened when the data
base dose, then when a contract is entered the front end just save the record
and then send a run macro command the the backend to run all the updates and
appends queries would that run on the servers cpu as the frontends run in a
Virtual machine on a mac and it takes around 30-40 sec to run the queries
some times longer if network drive has hevy load.
And i am setting up a auto email function and i need to only have one
database run it if i put it in the frontend it would run on all clients when
i need it to run once ,
a server can i run update queries on the server through the backend E.g.
When a contract is entered in to the system it run about 5-6 append Queries
and 5 update queries would it be possible to run them on a server through the
backend i was thinking of copying the queries to the back end file then
putting the backend on a server and make sure it get opened when the data
base dose, then when a contract is entered the front end just save the record
and then send a run macro command the the backend to run all the updates and
appends queries would that run on the servers cpu as the frontends run in a
Virtual machine on a mac and it takes around 30-40 sec to run the queries
some times longer if network drive has hevy load.
And i am setting up a auto email function and i need to only have one
database run it if i put it in the frontend it would run on all clients when
i need it to run once ,