View Single Post
  #2 (permalink)  
Old February 20th, 2004, 04:27 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

If you don't specify a path for the database, the server will assume the "current folder" which, in the case of ASP Scripts, is the System32 folder.

You can use Server.MapPath to transform a virtual location to a fixed location:

"Data Source=" & Server.MapPath("Movies2000.mdb")

this will return something like c:\inetpub\wwwroot\YourAccountName\Movies2000.mdb which is the physical location of the file.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.