I've set up a PC running a database in a warehouse.  Occasionally the database encounters a problem (not very often).  I have a link to the PCs harddrive.  Is there anyway that I can close the database down on that PC and start it up again from my PC without using some kind of remote connection software?  I was thinking of just clicking a batch file to close the database and then reopen it, however if I run it from my machine it tries to close the database then reopen it on my machine, not the PC in the warehouse.

Any suggestions?Are both machines running XP? You can use RDP to do this.Excuse the ignorance but what is RDP and how do I use it?YES both machines are XPRDP is a good choice!

you can start it like this:
"start"->"run"->type in "mstsc.exe"->"OK"Can  you tell us what's the type of you DBMSMS Access.  Front end program on the PC, back end data sits on the server. Quote from: Recall on August 27, 2008, 02:37:53 PM

Excuse the ignorance but what is RDP and how do I use it?

Batfile....rewrite the autoexe file

Quote from: merlin on August 27, 2008, 03:53:31 PM

Batfile....rewrite the autoexe file

I don't see how such a brief response can be of any help.