MS Access help needed corrections

[Po]

I want to connect an application from a client computer to a database on a
server who his another computer. I don't know how I can do a connection by
network to use a database on a server machine. I use SQL toolkit for Labview
6i. I guess I have to use something on ODBC administrator, but I'm not
familiarwith that.
Please help me

Eric

[Alberto]

Ok Eric,
I'll try to help you to configure the ODBC that is probably the least documented topic on NI SQL Manual.
See the file attached and let me know what you think.

[Jared 323]

Your document was very detailed and easy to follow. The attached vi does just that for you. It can be used alone or [ut it into an app to run on first boot. You wont have to worry about all those steps ever again.

Jared

[Dennis_Knutson]

For a simple Access database that has no security options, first map a drive to the server that has the database (it has to be in a shared folder). Open the ODBC administrator from Settings>Control Panel. Choose System DSN tab. Click Add. Select Microsoft Access Driver. Click Finish. Assign a Data Source Name. Click the Database Select and browse until you find the database. If your company has a network administrator or database administrator, they should be able to help with some of the details. Access 97 also has some help. Every database's ODBC driver is a little different so connecting to SQL Server, Oracle, etc. will not be the same.