http://forum.salescart.com/forum/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 06:36:49 +0000 Thu, 08 May 2008 16:34:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 forum.salescart.com/forum/RSS_post_feed.asp?TID=325 http://forum.salescart.com/forum/forum_images/web_wiz_forums.png http://forum.salescart.com/forum/ http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=2504&title=database-corruption#2504 Author: admin
Subject: 325
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.

Edited by admin]]> Thu, 08 May 2008 16:34:54 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=2504&title=database-corruption#2504 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=2500&title=database-corruption#2500 Author: fyz123
Subject: 325
Posted: May/08/08 at 7:44am

Hi,

I think you can try a utility called 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
]]> Thu, 08 May 2008 07:44:54 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=2500&title=database-corruption#2500 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=1162&title=database-corruption#1162 Author: jenny
Subject: 325
Posted: March/24/05 at 4:39pm

Turns out microsoft kb#891818 takes care of this problem ]]> Thu, 24 Mar 2005 16:39:08 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=1162&title=database-corruption#1162 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=1161&title=database-corruption#1161 Author: jenny
Subject: 325
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]]> Thu, 24 Mar 2005 11:58:44 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=1161&title=database-corruption#1161 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=1158&title=database-corruption#1158 Author: jenny
Subject: 325
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]]> Thu, 24 Mar 2005 07:52:22 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=325&PID=1158&title=database-corruption#1158