External Data Source for Access Data Page

[Guest]

How can I refer in Connection String of an Acces Data Page to a free hosting
web page like Geocities. I have my .MDB file in a Geocities page as well as
..htm ADP that should use the database. "Data Source=DB.mdb" does't work. When
I specify all path, it takes the database located on my computer.
Any suggestions? Thanks.

 

[Sylvain Lafontaine]

It's usually impossible to access a MDB file over the Internet; as the JET
OLEDB driver won't work directly over TCP/IP, only over a LAN. You need an
intermediate transport layer such as RDS (deprecated by Microsoft many years
ago for security reasons) or a VPN.

For Geocities, I don't know exactly but I seriously doubt about these two
possibilities. For more informations on this subject, see:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp

 

[aaron.kempf]

technically, ACCESS DATA PROJECTs work pretty well over the net.

but that's not what you're looking to do here.

you probably need to loosen up on the perms so that someone can hit the
MDB and open a record (thus creating a LDB file-- for locking info)

i just.. how complex are these reports?

you SHOULD be able to do this; but MS hires a bunch of idiots to run
ACCESS and they fire people that speak the truth

so i'd reccomend going out and using Dreamweaver or something instead.

Microsoft doesn't give a shit about databases; they've proved it over
and over again.