Interview Question in Replication


 

Interview Question :: Do anybody know about MS Access Replication


I'm using SQL Server 2000 as the backend. Need database to store on individual laptops and connection over the web as well as in the office.
Answers to "Do anybody know about MS Access Replication"
RE: Do anybody know about MS Access Replication?

If the tables in the Access db's are linked tables, you don't need to worry about replication - every time the Access database is opened, and a linked table is accessed, it is going to go out to the SQL Server and get whatever is in it at the time. If the users are going to connect from home, you will probably have to modify the ODBC connections to the SQL database on those computers.
 
Vote for this answer ::  
Update Alert Setting