I created a project that has a single form. I added a 2 projects that are BO Libs and one of the projects I added BO's attached to the web server database and the other project I added BO's attached to the local database. The databases have different names but the tables have identical names. I know that one of the tables on the web database is completely empty and has 100+ records locally. I use the BO assigned to the local database and simply try a me.filldatatable("Select * from bbresults") in the BO. I get no records which looks like to me it has read the table on the web server.

Is there a way to change the select to say "Select * from localdatatabase.bbresults" to force it to use the correct connection? I tried it but it said 'Invalid object name ' so maybe it is just a syntax problem. I know I have read on the forum that you can use multiple databases but I could not find how to make sure you get or save to the correct tables when they are named the exact same.

TIA.