General question about client/server with VB.

[Lior]

Hi all,
I wanted to know, is there a any chance for a client/server system which uses Access database located at the server, when it's all based on the winsock control?
Is there a chance to program a similar system to the ICQ system, when its all based on the winsock control?

Thanks in advance,

[PRIVATE1]

I don't think it impossible at all .


[]P

[Lior]

Well...think about it again.
You need to be able to take any piece of information from the server effectively.
Let's say I have MyDataBase.MDB located on the server, how can I access just the 5th value at the 3rd record at the 8th field at the 12th table, without downloading the whole database.

It looks almost impossible through the WinSock.

I hope I'm wrong.

[PRIVATE1]

Simple!

Send a command to search it on the server . Why download it to the client ?

[Lior]

2 Questions:

1) Lets say I wanna get the first line of FILE.TXT
when It's located on the user's computer, I just use the Line Input method, and get it.
Can I use the same algorithm just with changing the file-path instead of C:\path\FILE.TXT into Http:\\www.mysite.com\FILE.TXT ???

2) What If I just want to update an existing file with a new record. how can I do that?
Lets say I want to add a new record into a field in a specific table. how can I do that without downloading the whole file (that might be large), updating it "offline" and the re-uploading the updated file. ???


Thanks again for your time,
Lior.

[PRIVATE1]

Originally posted by Lior
2 Questions:

1) Lets say I wanna get the first line of FILE.TXT
when It's located on the user's computer, I just use the Line Input method, and get it.
Can I use the same algorithm just with changing the file-path instead of C:\path\FILE.TXT into Http:\\www.mysite.com\FILE.TXT ???

2) What If I just want to update an existing file with a new record. how can I do that?
Lets say I want to add a new record into a field in a specific table. how can I do that without downloading the whole file (that might be large), updating it "offline" and the re-uploading the updated file. ???


Thanks again for your time,
Lior.

1) I didn't quite understand the question

2)I don't know much about databases

Sorry

[]P

[Lior]

About the first question that might not be clear enough:
Lets say I want to get the first line of a text file.
when the file is located on the user's computer, it is easy.
I just mark the path and operate some algorithm.
My question is: can I just switch the file-path into a path which just reffers to a file located on the server, and then to run the algorithm as usual?

Hope it is clear now.

[PRIVATE1]

In the server you would open the local file and read it into a string . Then just send that string .

[Lior]

That's the whole point.
I know what to do, I'm just not sure about how to do it.