|
-
Nov 1st, 2001, 10:46 AM
#1
Thread Starter
PowerPoster
Data Access Page in VBA for MS Access
I have successfully created a DAP in Access 2000 but I can't get it to point to the db on a server, except as a local file. That is, if I tell the DAP that the Data Source MDB file is at "C:/ ... " on the server, then it works just fine, but then the DAP can't be used over the internet, and if I tell the DAP that the Data Source is "//802.23 ... " then the DAP comes up over the internet but won't connect to the MDB file. I get a message saying "invalid path" & I've tried every path construct I can think of with no joy.
Other files on the same server are readily accessible using similar paths, but they have the "http:" at the start --- I've also tried this in the DAP but it doesn't work either.
SO ... my question is how the dickens do you get a DAP on a server to point to the db on the server so the DAP can be used over the internet?
thanks for any help.
Paul Hinds
-
Nov 5th, 2001, 08:54 AM
#2
Check MSDN to see what you can find on a Data Access Page.
http://msdn.microsoft.com/
-
Nov 5th, 2001, 08:39 PM
#3
PowerPoster
I reckon you'll need to post in ASP forum this seems like an ASP problem!
I think the DAP was only designed local intranets i dont think you can tell it too access using an ip address wihtout knowing some ASP and altering the code!
I'm sure Sastraxi or JoshT may know!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|