1.i have 4 MS access MDB(Forms with Tables).
2.my requirement is need to Consolidate DB and keep all the Forms in Single MDB.Tables needs to migrate in SQL Server 2008.
3.currently i am using ADP Approach to Connect MSaccesss to sql server in this approach all tables which are there in SQL Server are listed in MS Access.i need to prevent this(None of the tables to be displayed in MS Access)
4.one more thing i need to know where to keep connection string in common place for through out this application
suggest which is the best approach to connect MS Access to sql server(Tables should not be listed in MS Access)