.NET Newbie!!!

[Mighty]

Hi Folks,

I have a .Net form that I have incorporated into my ASP website. It runs in it's on virtual directory as part of my ASP website. The user selects a couple of options on an ASP form page and that is submitted to my .Net page.

This setup works perfectly well on my development machine. However, when I copied the code over to the live server, i get the following message:

The Microsoft Jet database engine cannot open the file 'd:\mydbs\myDB.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Almost every page on the ASP site accesses this DB and there are never problems. I presume that the .Net code will run as the same user as the website in which it is contained. I have added username and password to the connection string in .Net code.

Any ideas what could be causing this?

Mighty

 

[isthisthingon]

is the mydb.mdb file on the webserver in the same location as it is on your development machine?

 

[Mighty]

Yes it is in the same location. The DB is actually located on the web server at the path specified in the error message.

Mighty

 

[ca8msm]

It's most likely a permissions issue. Have you set the reevant permissions for the ASPNET account (or whichever accoun the site is running under) for the relevant folder & file?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[Mighty]

It is using the same account as every other page on the website and there are not issues with any other page.

Mighty

 

[ca8msm]

It is already opened exclusively by another user, or you need permission to view its data.

Ok, so if you've ruled out the second second problem, it must be the first. MS Access is notorious for having problems in multi-user environments and that's what makes it unsuitable for most web applications.



____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[Mighty]

But I can still go in and open any ASP page that reads from the same Db and it works fine.

Mighty

 

[ca8msm]

OK, but it's definately either a permissions error or an error opening the file; the error is there for a reason and that's what it's telling you the problem is.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ca8msm]

You could try making a copy of one of the pages that works, placing that in the new virtual directoy (alongside the file that doesn't work) and then see if the page still works. If it doesn't it kind of points more towards a permissions problem.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.