Hi...

I am trying to put together a database to keep track of documents (the 
database contains multiple talbes and queries).

I was able to create the ASP to search for certain documents and their 
corresponding information, however, I have run into a problem.  The 
database is going to probably be open most of the time for updating as 
document revisions change.  However, if the database is open on the server 
and someone tries to search for a document using the ASP I keep on getting 
an error saying that the file (the database) is already in use.  

Is there something I can do to fix this?? I need to be able to have the 
actual database open as well as have users search for information on the 
web (the ASP) as well.  The only option that I have been able to come up 
with is to make 2 databases, one for data entry and a dummy database that 
has the information imported into it at certain times of the day.  I think 
that would work, but it sort of defeats the purpose of real-time 
information being available to the user.

I have been going through books and search for a solution on the web, but 
I can't seem to find anything.  Has anyone had any experience/problems 
like this.

Thanks,
Amy

Why not create a web interface for performing updates?  You would need to
secure those pages somehow to prevent unauthorized users from making
changes, but that's a fairly small bit of work.

Pete

> -----Original Message-----
> From: Amy Salsberg [mailto:amy.m.salsberg@l...]
> Sent: Wednesday, September 25, 2002 3:03 PM
> To: ASP Databases
> Subject: [asp_databases] Access & ASP in use at the same time
> 
> 
> Hi...
> 
> I am trying to put together a database to keep track of 
> documents (the 
> database contains multiple talbes and queries).
> 
> I was able to create the ASP to search for certain documents 
> and their 
> corresponding information, however, I have run into a problem.  The 
> database is going to probably be open most of the time for 
> updating as 
> document revisions change.  However, if the database is open 
> on the server 
> and someone tries to search for a document using the ASP I 
> keep on getting 
> an error saying that the file (the database) is already in use.  
> 
> Is there something I can do to fix this?? I need to be able 
> to have the 
> actual database open as well as have users search for 
> information on the 
> web (the ASP) as well.  The only option that I have been able 
> to come up 
> with is to make 2 databases, one for data entry and a dummy 
> database that 
> has the information imported into it at certain times of the 
> day.  I think 
> that would work, but it sort of defeats the purpose of real-time 
> information being available to the user.
> 
> I have been going through books and search for a solution on 
> the web, but 
> I can't seem to find anything.  Has anyone had any 
> experience/problems 
> like this.
> 
> Thanks,
> Amy
> 
> 

I was considering that, but the database itself is rather complicated.
Right now, on one entry form I have 3 tables of information that are linked
through one-many relationships (i.e., for a particular document, there may
be multiple revisions associated with that particular document).  I have
been trying to come up with a web page that would accommodate this, but so
far I haven't had any luck yet.  I am more looking for a way for both the
ASP and the database to be open at the same time.  

Is there something in the settings/options that needs to be changed for this
to work?

Amy

-----Original Message-----
From: Peter Foti (PeterF) [mailto:PeterF@S...]
Sent: Wednesday, September 25, 2002 10:44 AM
To: ASP Databases
Subject: [asp_databases] RE: Access & ASP in use at the same time


Why not create a web interface for performing updates?  You would need to
secure those pages somehow to prevent unauthorized users from making
changes, but that's a fairly small bit of work.

Pete

> -----Original Message-----
> From: Amy Salsberg [mailto:amy.m.salsberg@l...]
> Sent: Wednesday, September 25, 2002 3:03 PM
> To: ASP Databases
> Subject: [asp_databases] Access & ASP in use at the same time
> 
> 
> Hi...
> 
> I am trying to put together a database to keep track of 
> documents (the 
> database contains multiple talbes and queries).
> 
> I was able to create the ASP to search for certain documents 
> and their 
> corresponding information, however, I have run into a problem.  The 
> database is going to probably be open most of the time for 
> updating as 
> document revisions change.  However, if the database is open 
> on the server 
> and someone tries to search for a document using the ASP I 
> keep on getting 
> an error saying that the file (the database) is already in use.  
> 
> Is there something I can do to fix this?? I need to be able 
> to have the 
> actual database open as well as have users search for 
> information on the 
> web (the ASP) as well.  The only option that I have been able 
> to come up 
> with is to make 2 databases, one for data entry and a dummy 
> database that 
> has the information imported into it at certain times of the 
> day.  I think 
> that would work, but it sort of defeats the purpose of real-time 
> information being available to the user.
> 
> I have been going through books and search for a solution on 
> the web, but 
> I can't seem to find anything.  Has anyone had any 
> experience/problems 
> like this.
> 
> Thanks,
> Amy
> 
> 

Check the Advanced Tab under Tools, Options for shared and locking
information

