06-28-2011 12:45 PM
I was in Define Fields and creating a new field as usual, but when I hit finish, I got this message: "Cannot find 'ACTOLEDB' because it does not exist or you do not have permission. The statement has been terminated." What's that all about???
Thanks for any help.
06-28-2011 01:05 PM
You may be able to resolve this through this by running SecurityCmdLnApp.exe, it will be located in \Program Files\Act\Act for Windows or web if that's what you're running. Double click, it will open the cmd line. Once it's finished log back into the db and go to Tools -> Database Maint -> Check and Repair.
06-28-2011 01:33 PM
Ok, from the run line (Start -> Run or Windows Key+R) type 'actdiag', once it opens go to the database menu, choose database list, right click on your database. From the drop down menu choose database rebuild -> oledb reporting objects.
This may throw an error, if so post it here.
06-28-2011 01:35 PM
06-30-2011 11:00 AM
Sage ACT! Pro 2011 Version 126.96.36.199, Hotfix 1
I get the error message that this fix does not apply to my version of ACT.
I'm going to give up and uninstall on both computers, then reinstall on mine and hope it stays on mine.
06-30-2011 01:55 PM
I've un/reinstalled. Now I get this:
Unable to open the physical file "C:\Documents and Settings\All Users\Documents\ACT\ACT for Windows 11\Databases\ACT11Demo.ADF". Operating system error 3: "3(The system cannot find the path specified.)".
Database 'ACT11Demo' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
ALTER DATABASE statement failed.
File activation failure. The physical file name "C:\Documents and Settings\All Users\Documents\ACT\ACT for Windows 11\Databases\ACT11Demo.ALF" may be incorrect.
I happen to be in ACT using the DB I want, but had to trick it to find it where I wanted it.
I reinstalled it unconnected to the network, but it still looked for the DB I was using in the old location. How did iteven know the name of the DB?
I'm kind of fearless, but VERY frustrated. I have to encrypt all of this and it can't be on another computer!!! ARGH!!!