SOLVED!FIND DATABASE IN CERTAIN FOLDER

[ROBINSYN]

CAN YOU REFERENCE A DATABASE BY TELLING EXCEL TO LOOK FOR IT IN THIS FOLDER ONLY.
I NEED TO INSTALL A TEMPLATE AT 26 SCHOOLS AND USERS WILL NOT BE SAVING TO SAME LOCATION NAMES. CAN I TELL THE WORKBOOK TO LOCATE THE DATABASE AND IF SO CAN I ALSO USE THIS REFERENCE IN A FORMULA FOR FINDING THE NEXT NUMBER ON DATABASE FILE.
This message was edited by ROBINSYN on 2002-10-27 18:09

 

[zacemmel]

Can you please be so kind to turn caps lock off.

Thanks.

 

[ROBINSYN]

Sorry.

 

[zacemmel]

What type of database is it? Are the schools networked?

Questions?

http://www.excelquestions.com

 

[ROBINSYN]

No the schools are not networked. We use to be bbut our admin is streamlining supposively and we lost a great system. I have to create Purchase Order, Leave Forms, Timesheet and Budget Templates that all require a database as reference for all items saved. Each of the above is in a seperate workbook. I seriously need help but am new to excel and can not seem to find a solution to maske this transition easy.

 

[zacemmel]

Do all of these computers have internet access?

Questions?

http://www.excelquestions.com

 

[ROBINSYN]

Yes, all schools are online.

 

[zacemmel]

I would suggest setting up a centralized database on the internet with a webserver. It would make things A LOT easier. The great thing about this is, if you have the hardware, ALL of the server software is completely free These servers can handle a much bigger load than little old Excel can and are much more efficient.

http://www.apache.org
http://www.mysql.org

Take a look!

Questions?

Http://www.excelquestions.com

 

[zacemmel]

How's that research coming along?

Questions?

http://www.excelquestions.com