We are about to upsize our database to SQL Server. There are two problems we are facing that I would appreciate your comments.
After we create the front end with the linked tables pointing to the SQL Server, I want to link to a table in another SQL database. This database will also be upsized and will contain data that will need to be replaced every month. So the questions are: 1. How do I create a link pointing to another SQL database that the one I have for the front end?
2. How to replace the data of the second SQL database when I have to? I will be taking the access table and upsize it every month. If I use the "Use existing database" on the Upsize Wizard, will this replace the data of the table I will upsize again? What happens if I want to upsize the same access database to replace some of the tables, not all?
Thank you all
After we create the front end with the linked tables pointing to the SQL Server, I want to link to a table in another SQL database. This database will also be upsized and will contain data that will need to be replaced every month. So the questions are: 1. How do I create a link pointing to another SQL database that the one I have for the front end?
2. How to replace the data of the second SQL database when I have to? I will be taking the access table and upsize it every month. If I use the "Use existing database" on the Upsize Wizard, will this replace the data of the table I will upsize again? What happens if I want to upsize the same access database to replace some of the tables, not all?
Thank you all
