05-14-2010 08:25 AM
I work at a University in Tech Support. 1 of our school has recently purchased ACT and we're been doing a bit of testing.
Basically we have a database set up on the C: (XP Machine) and we've taken a copy to a temp folder (just incase any files get deleted/corrupt) and we wanted to copy it to a network drive so we run a few tests and see how everything performed. However, for some reason when it comes to the .ALF and .ALP (i think) files it stops with 'Access Denied'. I've checked the permissions of the files and they seem all ok. The database folder copies fine - it's just these 2 files. I've copied the files to USB which works ok - but it just won't copy them to the network drive.
Has anyone else come across this before? Any suggestions?
05-14-2010 08:29 AM
Can can't just copy SQL files. You need to use Backup, Restore, Restore_As
See this ACT! Knowledge Base article -
05-14-2010 08:48 AM
This user is a new member of staff with us and she has used previous versions of ACT! before and has done this on many previous occasions. I have explained to her to use the Restore method as used in the FAQ but she was adamant she's done it this way before and wanted to know why it can't be done now.
Has it always been like this or is it a new feature of 2010? I'm unfamiliar with this software hence i don't want to ignore someone with lots of experience.
05-14-2010 08:59 AM
It's been that way since ACT! 2005.
If you manually stop the SQL services, you can copy the files (don't copy the PAD as it needs to be re-created), but Backup/Restore_As is much easier.
05-14-2010 09:04 AM
Thanks for the quick replies Mike, i just found it weird i could back them up to USB/other drives - just these 2 files specifically not to network drives.
I'll get her used to using the correct way.
Many Thanks, Phill
05-14-2010 09:09 AM
05-17-2010 08:31 AM
05-17-2010 08:35 AM
05-17-2010 09:18 AM