Candy Hein Consulting

You can set up a library list to use when using Access Client Solutions (ACS) to run SQL Scripts.

Open RUN SQL SCRIPTS in ACS (Access Client Solutions)

From menu bar:

Click EDIT

Click JBDC Configurations

Click ADD

Input name and description

Click NEXT button

Library List will be pre-populated with *LIBL

Insert your library (libraries) after *LIBL with each one separated by comma

Click SAVE button

To connect to system with that library list (schema list).

From menu bar:

Click CONNECTION

Click CONNECT TO DATABASE

Select System name

Select JDBC Configuration you created above

Click OK button

You will no longer need to specify library list when writing SQL statements.