-----Original Message-----
From: Amy Salsberg [mailto:amy.m.salsberg@l...]
Sent: Wednesday, September 25, 2002 11:03 AM
To: ASP Databases
Subject: [asp_databases] Access & ASP in use at the same time

Hi...

I am trying to put together a database to keep track of documents (the
database contains multiple talbes and queries).

I was able to create the ASP to search for certain documents and their
corresponding information, however, I have run into a problem.  The
database is going to probably be open most of the time for updating as
document revisions change.  However, if the database is open on the
server
and someone tries to search for a document using the ASP I keep on
getting
an error saying that the file (the database) is already in use. 

Is there something I can do to fix this?? I need to be able to have the
actual database open as well as have users search for information on the

web (the ASP) as well.  The only option that I have been able to come up

with is to make 2 databases, one for data entry and a dummy database
that
has the information imported into it at certain times of the day.  I
think
that would work, but it sort of defeats the purpose of real-time
information being available to the user.

I have been going through books and search for a solution on the web,
but
I can't seem to find anything.  Has anyone had any experience/problems
like this.

Thanks,
Amy

just a few ideas that sprung to mind - i'm not sure if any of these would
work (perhaps someone else knows?)

If you're using Access 2k onwards and have a controlled intranet using IE5+,
could you create an Access Data Project?

How about upgrading to SQL Server or even just MSDE (free version of SQL
Server)?  I recently upgraded a frontend/backend Access DB so as the FE was
Access 2k and the backend was SQL Server 2k - only took a few minutes and,
while it's not a perfect solution (no stored procs etc), it works fine.

I assume your data tables and frontend/interface exist in the same MDB file?
You could try separating them and, rather than linking them as is usually
done, use ADO to connect to the 'backend' database and pull your recordsets
etc out that way.  (Possibly using disconnected recordsets/GetRows etc?)
This way I imagine you wont be 'locking' the backend database.

As I said, just a couple of ideas that I haven't time to test, but perhaps
they might point you in the right direction.

HTH,
Col

-----Original Message-----
From: Salsberg, Amy M (N-Kelly) [mailto:amy.m.salsberg@l...]
Sent: 25 September 2002 16:02
To: ASP Databases
Subject: [asp_databases] RE: Access & ASP in use at the same time


I was considering that, but the database itself is rather complicated.
Right now, on one entry form I have 3 tables of information that are linked
through one-many relationships (i.e., for a particular document, there may
be multiple revisions associated with that particular document).  I have
been trying to come up with a web page that would accommodate this, but so
far I haven't had any luck yet.  I am more looking for a way for both the
ASP and the database to be open at the same time.  

Is there something in the settings/options that needs to be changed for this
to work?

Amy

-----Original Message-----
From: Peter Foti (PeterF) [mailto:PeterF@S...]
Sent: Wednesday, September 25, 2002 10:44 AM
To: ASP Databases
Subject: [asp_databases] RE: Access & ASP in use at the same time


Why not create a web interface for performing updates?  You would need to
secure those pages somehow to prevent unauthorized users from making
changes, but that's a fairly small bit of work.

Pete

> -----Original Message-----
> From: Amy Salsberg [mailto:amy.m.salsberg@l...]
> Sent: Wednesday, September 25, 2002 3:03 PM
> To: ASP Databases
> Subject: [asp_databases] Access & ASP in use at the same time
> 
> 
> Hi...
> 
> I am trying to put together a database to keep track of 
> documents (the 
> database contains multiple talbes and queries).
> 
> I was able to create the ASP to search for certain documents 
> and their 
> corresponding information, however, I have run into a problem.  The 
> database is going to probably be open most of the time for 
> updating as 
> document revisions change.  However, if the database is open 
> on the server 
> and someone tries to search for a document using the ASP I 
> keep on getting 
> an error saying that the file (the database) is already in use.  
> 
> Is there something I can do to fix this?? I need to be able 
> to have the 
> actual database open as well as have users search for 
> information on the 
> web (the ASP) as well.  The only option that I have been able 
> to come up 
> with is to make 2 databases, one for data entry and a dummy 
> database that 
> has the information imported into it at certain times of the 
> day.  I think 
> that would work, but it sort of defeats the purpose of real-time 
> information being available to the user.
> 
> I have been going through books and search for a solution on 
> the web, but 
> I can't seem to find anything.  Has anyone had any 
> experience/problems 
> like this.
> 
> Thanks,
> Amy
> 
> 




*******

This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.  If you are not the
intended recipient, please telephone or email the sender and delete this message and any attachment from your system.  If you are
not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.

For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford
Chance office.