How to connect MS Access (mdb) on the server (www)

[mkrstono]

Anybody with some good idea how to connect on MS Access data base using visual basic (ocx-control).

Thanks,

Madden

[AlexTAI]

make use of ADO

Alexander Tumarov.
[email protected]
ICQ#:39711978

I am not here for rates, but rates will give me an opportunity to figure out whether my postings help or not.

[CodeBlue]

Mr. Tumarov obviously did not read your question as his answer is totally wrong. You cannot use ADO to open an MS Access file located on a www server. It cannot be done. With an internet connection, the client issues some sort of request to the server (transfer a file, open a web page, open a record, etc.) The MS Access database has no support for this type of client-server communication. You'd need to use something with server-side support to open the file, transfer records, save records, and generally control the whole data transfer process. For Windows, you'd need to have something like SQL Server on the server where the database resides.

[AnkewDude]

I totally agree with Mr.CodeBlue Dude!!... u cud use Mysql on the Web Server or sumthin dude!!

AnkewDude!

[mkrstono]

Any combination with ASP ????

[AlexTAI]

Before criticue others read the question.
1. It wasn't talked about WWW server, It was talked about just a server. It is possible to open a connection on the intranet if you have direct access without involving Client/Server architecture.
2. Look at the last posting -> He talked about ASP. So it seems that he talks about connecting to DB on the same server or on the same intranet. I want see you working with WEB project that connects to DB on the other WEB site through TCP-IP. Probably you will get a lot of Timeout errors (even if you will use SQL Server configured for TCP - it creates pretty large traffic).

Tumarov Alexander

Alexander Tumarov.
[email protected]
ICQ#:39711978

I am not here for rates, but rates will give me an opportunity to figure out whether my postings help or not.