Remote Connection to mdb Database?

Hot Topic

Delta file copy - How
SqlDateTime overflow.
problem of controls array in Visual Basic 2005
Fill Table Adapter
Remove Registry Keys when uninstalling my application
Importing Attachment name into Access table
Can't kill Excel.Exe after using Excel component in vb.net
Saving Records query
Why not 'Unsafe'?
Urgent help needed

Visual Basic

A program is trying to send e-mail on your behalf. Stop this message.
What Language to Use
txt files
Creating Combinations
Integrating .Net into a VB6 client
How to link buttons and textboxes, to do the same thing?
Help a newbie :)
OTP: How to Get BIOS Information by using QuickBasic (QBasic) ?
Using IsNullOrEmpty and SelectedValue
VB .Net Express ? (not VB 2005)

Remote Connection to mdb Database?

I'm looking for a way to connect to a remote access database located on a web server (ie. http://www.blah.com/database.mdb) I have using VB2005 and this is for a windows application not asp.

So far I'm having zero luck... If anyone has any info on how to do this or another way to access a database(of any kind) on the web I would greatly appreciate any and all info you can provide.

This is the only thing holding me back from completing my program.

Answer this question

Remote Connection to mdb Database?

  • Kevin Hoffman

  • Mystret

    Well I managed to get a little farther but now encountering an odd error message... when I try to create the data source i get the following error:

    "The underlying enumerator did not support enumerating objects of type "Table".

    I have no clue as to what that is trying to tell me... however, in the server explorer I am able to connect to the database when I choose "Test Connection" but it won't list any tables.

    Here is the connection string i'm using:

    Provider="MS Remote";Data Source=dbname.mdb;Remote Server=http://www.website.com;Remote Provider=Microsoft.Jet.OLEDB.4.0

  • perrs

    Check it: http://www.vbforums.com/showthread.php p=2223896

    Seems to do what you want


  • GMS0012

    VB2005 doesnt seem to like that code very much and even if it did, I'm not sure how to convert my current connection(that is a local database) to the remote connection... I have all my databinds setup to that database already so I just need to change the connection string to a remote connection which after reading that, I'm still not sure how to do.

    Thanks for the help... I may try to play with it a bit but if you or anyone else has any means of just modifying the current connection in that manner, let me know.

  • Solent

    Rathlar:

    Yes, there are alternatives!

    You could use a SQL-Server database and access it through port 1433. But it is dangerous from a security point of view.

    The best way to do what you want is through Web Services. Assuming t6hat you are interested purely in CRUD (Create, Read, Update, Delete) operations over the net you can create WebService procedures that pass rowsets back in the form of Datasets. You could do batch updates by passing the dataset back to the WebService. You could also do individual Row operations in a similar manner.

    Ibrahim


  • Zion_zii

    thanks for the help people... I actually used a different alternative, remote mySQL connection... app is finished now and running beautifully.
  • Remote Connection to mdb Database?
Answer this question