Hello,
I am have troubles accessing a secondary SQL database. I have created a couple SQL databases - one default and another custom one. I would like to add the custom database as a secondary database. However, when I am in the project properties under the Catalog Lookup File Preference title the Other File.. button is blanked out.
As far as I know, this is where I need to go to select my secondary database. I am able to access the custom database by going to Config Catalog Database on the Project ribbon but this still limits me to having only one database defined for my project.
Is there a difference between an Access Database and SQL in terms of being able to support a primary and secondary database? If this is the case does anyone have any ideas for a workaround solution? They would be really appreciated. Thanks a lot!
Brian