ERROR: Run-time error '-2147467259 (80004005)': Cannot open database requested in login 'shoperccc'. Login fails
OCURANCE: While opening shoper, after you enter the username, password and select the company
CAUSE: Shoper database has become corrupt
SOLUTION:
1) Repair the corrupt database OR
2) Restore the previous working database
PRECAUTION:
Repairing the database is not always possible. It actually depends on the degree of corruption which your database has gone through.
Restoring the previous working database is the best possible option but it may cause some data loss as the last backup available would be of the last day-end. So, the transactions made today will have to be re-entered into Shoper.
Restoration of the backup is a pretty easy activity, but care must be taken to ensure that the data file path are correctly entered.
HOW TO AVOID THIS ERROR:
Database corruption usually occurs due to the two reasons mentioned below. Care must be taken to avoid their occurance which will ensure smooth Shoper operations.
1) Power Fluctuations - If your shop is in a area where there is regular load-shedding or there are voltage fluctuations, then you must use a UPS to avoid database corruption.
2) Proper Shutdown of your PC - The computer must be properly shut-down when you close during the night. Switching off the mains before shut-down or doing a PC restart when shoper is running should be strictly avoided.
