I have a simple question that I cannot find the answer to.  It may be that I

have a design issue when I set up our Intranet Web page.  In a

nutshell.....I have two access databases -" ComputerMainenance" and

"PhoneDirectory".  I would like them to share a common table

"tblMasterUsers".  When I open the PhoneDirectory database and try to

connect to the linked table and try to view the contents I receive  the

error - 



"Microsoft JET Database Engine error '80004005' 

The Microsoft Jet database engine cannot open the file

'\\Zip\CraigIntranet\database\ComputerMaintenance.mdb'. It is already opened

exclusively by another user, or you need permission to view its data"

I do not have the database open nor does anyone else in our company

So before trying to "fix" this error myself - I would like some simple

advise.  Should I not have two separate databases, therefore throwing all my

data tables into a single database?  We are planning to purchase SQL Server

- would going to SQL solve the problem?   Currently I run a routine that

copies the table from the source to the destination, but that is giving me

all kinds of trouble in and of itself.

Thanks in advance for your help

-----------------------------------------------------------------------

David C. Mellick

Research Associate

Craig Hospital		 

3425 S Clarkson	 

Englewood, CO 80110	 

www.craighospital.org

ph:303.789.8563

fx:303.789.8441

This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C17216.78A6A55E

Content-Type: text/plain;

	charset="iso-8859-1"



> Should I not have two separate databases, therefore throwing all my

data tables into a single database?



As a rough rule of thumb Access has 'issues' with more than 10 concurrent

users. If the 2 databases also have people accessing them outside the

website this could become an issue. Eg in db1 currently has as approximate

load 3 users from an app outside of the website and db2 currently has 5

users outside of the website. The website has 4 users. This would give you 7

users for db1 and 9 users for db2. If you rolled them up into one database

this would give you a total of 12 users. If the database is only used in the

website then the only issue is upper limits on the sizes of databases for

access. They may not come into play for you. 



> We are planning to purchase SQL Server

> - would going to SQL solve the problem?



Yes. Moving from a toy (Access) to a real database (SQL Server) is an

excellent option.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: Mellick, Dave [mailto:DMellick@C...]

Sent: Wednesday, 21 November 2001 12:53 AM

To: ASP Databases

Subject: [asp_databases] Linking Tables in Access





I have a simple question that I cannot find the answer to.  It may be that I

have a design issue when I set up our Intranet Web page.  In a

nutshell.....I have two access databases -" ComputerMainenance" and

"PhoneDirectory".  I would like them to share a common table

"tblMasterUsers".  When I open the PhoneDirectory database and try to

connect to the linked table and try to view the contents I receive  the

error - 



"Microsoft JET Database Engine error '80004005' 

The Microsoft Jet database engine cannot open the file

'\\Zip\CraigIntranet\database\ComputerMaintenance.mdb'. It is already opened

exclusively by another user, or you need permission to view its data"

I do not have the database open nor does anyone else in our company

So before trying to "fix" this error myself - I would like some simple

advise.  Should I not have two separate databases, therefore throwing all my

data tables into a single database?  We are planning to purchase SQL Server

- would going to SQL solve the problem?   Currently I run a routine that

copies the table from the source to the destination, but that is giving me

all kinds of trouble in and of itself.

Thanks in advance for your help

-----------------------------------------------------------------------

David C. Mellick

Research Associate

Craig Hospital		 

3425 S Clarkson	 

Englewood, CO 80110	 

www.craighospital.org

ph:303.789.8563

fx:303.789.8441





 




$subst('Email.Unsub')