Remote Database Access

[Gush]

hi all,

I have an access database on a web server (say, www.a-server.com/me/database/mydb.mdb).

anyone knows what should the connection string be if I wanted to access this database from a vb application?

thanks

[BShadow]

You must have MSDE or MS SQL Server 2000 running on that machine.

If s0, you can connect to that server...
The con string I don't know right now... Sorry

[Gush]

Isn't there any way connect to a remote MS Access database?

[BShadow]

Originally posted by Gush
Isn't there any way connect to a remote MS Access database?

Sure, like I said, you need a server running... That is the only way, you need a server to connect to. YOu can not connect to nothing...

[BShadow]

And by the way, MSDE is free to install...

It's on your Office CD. That's where I got it..

[Gush]

MSDE being there will allow me to connect to my MS Access database?
Don't I have to migrate the Access DB to SQL Server? or will it work as it is?

[JMvVliet]

Take a look at the following website, where you can find All connection strings you need for ADO.

Hope this will help

[Gush]

well, I've already tried this site, but they suggest the use of the following:

If you want to use an OLE DB Provider on the remote machine

oConn.Open "Provider=MS Remote;" & _
"Remote Server=http://myServerName;" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb", _
"admin", ""

I tried that, and it didn't work, maybe it's because, as BShadow said, I don't have MSDE running on the server?
any suggestions?

[BShadow]

Originally posted by Gush
MSDE being there will allow me to connect to my MS Access database?
Don't I have to migrate the Access DB to SQL Server? or will it work as it is?

Yes, MSDE will allow you to connect to this database. And, yes you do have to migrate to SQL server database. However, doing this you can still access your database trough MS Access. You'll have to create a Access project file, link the tables and export them to MSDE. Now when you open the Access project file (in Access) you create a connection to the MSDE server and handle it like a (almost) normal Access database.

Originally posted by Gush
I tried that, and it didn't work, maybe it's because, as BShadow said, I don't have MSDE running on the server?
any suggestions?

Yes, you can invoke a connection, but there must be an other side to take the connection and provide you with the information you need...

[Briantcva]

You don't *have* to use MSDE or upgrade to SQL Server. Hell, you don't even need a server - just a folder on the network that all your users can see. Use the machine name in the connection string.

[Gush]

Originally posted by Briantcva
You don't *have* to use MSDE or upgrade to SQL Server. Hell, you don't even need a server - just a folder on the network that all your users can see. Use the machine name in the connection string.

I tried this one also, but when I did that, the whole db file was downloaded into my temporary internet files.

Anyway, thanks for everybgody's help.

[BShadow]

Originally posted by Briantcva
You don't *have* to use MSDE or upgrade to SQL Server. Hell, you don't even need a server - just a folder on the network that all your users can see. Use the machine name in the connection string.

I didn't knew that that was possible??? Please explain...

[Gush]

Originally posted by BShadow
I didn't knew that that was possible??? Please explain...

Well if I got it right, then here's what I tried.

I tried making a connection using the connection wizard in VB IDE, in the path, I put the URL. when I pressed OK, the path automatically changed to my local "Temporary Internet Files".

I think what Briantcva suggested works only on a Windows lan.

[Briantcva]

Yep - you're right - I misread the question. My apologies.