How to Connect to an Access DB remotely

[drmaves]

I have some Access Databases on my web server and would like to administer them remotely without having to have Access installed on my web server. Is there a client that will allow me to do that?

 

[Quehay]

Sure, VBScript will do that. Now do the homework...the time you spend will more than equal the cost of an Access stand-alone.


Jeff Roberts
Insight Data Consulting
Access and SQL Server Development

http://www.InsightDataConsulting.com

 

[drmaves]

It's not a matter of the cost of Access it's a matter of not wanting to install it on my web server. If you're referring to VBScript to write an interface, that's not what I'm after. I'm looking for a client that I can install and use directly. I do this with MySQL using a remote client and it works great, just wish I could do the same with Access.

 

[Quehay]

You can program Access with VB Script:

Set objAcc = CreateObject("Access.Application")

objAcc.QueryDefs.Add strSQL

etc.

How remote? WAN or HTTP? If it's WAN a copy of Access elsewhere can connect remotely.


Jeff Roberts
Insight Data Consulting
Access and SQL Server Development

http://www.InsightDataConsulting.com

 

[drmaves]

HTTP. Unfortunately I know nothing about VBScript.