MS Access linked tables to sql server automatically

[jennypretty]

I created MS Access linked tables to sql server already. I got all tables I need into MS Access database from SQL Server. However, it is like a copy so all updates on SQL Server database tables will not update on MS Access database tables.

How do I make the automatic updates on MS Access database tables for all updates from SQL Server db tables?

Thanks very much.

 

[WayneRyan]

jp,

Are you sure that they are LINKED tables? If they truly are then when you
hover the mouse over the table name, you'll see the connection string.
Also, they'll have a little green arrow over them.

Wayne

 

[jennypretty]

Yes. I picked the first option which is imported, that's why.
I reset it up and picked the 2nd option and it worked fine.
thanks.