SD16 don't open all of a sudden

[kev67]

Hello

Anyone had this pop up that says

"SellerDeck failed to open the database DSN=ActinicSimpleShipping16.
The database may be corrupt or the version may be newer than expected.
This prevents SellerDeck working.

The error was:

Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
Driver's SQLSetConnectAttr failed

Please refer to the troubleshooting section in the MU Installation and User guide for possible solutions.

A critical problem has been encountered while accessing the database.

If using MS Access databases then this may be due to an old version of the database(s). Check the version of the databases (ActincCatalog.mdb and SimpleShipping.mdb using MS Access and if the version is older than Access 2000 then convert them to MS Access 2000 or 2007 format.

Please contact SellerDeck support if you are unable to do this. Make sure you keep a backup copy of the original database."

It was fine on June 16th and backed up fine, but today just now the above has occured

The most recent Windows 11 update I had was June 14th so I've no idea what the heck this is all about

Any advice please guru's :-)

Thanks so much

[EdHarrison]

If you have ms access try compact and repair of the mdb

[kev67]

I'll give that a try Ed, although I did do that via SD a few days before

Either way, I'll cleary try that now

And thanks for the reply as always

[EdHarrison]

Worth a go as if the database is really corrupt access will report it.

[graphicz]

I did have this issue with a client site and it didn't end well I am afraid.
This is what Gary said to me at the time:

SellerDeck failed to open the database DSN=ActinicCatalog12.....

This is sadly a quite unpredictable issue which can sometimes be recovered and sometimes cannot. You will need to contact your customer and prepare them for the fact that they may need to recover the site from their latest backup.

Firstly take their main database, open it in Access and do a compact and repair; this will recover the most simple corruption.

However if this does not work, get back to me and send the database and I will escalate it to our development staff to see if there is anything recoverable.

Kind regards,
Gary Green | Technical Support | SellerDeck

In the event development could not rebuild but it would be worth running it by support

[EdHarrison]

Can you as a last resort drop the mdb from a snap into the folder overwriting the corruption one?

[graphicz]

Much like reverting to that snapshot

[EdHarrison]

Yes but maybe a way of doing it if it cannot open to import the snapshot normally?

[Mike Hughes]

Can you as a last resort drop the mdb from a snap into the folder overwriting the corruption one?

This would be especially helpful if it's just the simple shipping database that is corrupt. It would mean you could keep using the up to date version of your site database.