MS access issues

Customer Support Database Support
1

I’ve been getting VERY frequent Access errors on a few of my existing sites.
these are site that have been running for a good while w/o changes, so its not me. the errors (see below) are temporamental - appear and then disappear again (support, conincadentally, never seems to see the error - but i am getting cmplaints and more complaints from customers.

am i alone?

[CODE]Microsoft JET Database Engine error ‘80004005’

Unspecified error

/aish.asp, line 31 [/CODE]

PS: the error line points each time (on any of the sites) to the connection line to the Access db.

2

Hi,

Just a suggestion …

Do u have some extra space in disk quota - cos when multiple connections are made to access - it creates a shadow file …

The shadow file takes more disk space - and if ur running neck neck to ur disk quota - it at times gives the kinda error ur mentioning.

Thanx,
Ani

3

we have lots of spare space for the sites that are suffering.
i dont know about any shadow files, but here are not any LDB files.

4

silly thing but do a compact and repair, and also check the connection string, has it worked before?

5

yep, been working for ages…

weird thing is that its intermitant - not constant

6

Yep … was talkin abt lbd files.

Try reparing ur file … or for r and d - try a different connection methodology.

And any time - when a access db gets a successful connection - a shadow - lbd file automatically get generated. If a lbd file is not getting created - then … try a different connection method.

U using DSN now or Path Based ???

Thanx,
Ani

7

Also - at times Server.MapPath - causes some problems … u cud use D:/Hsphere/account/domain/dbdir/dbfilename … it helps !!! …

Wiered - but we’ve faced such a problem in the past and that’s how we’ve been able to solve it !!! …

Thanx,
Ani

8

yes, thanks ani - i already do use absolute path-based dsnless strings.

Deepak seems to say it was an issue in their side, but maybe i will repair just in case.

thanks

9

Oh … Okie …

Anyways - try server.mappath or the physical path !!!

Should help :slight_smile:

Ani