Connecting to a database
Apologies in advance if this is the wrong forum.
When i try to access an access database, the server returns an error saying it can't find it and returns a path which refers to a windows machine. I'm using a mac!
Here is the code i use:
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=Movie.2000.mdb;" & "Persist Security Info=False"
( The movie2000.mdb is in the same folder as my asp page. )
The error i get is:
Microsoft JET Database Engine error '80004005'
'c:\windows\system32\inetsrv\asp\chapter12\Movie20 00.mdb' is not a valid path.
How come its returning a windows file path when the actual .mdb is located in a different place.
There is obviously something i'm doing wrong here.