Can I open an Access db on our WEB site from desktop

[DougP]

this is a script on my desktop

   Dim db 
   Dim strDbName
   
   'strdbName = "\\servero2\data files\task order\Notification Letter Data_be.mdb" < this works in testing from our server
   strdbName = "[URL unfurl="true"]http://xxx.xxx.xxx.xxx/fpdb/Notification[/URL] Letter Data_be.mdb"
   Set acc = createobject("Access.Application")
   
   acc.Visible = True

   Set db = acc.DBEngine.OpenDatabase(strDbName)
   acc.OpenCurrentDatabase strDbName

here is what it says

C:\Documents and Settings\dposton>upload.vbs
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

C:\Documents and Settings\dposton\UpLoad.vbs(12, 4) DAO.Workspace: Not a valid f
ile name.

Of couse I am using the correct IP, I think


DougP
< I Built one

http://www.robots2000.com

 

[EBGreen]

Accessing the file via the HTTP protocol is not at all the same thing as accessing via a file share. You will need to get file level access to the file I believe.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]