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
Printable View
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
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
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...Quote:
Originally posted by Gush
Isn't there any way connect to a remote MS Access database?
And by the way, MSDE is free to install...
It's on your Office CD. That's where I got it..
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?
Take a look at the following website, where you can find All connection strings you need for ADO.
Hope this will help
well, I've already tried this site, but they suggest the use of the following:
I tried that, and it didn't work, maybe it's because, as BShadow said, I don't have MSDE running on the server?Quote:
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", ""
any suggestions?
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.Quote:
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, you can invoke a connection, but there must be an other side to take the connection and provide you with the information you need...Quote:
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?
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.Quote:
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.
Anyway, thanks for everybgody's help.
I didn't knew that that was possible??? Please explain...Quote:
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.
Well if I got it right, then here's what I tried.Quote:
Originally posted by BShadow
I didn't knew that that was possible??? Please explain...
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.
Yep - you're right - I misread the question. My apologies.