SQL queries when Access is open

[Jim Bowman]

My Authorware training piece sends and retrieves data
through asp pages that are connected to an Access
database. Three asp pages use SQL SELECT, INSERT and
UPDATE statements. The data in each user record is
small: about 25 two-digit numbers.

The SQL queries fail when the Access database is open.
The error message: "Microsoft JET Database Engine
(0x80004005) Could not use; file already in use."

It would be nice if a system administrator could view
user records in the database while other people are using
the AW training piece including sending SQL queries. Is
Access unable to receive SQL queries while the database
file is open? Is there a workaround?

Thanks.

[Bob Barrows [MVP]]

Jim Bowman wrote:

> My Authorware training piece sends and retrieves data
> through asp pages that are connected to an Access
> database. Three asp pages use SQL SELECT, INSERT and
> UPDATE statements. The data in each user record is
> small: about 25 two-digit numbers.
>
> The SQL queries fail when the Access database is open.
> The error message: "Microsoft JET Database Engine
> (0x80004005) Could not use; file already in use."
>
> It would be nice if a system administrator could view
> user records in the database while other people are using
> the AW training piece including sending SQL queries. Is
> Access unable to receive SQL queries while the database
> file is open? Is there a workaround?
>
> Thanks.

It's a NTFS permissions issue. See:
[url]http://www.aspfaq.com/show.asp?id=2009[/url]
[url]http://www.aspfaq.com/show.asp?id=2062[/url]


Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bob Lehmann]

It can't be open while your asp pages are using it. You will need to create
a web interface for the Administrator to view the records.

Bob Lehmann

"Jim Bowman" <anonymous@discussions.microsoft.com> wrote in message
news:2c4a01c4286c$b690f9f0$a301280a@phx.gbl...

> My Authorware training piece sends and retrieves data
> through asp pages that are connected to an Access
> database. Three asp pages use SQL SELECT, INSERT and
> UPDATE statements. The data in each user record is
> small: about 25 two-digit numbers.
>
> The SQL queries fail when the Access database is open.
> The error message: "Microsoft JET Database Engine
> (0x80004005) Could not use; file already in use."
>
> It would be nice if a system administrator could view
> user records in the database while other people are using
> the AW training piece including sending SQL queries. Is
> Access unable to receive SQL queries while the database
> file is open? Is there a workaround?
>
> Thanks.

[Bob Barrows [MVP]]

Yes it can. As long as permissions are set correctly, it is possible. I'm
speaking from experience. I have tested asp pages that work with a database
while having that database open in Access.

Bob Barrows

Bob Lehmann wrote:

> It can't be open while your asp pages are using it. You will need to
> create a web interface for the Administrator to view the records.
>
> Bob Lehmann
>
> "Jim Bowman" <anonymous@discussions.microsoft.com> wrote in message
> news:2c4a01c4286c$b690f9f0$a301280a@phx.gbl...

>> My Authorware training piece sends and retrieves data
>> through asp pages that are connected to an Access
>> database. Three asp pages use SQL SELECT, INSERT and
>> UPDATE statements. The data in each user record is
>> small: about 25 two-digit numbers.
>>
>> The SQL queries fail when the Access database is open.
>> The error message: "Microsoft JET Database Engine
>> (0x80004005) Could not use; file already in use."
>>
>> It would be nice if a system administrator could view
>> user records in the database while other people are using
>> the AW training piece including sending SQL queries. Is
>> Access unable to receive SQL queries while the database
>> file is open? Is there a workaround?
>>
>> Thanks.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bob Lehmann]

Interesting. I've not been able to do that.

Are the permissions set differently than they normally would be for web use?

Bob Lehmann

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:#W$xLBIKEHA.3728@TK2MSFTNGP12.phx.gbl...

> Yes it can. As long as permissions are set correctly, it is possible. I'm
> speaking from experience. I have tested asp pages that work with a

database

> while having that database open in Access.
>
> Bob Barrows
>
> Bob Lehmann wrote:

> > It can't be open while your asp pages are using it. You will need to
> > create a web interface for the Administrator to view the records.
> >
> > Bob Lehmann
> >
> > "Jim Bowman" <anonymous@discussions.microsoft.com> wrote in message
> > news:2c4a01c4286c$b690f9f0$a301280a@phx.gbl...

> >> My Authorware training piece sends and retrieves data
> >> through asp pages that are connected to an Access
> >> database. Three asp pages use SQL SELECT, INSERT and
> >> UPDATE statements. The data in each user record is
> >> small: about 25 two-digit numbers.
> >>
> >> The SQL queries fail when the Access database is open.
> >> The error message: "Microsoft JET Database Engine
> >> (0x80004005) Could not use; file already in use."
> >>
> >> It would be nice if a system administrator could view
> >> user records in the database while other people are using
> >> the AW training piece including sending SQL queries. Is
> >> Access unable to receive SQL queries while the database
> >> file is open? Is there a workaround?
> >>
> >> Thanks.

