Access DB Error

I have been working on an ASP site www.middlesexccl.com on my localhost. It
uses a Access MDB and DSNless connections - no issues.

I have uploaded the site and it seems everytime I upload an new version of
the database I am given this error.

It also seems that everytime I upload I copy across a MCCL.ldb file.

can anyone offer any reasoning and advice?

Paul Smith


Microsoft JET Database Engine error '80004005'

Unrecognized database format
'D:\Webspace\middlesexccl.com\wwwroot\DB\MCCL.mdb'.

/Default.asp, line 25

Re: Access DB Error

Paul W Smith wrote:
> I have been working on an ASP site www.middlesexccl.com on my localhost. It
> uses a Access MDB and DSNless connections - no issues.
>
> I have uploaded the site and it seems everytime I upload an new version of
> the database I am given this error.
>
> It also seems that everytime I upload I copy across a MCCL.ldb file.
>
> can anyone offer any reasoning and advice?
>
> Paul Smith
>
>
> Microsoft JET Database Engine error '80004005'
>
> Unrecognized database format
> 'D:\Webspace\middlesexccl.com\wwwroot\DB\MCCL.mdb'.
>
> /Default.asp, line 25


What version of Access are you using?

Have a look at this: http://www.aspfaq.com/show.asp?id=2009

--
Mike Brind

Re: Access DB Error

Paul W Smith wrote:
> I have been working on an ASP site www.middlesexccl.com on my
> localhost. It uses a Access MDB and DSNless connections - no issues.
>
> I have uploaded the site and it seems everytime I upload an new
> version of the database I am given this error.
>
> It also seems that everytime I upload I copy across a MCCL.ldb file.

Well, this means that somebody whtat is using this database does not have
Modify permissions for the folder containing the database. All database
users need to be able to create/edit/delete that .ldb file. Unfortunately,
failure to delete the file does not raise an error.

If your site is using Anonymous access, then the IUSR, and sometimes the
IWAM, accounts require that level of permissions.

>
> can anyone offer any reasoning and advice?
>
> Paul Smith
>
>
> Microsoft JET Database Engine error '80004005'
>
> Unrecognized database format
> 'D:\Webspace\middlesexccl.com\wwwroot\DB\MCCL.mdb'.
>

See Mike's link.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Access DB Error

Many thanks - corrupt Database - compacted and repaired and we are working
again.


"Mike Brind" wrote in message
news:1143632412.045503.78410@u72g2000cwu.googlegroups.com...
>
> Paul W Smith wrote:
>> I have been working on an ASP site www.middlesexccl.com on my localhost.
>> It
>> uses a Access MDB and DSNless connections - no issues.
>>
>> I have uploaded the site and it seems everytime I upload an new version
>> of
>> the database I am given this error.
>>
>> It also seems that everytime I upload I copy across a MCCL.ldb file.
>>
>> can anyone offer any reasoning and advice?
>>
>> Paul Smith
>>
>>
>> Microsoft JET Database Engine error '80004005'
>>
>> Unrecognized database format
>> 'D:\Webspace\middlesexccl.com\wwwroot\DB\MCCL.mdb'.
>>
>> /Default.asp, line 25
>
>
> What version of Access are you using?
>
> Have a look at this: http://www.aspfaq.com/show.asp?id=2009
>
> --
> Mike Brind
>

Re: Access DB Error

Good. But why are the teams listed in reverse alpha order?!? No
reason why they shouldn't be, I suppose, but it seems a little odd.
You don't hail from Winchmore Hill, by any chance ;-)

--
Mike Brind


Paul W Smith wrote:
> Many thanks - corrupt Database - compacted and repaired and we are working
> again.
>
>
> "Mike Brind" wrote in message
> news:1143632412.045503.78410@u72g2000cwu.googlegroups.com...
> >
> > Paul W Smith wrote:
> >> I have been working on an ASP site www.middlesexccl.com on my localhost.
> >> It
> >> uses a Access MDB and DSNless connections - no issues.
> >>
> >> I have uploaded the site and it seems everytime I upload an new version
> >> of
> >> the database I am given this error.
> >>
> >> It also seems that everytime I upload I copy across a MCCL.ldb file.
> >>
> >> can anyone offer any reasoning and advice?
> >>
> >> Paul Smith
> >>
> >>
> >> Microsoft JET Database Engine error '80004005'
> >>
> >> Unrecognized database format
> >> 'D:\Webspace\middlesexccl.com\wwwroot\DB\MCCL.mdb'.
> >>
> >> /Default.asp, line 25
> >
> >
> > What version of Access are you using?
> >
> > Have a look at this: http://www.aspfaq.com/show.asp?id=2009
> >
> > --
> > Mike Brind
> >