Online access?

[AstonCheah]

i am not sure if access07 is able to be used in internet?

 

[Atomic Shrimp]

Any chance of a little more information to help us answer your question?

'used in internet' is hopelessly vague. What is it that you're wanting to do?

 

[Banana]

If by 'use internet' you want to use Access across WAN...

If it's an Access backend, forget about it. It's great for a office LAN, but WAN will only bring corruption and heartbreak.

For that reason, if remote access is desired, we usually look at three options:

1) Use a Terminal Server or VNC.

2) Use a RDBMS such as MySQL, Oracle, SQL Server, PostgreSQL that has a robust client library for remote access; Access is quite an excellent front-end client and works well with any of those.

3) Use replication (which is only good if you're using .mdb and do not intend to move to the new format .accdb which no longer supports this feature)

 

[AstonCheah]

i mean to use access07 program to access data from 1 place to another place through internet, is this called fr.end(1 place) and back end(another place)?

 

[Banana]

Hmm. I just want to be 100% sure if we're using the "the internet" in same sense...

By 'internet, are we talking about networked drives on a local office LAN... Maybe a computer that's in other room or other floor but in same building?

Or are we talking about a geographically distant location? You can access the folder there but it's not where you can walk to, and you have to be able to browse the web if you need to access the folder. If you can't browse the web, you can't access it either... That's what I would call WAN.


The distinction is very important because in former, we can just split the database and store it on a networked folder/drive. No problem there.

But in latter case, forget it. See my original reply.

 

[AstonCheah]

hi Banana,
sorry for the confusing question, i just learned from you what is LAN and WAN. what i mean is accessing data through WAN. one of the options you mentioned is using SQL Server, how could i do it. i will greatly appreciate if you could further explain or provide some relative website or info. thanks again.

 

[Banana]

Two starting points:

Beginning SQL Server Development
Beginner's Guide to ODBC

Both contains several links for even more references as well.

 

[AstonCheah]

thanks a lot, will look through it.

 

[dfenton]

The much easier solution is to host the app on a Windows Terminal Server (or Citrix, which is the same technology with bells and whistles).

If you choose the SQL Server/MySQL solution, you'll need to run it across a VPN, as it's very dangerous to expose a database port to the open Internet.

 

[AstonCheah]

hi dfenton,
can i store my data in my own server(i have a window server 2003 pc) and share my data through WAN?

 

[dfenton]

can i store my data in my own server(i have a window server 2003 pc) and share my data through WAN?

If that server is accessible over the WAN as a file server, it will be accessible as a Terminal Server, assuming your WAN is not firewalled to prohibit connections on the default WTS port (I don't know the actual number).