11-04-2010 05:11 PM
Getting this error when I try to create a new field.
Cannot find the user ‘ACTOLEDB’, because it does not exist or you do not have permission.
Have tried the fixes suggested in other forum threads such as running database repair and also running the securityCmdLnApp however nothing has fixed the problem.
Any ideas ?
Also unable to edit existing fields, however I don't get the error message when I try to edit, the changes are just ignored. My Act database must be related to my wife !
I am running ACT! by Sage Premium 2010 Version 22.214.171.124, Hot Fix 1
11-05-2010 08:06 AM
The fixes you mention normally will resolve this issue... just to double check - if the database you are accessing is on a host/server computer, the fixes will need to be applied to the server.
If you attempt to create a new database, do you get an error or is it successful?
If you open the ActDemo database and test creating a new field, does it also receive the error?
You may also be able to resolve this issue by using the Actdiag program to run Check, Repair, Rebuild Schema, Rebuild Security, and Reindex. Here are instructions for using the Actdiag utility: KB Article 19642.