Hi all,
I am currently trying to update a table that is in SQL Server 2000 whenever my tbale in Access 2010 gets updated.
I've read that Docmd.TransferDatabase method would work, but I need this to be timed every two minutes. For example, every two minutes Access needs to check to see if the table in Access has had new rows inserted, if it has, copy those new rows into the Table in SQL Server.
Is this something that could be done?
Many thanks in advance
I am currently trying to update a table that is in SQL Server 2000 whenever my tbale in Access 2010 gets updated.
I've read that Docmd.TransferDatabase method would work, but I need this to be timed every two minutes. For example, every two minutes Access needs to check to see if the table in Access has had new rows inserted, if it has, copy those new rows into the Table in SQL Server.
Is this something that could be done?
Many thanks in advance
