AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Logging into AyaNova Expand / Collapse
Author
Message
Posted 10/3/2005 5:59:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 11/10/2005 12:59:03 PM
Posts: 4, Visits: 8
I have re-installed AyaNova on our server after the computer where it was installed crashed. I lost our current database and restored from the last good database that we had in backup. I am getting the following messages when logging into AyaNova:

AyaNova Classic Edition 1.9.4.4

at EX standard:
CSpView: Unspecified error,
Operation must use an updateable query.
Query: UPDate users SET users.mail-True WHERE (((users.id)=23));


at EXStandare:
STATCBRS: Unspecified error,
Operation must use an updateable query.
Query: UPDate users SET users.mail-True WHERE (((users.id)=23));

James Chance,

jec@arilion.com

Post #141
Posted 10/3/2005 6:07:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 11/10/2005 12:59:03 PM
Posts: 4, Visits: 8
I am also getting this third message

at EX Standard:
CDBUtils (RS): unspecified error;
Operation must use an updateable query.
Query: UPDATE defaults SET defaults.last main date=#10/03/2005#;

Then it opens to the work order list.

When trying to add a new work order, we get the following message:
CWOHeader Dlg(RS): ISispatch error #3081,
Cannot update, Database or object is Read-only/\.

Cannot create new work order.



James Chance,

jec@arilion.com

Post #142
Posted 10/3/2005 6:13:41 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 4:59:45 PM
Posts: 1,868, Visits: 4,328
This error message can also be found answered on the old version AyaNova CE Technical Answers web page http://www.ayanova.com/AyaNovaCE/faq_technical.htm under Errors and Issues Installing AyaNova.

This occurs when the user logged into the network on this computer does not have full rights to the AyaNova database folder and files.

Review the AyaNova CE QuickStart Guide installation information regarding installing in a network environment. The AyaNova CE QuickStart Guide is available from http://www.ayanova.com/AyaNovaCE/manual.htm

You can confirm this also by logging into the computer itself as the network administrator, and than logging into AyaNova. As the network administrator has full network rights, this error would not occur.

Edit the rights of this network user so that they have full rights (read / write / create / delete ) to the AyaNova database folder and files.

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #143
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 8:03am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 10 queries. Compression Disabled.