Help: Best way to access a database remotely

[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.

[Mark Gambo]

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.

[fgp123]

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?

[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

[Mark Gambo]

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.

[umilmi81]

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

That or SQL Server 2005 Express. Its free now.

[fgp123]

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 ??

[Dave Sell]

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.