Help: Best way to access a database remotely

I was useing data enviroments to access a database on the work LAN.

Now the rules have changed, the database is gogin to be situated off premises and not on the lan, therefore i need to have access to an access database over the net.

Any idea on how to go about this and the best meathod. The databse will be being changed often, i need to keep the main off site database updated by the users in the work place useing my program.

Quote:

---

Originally Posted by fgp123

I was useing data enviroments to access a database on the work LAN.

Now the rules have changed, the database is gogin to be situated off premises and not on the lan, therefore i need to have access to an access database over the net.

Any idea on how to go about this and the best meathod. The databse will be being changed often, i need to keep the main off site database updated by the users in the work place useing my program.

---

I use ADO to connect to my remote databases. Take a look at the two ADO examples in my signature.

Quote:

---

Originally Posted by Mark Gambo

I use ADO to connect to my remote databases. Take a look at the two ADO examples in my signature.

---

You can use ADO to access a Access Database file over the net?

Yes you can, however the data will take longer to arrive, and you may get timeout errors.

To avoid this kind of problem (depending on which DBMS you are using + licencing costs), you could have a local copy which is replicated to/from the remote DB.


Here is an example of working with an Access database over the web: http://www.vbforums.com/showthread.p...96#post2223896

Quote:

---

Originally Posted by fgp123

You can use ADO to access a Access Database file over the net?

---

I have never used Access 'across the wire' but after a quick Google Search it apparently is possible:

- use an XML Web Service via SOAP Toolkit or ASP.NET
- upgrade to SQL Server and use an IP connection string
- use an ADO URL with a remote ASP web page
- use a MS Remote or RDS connection string

I would recommend upgrading to MySQL especially if you intend on having multiple users.

Quote:

---

Originally Posted by Mark Gambo

I would recommend upgrading to MySQL especially if you intend on having multiple users.

---

That or SQL Server 2005 Express. Its free now.

Quote:

---

Originally Posted by si_the_geek

Yes you can, however the data will take longer to arrive, and you may get timeout errors.

To avoid this kind of problem (depending on which DBMS you are using + licencing costs), you could have a local copy which is replicated to/from the remote DB.


Here is an example of working with an Access database over the web: http://www.vbforums.com/showthread.p...96#post2223896

---

thank you for the information guys, im not 100% on various SQL products and licences. ive just been working on your basic Acess databases so far.

What would i need to get in order to use this over the net, is there a inital cost and is there a continueing service charge for this stuff ??

MySQL is free forever afaik. SQL Server 2005 Express sounds free but i dunno for how long. SQL Server Standard is costly and you have to buy licenses per machine or per user.

Since you entered the world of doing-really-cool-things-with-databases, I would dump access in the trash and get on board with a regular RDBMS like MySQL.