471,855 Members | 1,596 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,855 software developers and data experts.

Sharing an access database

et
I have an aspnet program that uses an Access database -- I won't go into why
I'm using Access -- and can't get it to run in share mode.

If I have opened the website, and I try to edit the database, I get a
message saying the database is in read only because it's being used
elsewhere. Even if I close the website, close the program, close everything
I can think of, I still get the error. I always have to reboot.

If I add Mode=Share Deny None to the connection string, I get an aspnet
error that says "System.Data.OleDb.OleDbException: The Microsoft Jet
database engine cannot open the file
'c:\inetpub\wwwroot\charliesgourmetbaking\cgb.mdb' . It is already opened
exclusively by another user, or you need permission to view its data."

I have permission, I'm using the Admin logon in the connection string and
there is no password, I have never set a logon or passwords to this Access
database.

Any ideas what I can do to keep the database from being locked? It's a real
pain to make a change, run the site then I have to boot again if I want to
make another change.

Thanks & let me know if this is better in an Access newsgroup, but I think
it's an asp method to unlock Access, no?

Nov 18 '05 #1
4 1366
For Access databases, the Windows account(perhaps the anonymous acct,
depending on your security settings) will need almost complete access to the
directory where the datbase is. This is because Access uses a data file(s) to
keep track of multi-user access to the database. The account under which the
application is running will need to be able to perform the modifications,
etc., to the temporary files used by Access.

"et" wrote:
I have an aspnet program that uses an Access database -- I won't go into why
I'm using Access -- and can't get it to run in share mode.

If I have opened the website, and I try to edit the database, I get a
message saying the database is in read only because it's being used
elsewhere. Even if I close the website, close the program, close everything
I can think of, I still get the error. I always have to reboot.

If I add Mode=Share Deny None to the connection string, I get an aspnet
error that says "System.Data.OleDb.OleDbException: The Microsoft Jet
database engine cannot open the file
'c:\inetpub\wwwroot\charliesgourmetbaking\cgb.mdb' . It is already opened
exclusively by another user, or you need permission to view its data."

I have permission, I'm using the Admin logon in the connection string and
there is no password, I have never set a logon or passwords to this Access
database.

Any ideas what I can do to keep the database from being locked? It's a real
pain to make a change, run the site then I have to boot again if I want to
make another change.

Thanks & let me know if this is better in an Access newsgroup, but I think
it's an asp method to unlock Access, no?

Nov 18 '05 #2
One thing you did not close was the aspnet process that was using the
database. The next time you want this happens, do a ctrl-alt-delete and
bring up the running processes tab. Click on the Image Name column to order
the processes by name. You should see something like aspnet_wp.exe. Stop
this process.
"et" <ea*************@yahoo.com> wrote in message
news:uN**************@TK2MSFTNGP14.phx.gbl...
I have an aspnet program that uses an Access database -- I won't go into
why
I'm using Access -- and can't get it to run in share mode.

If I have opened the website, and I try to edit the database, I get a
message saying the database is in read only because it's being used
elsewhere. Even if I close the website, close the program, close
everything
I can think of, I still get the error. I always have to reboot.

If I add Mode=Share Deny None to the connection string, I get an aspnet
error that says "System.Data.OleDb.OleDbException: The Microsoft Jet
database engine cannot open the file
'c:\inetpub\wwwroot\charliesgourmetbaking\cgb.mdb' . It is already opened
exclusively by another user, or you need permission to view its data."

I have permission, I'm using the Admin logon in the connection string and
there is no password, I have never set a logon or passwords to this Access
database.

Any ideas what I can do to keep the database from being locked? It's a
real
pain to make a change, run the site then I have to boot again if I want to
make another change.

Thanks & let me know if this is better in an Access newsgroup, but I think
it's an asp method to unlock Access, no?

Nov 18 '05 #3
et
Okay, but how do I control that when I'm using a host ISP, I don't have
access to modify their user accounts.
"Brad Roberts" <Br*********@discussions.microsoft.com> wrote in message
news:A1**********************************@microsof t.com...
For Access databases, the Windows account(perhaps the anonymous acct,
depending on your security settings) will need almost complete access to the directory where the datbase is. This is because Access uses a data file(s) to keep track of multi-user access to the database. The account under which the application is running will need to be able to perform the modifications,
etc., to the temporary files used by Access.

"et" wrote:
I have an aspnet program that uses an Access database -- I won't go into why I'm using Access -- and can't get it to run in share mode.

If I have opened the website, and I try to edit the database, I get a
message saying the database is in read only because it's being used
elsewhere. Even if I close the website, close the program, close everything I can think of, I still get the error. I always have to reboot.

If I add Mode=Share Deny None to the connection string, I get an aspnet
error that says "System.Data.OleDb.OleDbException: The Microsoft Jet
database engine cannot open the file
'c:\inetpub\wwwroot\charliesgourmetbaking\cgb.mdb' . It is already opened
exclusively by another user, or you need permission to view its data."

I have permission, I'm using the Admin logon in the connection string and there is no password, I have never set a logon or passwords to this Access database.

Any ideas what I can do to keep the database from being locked? It's a real pain to make a change, run the site then I have to boot again if I want to make another change.

Thanks & let me know if this is better in an Access newsgroup, but I think it's an asp method to unlock Access, no?

Nov 18 '05 #4
et
And I never had this problem before going to .net, so I'm thinking that the
program is not closing it like it should, although I use a dispose.
"Brad Roberts" <Br*********@discussions.microsoft.com> wrote in message
news:A1**********************************@microsof t.com...
For Access databases, the Windows account(perhaps the anonymous acct,
depending on your security settings) will need almost complete access to the directory where the datbase is. This is because Access uses a data file(s) to keep track of multi-user access to the database. The account under which the application is running will need to be able to perform the modifications,
etc., to the temporary files used by Access.

"et" wrote:
I have an aspnet program that uses an Access database -- I won't go into why I'm using Access -- and can't get it to run in share mode.

If I have opened the website, and I try to edit the database, I get a
message saying the database is in read only because it's being used
elsewhere. Even if I close the website, close the program, close everything I can think of, I still get the error. I always have to reboot.

If I add Mode=Share Deny None to the connection string, I get an aspnet
error that says "System.Data.OleDb.OleDbException: The Microsoft Jet
database engine cannot open the file
'c:\inetpub\wwwroot\charliesgourmetbaking\cgb.mdb' . It is already opened
exclusively by another user, or you need permission to view its data."

I have permission, I'm using the Admin logon in the connection string and there is no password, I have never set a logon or passwords to this Access database.

Any ideas what I can do to keep the database from being locked? It's a real pain to make a change, run the site then I have to boot again if I want to make another change.

Thanks & let me know if this is better in an Access newsgroup, but I think it's an asp method to unlock Access, no?

Nov 18 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Phil | last post: by
1 post views Thread by jy | last post: by
8 posts views Thread by Kissi Asiedu | last post: by
45 posts views Thread by =?Utf-8?B?QmV0aA==?= | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.