location of database

  • Thread starter Thread starter Nicole Knapp
  • Start date Start date
N

Nicole Knapp

When I embed information from a database (via the import function) on my
page, does the database need to be in the same directory as the web file?

I am trying to embed information from a database in a frame on a homepage.
I do not want to link to a new page. The information in the database is to
be changed by colleagues who do not have access to the folder where webpages
are stored.

Webpage stored in x:\folder\default.asp
database stored in u:\publicfolders\percentage.mdb

Thanks,
 
Hi Nicole,
That's perfectly fine. Usually you wouldn't put the database in the same
folder as your web pages because a database needs wider permissions (write
etc) than you'd want to give your web page folder(s)

Cheers,
Jon
 
The database needs to be within a folder that is accessible by the web site, and the database can
not be open by Access at the same time it is being accessed via a web page. You will also have to
use ASP/VBScript to access the data in the database on your web pages.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================
 
Thanks for the quick responses, but I think I need to clarify.

Webpage stored in x:\folder\default.asp
database stored in u:\publicfolders\percentage.mdb

I did add the database via the "import" function. Which copied
percentage.mdb to x:\folder.

When I update U:\percentage, it does not update x:\percentage

X is a web server, U is not. Is there another way to do this?

The data (it can be a database or a spreadsheet):

Prev Q. Current Q.
Performance 95.8 96.8
Participation 100 N/A
Alert System 99.4 99.5

The %'s change - all other info does not.

I also have access to a Sharepoint site with InfoPath (but I have to have
the information on a webpage for right now).
 
Are both the X and U drives on the same machine? If so, then create System DSN to the database on U,
then in FP under Tools | Site Setting | Database create a connection to the System DSN.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================
 
Back
Top