I've got a bit of a problem - I don't have access to my work's Web Server (and it seems I never will), so what I was thinking was to use an external web server (eg: Brinkster) to connect to an Access DB stored on my network.
I want to have something like:
Code:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=X:\SharedFolder\MyDB.mdb"
Where X: is the X: on the client computer, not on the server
I'm also wanting to connect this to a SQL Server DB, so I'd have something like:
Code:
strConnString = "Provider=SQLOLEDB;Data Source=SERVER;database=DB_NAME;uid=UID;pwd=PWD;"
Where SERVER is a server that the client has access to
Don't know if any of this is possible, but it would be nice if it was.
Any ideas?
I am a loud man with a very large hat. This means I am in charge
Connect to Client's DB
