I need help!!!! ......Pleeeeease teach me how to access data from the 
Access Database while the database is open for data entry???


The application has no problem when the database is closed but whenever 
the database is open for updating purposes, the web page displays this 
error

Microsoft JET Database Engine error '80004005' 

Could not use ''; file already in use. 


.............Desperately in need of help!!!!........

As far as I am aware, if the database is already open when ASP tries to
access it, you will get this error. Unless there is a Permissions thing
happening here, I don't think you can access an 'open' database. If it is
not possible to take the database offline while you update it, I think you
need to produce a method of updating the database without opening it.
Another alternative would be to have an offline database, make the updates
and then upload it to take the place of the old version. depends on how your
database/application is being used.

If this advice is wrong I apologise.

ian

----- Original Message -----
From: "Lee Shan Li" <sallyleeshanli@y...>
To: "Access ASP" <access_asp@p...>
Sent: Thursday, May 09, 2002 10:32 AM
Subject: [access_asp] Please advice......


> I need help!!!! ......Pleeeeease teach me how to access data from the
> Access Database while the database is open for data entry???
>
>
> The application has no problem when the database is closed but whenever
> the database is open for updating purposes, the web page displays this
> error
>
> Microsoft JET Database Engine error '80004005'
>
> Could not use ''; file already in use.
>
>
> .............Desperately in need of help!!!!........
>

In the page that accesses the database when you open the data base
do the retrival based on SELECT etc.  When this is complete close the
connection at the end of the page.  So what you have it open
get data, display data, close file.

While data is being diplayed, while risky you can make a change
to the data base and close it.  When you refresh the page the
above cycle repeats.  Open, get [new] data, display data, and
close file.

Access does not allow multiple usage and by the error is showing that.

I have updating completed in one data base and the main one is
used for display.  If you have it open at the time someone updates
it can present serious problems.  I check the two files and look
at dates.  When different I move the current to backup folder.
Cut and paste the updateable file and rename it to main file.

In order to do what you are trying to do I suspect you need to
look at SQL, ORACLE or a higher powered system that allows mulitple
accesses.

Regards,
Chuck


>From: "Lee Shan Li" <sallyleeshanli@y...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Please advice......
>Date: Thu, 9 May 2002 10:32:00
>
>I need help!!!! ......Pleeeeease teach me how to access data from the
>Access Database while the database is open for data entry???
>
>



http://aa8vs.dhs.org:81/aa8vs


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx