Print Page | Close Window

database corruption

Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=325
Printed Date: March/18/24 at 11:32pm
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com


Topic: database corruption
Posted By: jenny
Subject: database corruption
Date Posted: March/24/05 at 7:52am
Hi,

I am wondering if anyone else has had a problem with their database going corrupt and unable to be repaired.

This time my customers receive this error when trying to link to a .asp page or when I try to establish a connection in frontpage under site setting:

Server error: Unable to connect to a database from the web server using the connection string 'DSN=Salescart1;DRIVER={Driver do Microsoft Access (*.mdb)}'.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

This is the error I receive when trying to access my local copy of my shop.mdb:

Microsoft accesss cannot open this file. The file is located outside your intranet or an untrusted site. Microsoft access will not open the file due to potential security problems. To open the file copy it to your machine or an accessible network location.

Any ideas?

Thanks,

Jenny



Replies:
Posted By: jenny
Date Posted: March/24/05 at 11:58am
I finally just replaced the shop.mdb file with a fresh copy and my site is up and running again with a loss of my previous database. I am using Microsoft Access 2002 and the database was created in access 2000. Does this have anything to do with it?

I am still running into the following error:

Microsoft accesss cannot open this file. The file is located outside your intranet or an untrusted site. Microsoft access will not open the file due to potential security problems. To open the file copy it to your machine or an accessible network location.

I have referred to microsofts kb article # 303650


Posted By: jenny
Date Posted: March/24/05 at 4:39pm
Turns out microsoft kb#891818 takes care of this problem


Posted By: fyz123
Date Posted: May/08/08 at 7:44am
Hi,

I think you can try a utility called http://www.datanumen.com/aar/ - Advanced Access Repair to repair your Access MDB file. It works rather well for my corrupt Access MDB files.

Hope this still can help in the future.

Alan


Posted By: admin
Date Posted: May/08/08 at 4:34pm
DRIVER={Driver do Microsoft Access (*.mdb)}'.
is not the US language driver...its an off language driver.   You should be using the English driver.

Basically Access has limitations and if you are running into problems where the database is getting corrupt, you are exceeding the limits of access. About the best you can do is 4 simulatenous connections and less than 10,15K records. Anymore than that, and Access goes bust. You need to use SQL with SalesCart.

Also, make sure and never open an Access database that is currently "online"....always make a copy. If you access it during a live Internet application is running on it, it will corrupt.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.04 - http://www.webwizforums.com
Copyright ©2001-2015 Web Wiz Ltd. - http://www.webwiz.co.uk