I am assigned to write a new Access 2013 application that meets the following requirements:
1. Convert Access 2000 to Access 2013,
2. Load Access 2013 table into sql server 2012 immediately,
3. Have the users enter the data via Access forms on their desktops.
The problem I see on the internet is there are no longer an Access project with the .adp nodes. Everything is now a web application. It looks like the best alternative is to use linked tables as a replacement for the Access project.
Thus can you tell answer the following questions for me:
1. What solution would you recommend that I use and why?
2. Can you give me detailed directions and/or point me to links (urls) that will tell me how to accomplish this goal?
1. Convert Access 2000 to Access 2013,
2. Load Access 2013 table into sql server 2012 immediately,
3. Have the users enter the data via Access forms on their desktops.
The problem I see on the internet is there are no longer an Access project with the .adp nodes. Everything is now a web application. It looks like the best alternative is to use linked tables as a replacement for the Access project.
Thus can you tell answer the following questions for me:
1. What solution would you recommend that I use and why?
2. Can you give me detailed directions and/or point me to links (urls) that will tell me how to accomplish this goal?