Access 2003 and ASP.net, VB.net problem

[Judge Eagle]

I have a laptop running XP pro. I have visual studio.net on it. I have
office professional 2003 on it. I created an Access database. I created an
ASP.net page using VB.net. The page loads. When I go to load the datagrid,
I get a message saying that the database is either open by another
application or that I don't have rights to it. Nothing else is open. The
rights in Access show Admin and Users. Can anyone tell me what is wrong. I
tested the code with another database on a desktop running regular XP, and
everything worked fine.

 

[Brendan Reynolds]

You have to give the ASPNET user account read and write permission on the
folder that contains the MDB. This is an OS account and OS permissions, not
to be confused with Access accounts and permissions.

 

[Judge Eagle]

Brendan, thanks for responding. How do I do this? And any thoughts why my
laptop needs this done, but I don't have the problem with my desktop. I
didn't do anything on my desktop. The only difference is one is XP pro, the
other is just XP home edition.

 

[Brendan Reynolds]

On my system I can assign permissions by right-clicking on a file or folder
and choosing 'Sharing and Security' from the pop-up menu. I think the
details may differ depending on how your system is configured, though. If
you get stuck, try asking in an ASP.NET, IIS, or Windows XP newsgroup.
Someone in one of those groups can probably give you a better answer than I
can.

 

[Norman Yuan]

Are you saying that you can do AST.NET on your WinXP Home desktop? Unless
you installed third party ASP.NET-able webserver, you cannot. XP Home does
not come with IIS which is required to run ASP.NET.

Regardless, when doing ASP.NET project, you need to learn some basic ASP.NET
security, at least to know which user account is exactly running the ASP
process. Without such very basic knowledge, IMO, doing ASP.NET is a
dangerous business unless the ASP.NET project is only used by single user on
single computer.

As for your problem, as Brendan points out, you need to give the running
user account (ASPNET, by default) access permission (read/write) to the
*.mdb file, because the database is a file base database. It has nothing to
do with Access itself. The data in the *.mdb file is processed by JET
engine, which comes with all versions of Windows. Once you know more about
ASP.NET security, you have your ASP.NET project run under a user account of
your choice, which may have different privilege to the resources on the
computer from the ASPNET account.