>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

[Bob Barrows [MVP]]

Nope - everyone who opens the database has Change permissions for the folder
containing the database. As long as that's the case, I never have problems.

Bob Barrows
Bob Lehmann wrote:

> Interesting. I've not been able to do that.
>
> Are the permissions set differently than they normally would be for
> web use?
>
> Bob Lehmann
>
> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:#W$xLBIKEHA.3728@TK2MSFTNGP12.phx.gbl...

>> Yes it can. As long as permissions are set correctly, it is
>> possible. I'm speaking from experience. I have tested asp pages that
>> work with a database while having that database open in Access.
>>
>> Bob Barrows
>>
>> Bob Lehmann wrote:

>>> It can't be open while your asp pages are using it. You will need to
>>> create a web interface for the Administrator to view the records.
>>>
>>> Bob Lehmann
>>>
>>> "Jim Bowman" <anonymous@discussions.microsoft.com> wrote in message
>>> news:2c4a01c4286c$b690f9f0$a301280a@phx.gbl...
>>>> My Authorware training piece sends and retrieves data
>>>> through asp pages that are connected to an Access
>>>> database. Three asp pages use SQL SELECT, INSERT and
>>>> UPDATE statements. The data in each user record is
>>>> small: about 25 two-digit numbers.
>>>>
>>>> The SQL queries fail when the Access database is open.
>>>> The error message: "Microsoft JET Database Engine
>>>> (0x80004005) Could not use; file already in use."
>>>>
>>>> It would be nice if a system administrator could view
>>>> user records in the database while other people are using
>>>> the AW training piece including sending SQL queries. Is
>>>> Access unable to receive SQL queries while the database
>>>> file is open? Is there a workaround?
>>>>
>>>> Thanks.

>>
>> --
>> Microsoft MVP -- ASP/ASP.NET
>> Please reply to the newsgroup. The email account listed in my From
>> header is my spam trap, so I don't check it very often. You will get
>> a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray at]

If it's a new database that you just manually created in Access, you must
close it one time prior to being able to access it via ASP or any other
means, whether your in "design view" or not. Aside from that, it shouldn't
be an issue!

Ray at work

"Bob Lehmann" <none> wrote in message
news:ubwH5cIKEHA.3304@TK2MSFTNGP10.phx.gbl...

> Interesting. I've not been able to do that.
>
> Are the permissions set differently than they normally would be for web

use?

>
> Bob Lehmann

I gave Change permissions to one more user in the folder
containing the database. It works! I can now send SQL
queries while the db is open.

Thanks for the advice.

Jim

>-----Original Message-----
>Nope - everyone who opens the database has Change

permissions for the folder

>containing the database. As long as that's the case, I

never have problems.

>
>Bob Barrows
>Bob Lehmann wrote:

>> Interesting. I've not been able to do that.
>>
>> Are the permissions set differently than they normally

would be for

>> web use?
>>
>> Bob Lehmann
>>
>> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote

in message

>> news:#W$xLBIKEHA.3728@TK2MSFTNGP12.phx.gbl...

>>> Yes it can. As long as permissions are set correctly,

it is

>>> possible. I'm speaking from experience. I have tested

asp pages that

>>> work with a database while having that database open

in Access.

>>>
>>> Bob Barrows
>>>
>>> Bob Lehmann wrote:
>>>> It can't be open while your asp pages are using it.

You will need to

>>>> create a web interface for the Administrator to view

the records.

>>>>
>>>> Bob Lehmann
>>>>
>>>> "Jim Bowman" <anonymous@discussions.microsoft.com>

wrote in message

>>>> news:2c4a01c4286c$b690f9f0$a301280a@phx.gbl...
>>>>> My Authorware training piece sends and retrieves

data

>>>>> through asp pages that are connected to an Access
>>>>> database. Three asp pages use SQL SELECT, INSERT

and

>>>>> UPDATE statements. The data in each user record is
>>>>> small: about 25 two-digit numbers.
>>>>>
>>>>> The SQL queries fail when the Access database is

open.

>>>>> The error message: "Microsoft JET Database Engine
>>>>> (0x80004005) Could not use; file already in use."
>>>>>
>>>>> It would be nice if a system administrator could

view

>>>>> user records in the database while other people are

using

>>>>> the AW training piece including sending SQL

queries. Is

>>>>> Access unable to receive SQL queries while the

database

>>>>> file is open? Is there a workaround?
>>>>>
>>>>> Thanks.
>>>
>>> --
>>> Microsoft MVP -- ASP/ASP.NET
>>> Please reply to the newsgroup. The email account

listed in my From

>>> header is my spam trap, so I don't check it very

often. You will get

>>> a quicker response by posting to the newsgroup.

>
>--
>Microsoft MVP -- ASP/ASP.NET
>Please reply to the newsgroup. The email account listed

in my From

>header is my spam trap, so I don't check it very often.

You will get a

>quicker response by posting to the newsgroup.
>
>
>.
>