I am a newbie when it comes to SQL Server databases, but I am learning by practise.



I have a database running nicely in Access 2010 which I use as my master. I have 2 other databases which I download a lot of text files daily into each one to compare yesterday's data to today's to find changes and both of these are linked to the master database via 2 linked tables and then I run updates within this database.

The database size is beginning to become big in size, so a little reading I found out I can upsize my access database to SQL server and create a ADP (Access Data Project). I have done this successfully and the data and updates can flow both ways from Sql to Access and vise versa.

My question is now, how do I handle the two linked database tables now since all the tables are in SQL now? Do I just link these two in access as per usual or is there another option within SQL?

Thanks