Distributed access?

[cedx]

Hi,

Is it possible to have an Access database located in one machine and have VB applications located in several networked machine to access this database?

If it is possible what component will do it?

Thanks in advance.


[This message has been edited by cedx (edited 08-08-1999).]

[JHausmann]

ODBC

Bear in mind Access isn't as good as SQL Server when it comes to multiple users.

[This message has been edited by JHausmann (edited 08-08-1999).]

[JohnAtWork]

Being a VB newbie, maybe I am wrong on this point, but I find having a form-driven front end in Access (with linked tables on the network in a protected database that the powerusers only have access to) seems to be a better way to go.

The protocol to allow manipulation of the data, build new queries, etc. is already there, and you won't be reinventing the wheel.

And you can still use VBA if your needs are greater than a typical Access program.

Just my $.02