Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error Accessing Vendors in Accounts Payable

Status
Not open for further replies.

Kivairu

MIS
Mar 18, 2009
106
KE
Hi am working on Accpac 5.4 and SQL database but when I try selecting vendors from invoice entry I get the following error.
Description: Vendor. Database error (operation=GET, error=308). [Microsoft][ODBC SQL Server Driver][SQL Server]Index 'APVEN_KEY_0' on table 'APVEN' (specified in the FROM clause) does not exist. Please refer this error to your database administrator or see your database documentation for further assistance.

Any help will be appreciated.
 
Your database is corrupt, there must be a back story to this, like a server crash. Try a Dbdump/Dbload to repair.
 
The server went off on its own and was restarted.That's when the problem started.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top