07-10-2013 07:26 PM
My server went down, and I moved my ACT database (first to another pc on the network) and LASTLY to a network external harddrive (Cat5 plugged into the router). I am trying to share it on this External HardDrive. (For the previous 10 days I had it shared from another pc, and did properly edit the PAD file in notepad so that we could all use the database from different PC Workstations.)
However, I have not been able to modify the PAD file correctly on the external HD.
I am getting error:
The database "PinkPayrollACT2013V4" could not be accessed. ...Check firewalls, etc....
I had edited the host and location in the PAD file as follows:
<ACTDatabase name="PinkPayrollACT2013V4" host="Seagate-3EC6F1" location="." type="Sql" />
The file location is under "Network": \\Seagate-3EC6F1\Public
(Possibly I do not understand the role of the the "host" being an external HD and not a proper computer/pc name as I had used previously.)
07-10-2013 09:34 PM
The database must be on a local not an external mapped drive.
07-11-2013 06:20 AM
You must keep the ACT Database on a machine that has ACT installed. Then the database must be shared out. You can't just copy the files because the program need so run SQL to dish out the data.