Remote MS Access Database

[Guest]

Hi,

I create a small Employee Application with VB.NET. I have used MS Access
2003 as database. I want to access to MS Access 2003 via remote connection
but I don't know how to build the remote connection to database.

I have small server that has an IP address 193.168.0.10. Than I have 3 PC in
3 different room. I want all the PC (The client) to access the MS Access 2003
Database in my server.

They will retrive information from the remote database. I have also create
folder that contains user picture and this folder also in my server.

My server contains: C:\EMPLOYEE_DB\Dbank.mdb for MS Access 2003 plus
C:\EMPLOYEE_DB\IMG\ that contains 10 Employee picture.

The client machine: C:\Employee\ (VB.NET Projet files)

My question is how can access to the remote MS Access 2003 that is on my
server?
Plus how can I retrive picturethat is in my server folder and how can be
loaded in to VB.NET form that shows user pictures?

I thank you all for your kind understanding.

Rgds,
GC

 

[Cor Ligthert [MVP]]

Niyazi,

The answer is easy, you cannot, you can use a real database Server as MSDE,
SQLExpress in future instead of that.

Another posibility is using a WebService (not that difficult to do)

I hope this helps,

Cor

 

[Guest]

Hi Cor,
Thank you for your kind reply. Now I understand what should I use and I am
planing to use SQL Server 2000.

My problem is that I am having a bit trouble when I use sql connection
string as follows.

Dim ConStr As String
ConStr = "Data Source=190.168.0.10,1433;Network Library=DBMSSOCN;Initial
Catalog=DBANK;User ID=sa;Password=;"

I am having problem on DBMSSOCN (Winsock Net DLL for SQL Server).

But major concern is if I use SQL Server 2000 how can I load the picture
into database so client machine can retrive the picture on their Windows
forums?

My second question is how to use the WebServices? Is it anywhere has small
code exmaple and reading about WebServices?

Thank you.

Rgds,
GC

 

[Cor Ligthert [MVP]]

Niyazi,

My problem is that I am having a bit trouble when I use sql connection
string as follows.

Dim ConStr As String
ConStr = "Data Source=190.168.0.10,1433;Network Library=DBMSSOCN;Initial

Connection string, your server is your IP address

www.connectionstrings.com

I am having problem on DBMSSOCN (Winsock Net DLL for SQL Server).

But major concern is if I use SQL Server 2000 how can I load the picture
into database so client machine can retrive the picture on their Windows
forums?

Search for this on 'image' on our website there is a bunch any way you want
it.

http://www.windowsformsdatagridhelp.com/default.aspx

My second question is how to use the WebServices? Is it anywhere has small
code exmaple and reading about WebServices?

The best walkthrough I know on MSDN

http://msdn.microsoft.com/library/d...atingdistributedwebapplicationwalkthrough.asp

I hope this helps,

Cor

 

[Guest]

Hi Cor,

Thank you very much. Your information are very helpfull.

Rgds,
GC

 

[Paul Clement]

¤ Hi,
¤
¤ I create a small Employee Application with VB.NET. I have used MS Access
¤ 2003 as database. I want to access to MS Access 2003 via remote connection
¤ but I don't know how to build the remote connection to database.
¤
¤ I have small server that has an IP address 193.168.0.10. Than I have 3 PC in
¤ 3 different room. I want all the PC (The client) to access the MS Access 2003
¤ Database in my server.
¤
¤ They will retrive information from the remote database. I have also create
¤ folder that contains user picture and this folder also in my server.
¤
¤ My server contains: C:\EMPLOYEE_DB\Dbank.mdb for MS Access 2003 plus
¤ C:\EMPLOYEE_DB\IMG\ that contains 10 Employee picture.
¤
¤ The client machine: C:\Employee\ (VB.NET Projet files)
¤
¤ My question is how can access to the remote MS Access 2003 that is on my
¤ server?
¤ Plus how can I retrive picturethat is in my server folder and how can be
¤ loaded in to VB.NET form that shows user pictures?
¤
¤ I thank you all for your kind understanding.

There are a few ways to do this. One is to use the COM library RDS:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdhowrdstutorial.asp

Another method would be to use a web service:

http://www.freevbcode.com/ShowCode.asp?ID=4204


Paul
~~~~
Microsoft MVP (Visual Basic)