run commands and function on a backend file on server

[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 ,

 

[Sylvain Lafontaine]

No. With Access, the backend is only used as a file server and everything
else - including the queries - must be run on the local machine.

However, in your case, it's possible that your queries are lengthy because
you are missing one or more indexes in your design. Unless the Virtual
Machine running on the MAC is very, very slow, it's definitely not normal
for a couple of append queries to take 30-40 sec and more.

 

[jason K]

thanks for quick reply, i have another ? what if i make a copy of the front
end and i put on it on a server would i be able to get that to run update and
append queries and email clients on the servers cpu

 

[jason K]

thanks for quick reply, i have another ? what if i make a copy of the front
end and i put on it on a server would i be able to get that to run update and
append queries and email clients on the servers cpu

 

[jason K]

I just opened the back end file over the network and run a append query and
it worked but as i just opened it over the network it run on my computer ,
but if it is able to run queries why would it not be possible to run on a
servers cpu thanks for any replys

 

[Sylvain Lafontaine]

Copying the file to the server change nothing to the fact that the program
and the queries must run locally on your local machine; excerpt that it
should be a little slower because the forms and modules must now be copied
from the server to your machine before they can be executed.

Checking your design (primary keys, foreign keys, indexes, relationships,
etc.) is possibly the best way of making your application to run faster.

If you want to have your queries to run directly on the server, you must
either use remoting (such as Terminal Server) or to use SQL-Server.
SQL-Server 2008 Express is free but there is a lot more to say than just
switching from Access to SQL-Server.

 

[Rick Brandt]

I just opened the back end file over the network and run a append query
and it worked but as i just opened it over the network it run on my
computer , but if it is able to run queries why would it not be possible
to run on a servers cpu thanks for any replys

Because the Access *program* is running on your PC. If the server had
Access installed you could use the Windows scheduler to have it open
Access, open a file, run some code, and then close itself. As long as
YOU are opening Access on your PC then your PC is doing the work.

 

[hor vannara]

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 ,