Can a VB application access a database residing on a server

[balajee]

Hi

I have a VB 4.0 application using MS Access database. Is it possible to install the application on NT Workstations and the database reside on the server? So that the changes made to the database are available to all the users.

Thanks

Balajee [sig][/sig]

 

[sdb510]

If you have the server mapped as a drive, then you can just point the VB app to the drive and directory, in the same manner as if the Access database was on the local machine.

Steve [sig][/sig]

 

[rgordley]

Another method is to create a DSN in ODBC administrator that points to the server and use the DSN to connect to the database. [sig][/sig]

 

[balajee]

Thanks

Balajee [sig][/sig]