Posted by Erland Sommarskog on 10/02/15 11:43

(johnrou@ci.green-bay.wi.us) writes:
> Here's a problem that I can't find anyone else has run into. I'm using
> Access and SQL Server, but the theory would be the same for any db.
>
> I have a large number of tables that contain linked records
> (intersection tables mostly). In the interest of space, I'll
> illustrate an example:
>
>
> tblStudents (ID, Name)
> tblTeachers (ID, Name)
> tblClasses (ID, Name)
> tblEnroll (StudentID,ClassID,TeacherID)
>
>
> I have about 10 people who each use a separate
> copy of this database (in access). I want them (at the end of each
> day) to be able
> to update all the records that they entered that day into a database
> that I have setup on a server (SQL Server 2005). Both databases have
> the exact same structure.

Sounds like you investigate replication. This is not my area, so I
can't give any details, even less any that includes Access. You might
want to ask in microsoft.public.sqlserver.replication for more details.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]