An advice needed

[kulrom]

Hi guys,

Recently i made an app and it works very well so far ... but these days i decided to extend client part's features to remote access the data stored on server machine. Actually, all i need is when my laptop PC is located out of LAN to still able update/select/delete/insert data from within MS Access DB.

 

I've been look around for some useful informations in order to resolve my issue but i found may different opinions ... some people says that i need to go for SQL Server and that it is the best and only solution ... also, some people claimed that i should go for web services as it's most adequate and simplest solution for me ... so, i'm wondering is there someone that could clarify this dilema for me please ?!

 

I'm mostly concerned about if i go for web service where this service will be stored ... do i need a Public IP address or it would work just fine from common server without registered web site? btw, i'm absolute n00b in this section/subject :(

 

I'm waiting for your sugesstions ... thanks in advance :)

 

edit: also i forgot to ask about client part. whether i need to install IIS on client machine/s as well in order to make it able to access certain MSAccess DB remotely?

Edited August 4, 2005 by kulrom

[neodammer]

Hi guys,

Recently i made an app and it works very well so far ... but these days i decided to extend client part's features to remote access the data stored on server machine. Actually, all i need is when my laptop PC is located out of LAN to still able update/select/delete/insert data from within MS Access DB.

 

I've been look around for some useful informations in order to resolve my issue but i found may different opinions ... some people says that i need to go for SQL Server and that it is the best and only solution ... also, some people claimed that i should go for web services as it's most adequate and simplest solution for me ... so, i'm wondering is there someone that could clarify this dilema for me please ?!

 

I'm mostly concerned about if i go for web service where this service will be stored ... do i need a Public IP address or it would work just fine from common server without registered web site? btw, i'm absolute n00b in this section/subject :(

 

I'm waiting for your sugesstions ... thanks in advance :)

 

edit: also i forgot to ask about client part. whether i need to install IIS on client machine/s as well in order to make it able to access certain MSAccess DB remotely?

 

 

You do not need IIS on all the client computers because IIS is server software not client software. I would figure out how to do via asp and SQL. I have done this before for a client but with php/mysql. If your just wanting to access a directory from anywhere there are my programs that can let you do that and xp has remote access (not recommended personally) that can do something similar. You can actually make an ftp server for a directory if thats indeed your goal and make your program just access the directory via ftp. There are many ways :cool:

 

Actually after re-reading your post your wanting database access not directory lol so i would go with a asp program or php thats what id do though you can still do it through other means.

[kulrom]

Ok but i still want to keep the windows app format and if it's possible at all asp.net to goes in background only ... however, thanks for the advices i really appreciate your time ;)

Is there anyone else that worked with this kind of app?

 

Thanks in advance :)