MS Access 97 (MS.Jet.OLEDB.4.0)
For MS Access 97, specify the database path found in the “SQL_Schema” folder. Copy this file to a share that clients can modify and select this file. Ensure to specify a remote path if using a central database. You can also specify the username and password required for the connection.
Using MS Access 97 is recommended for testing purposes only, as it allows only a single computer to fully access a given Access file. Installing MS Access on the computers is not necessary.
MS Access 2000 / XP / 2003 (MS.Jet.OLEDB.4.0)
For MS Access 2000 / XP / 2003, specify the database path found in the “SQL_Schema” folder. Copy this file to a share that clients can modify and select this file. Ensure to specify a remote path if using a central database. You can also specify the username and password required for the connection.
Using MS Access 2000 / XP / 2003 is recommended for testing purposes only, as it allows only a single computer to fully access a given Access file. Installing MS Access on the computers is not necessary.