Updating access database with radioactive dating for middle school
Even if this has doubled let us say it is now 1 GB. I think there is an option for this both ways: Upgrade option in Access DTS into SQL SERVER.Bringing 5 tables should not be a big problem at all. Which version of SQL SERVER you are planning to upgrade to : SQL 2000 or SQL 2005 ? This is way improved over DTS, you can schedule it: updating the SSIS is much easier than a DTS.
Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.Visit Stack Exchange When you've linked an Access Database to Share Point lists, how do you make sure that saving the database updates the existing list instead of creating a new one, so that lookup columns pull from the up-to-date list?Here's the specific problem I experienced: I used the "Move To Share Point" command from Access to link the database to Share Point.Choose your site and your list in the following menus.If you edit in your opened database and save it, the changes will be published automatically to your Share Point list and no additional list is created on your site.