Sql server not updating

[Directlinq]

Hi im running an sql server and have set up access as a front end with 2 linked tables. I imported a delimited txt file into each of the linked tables with some vba code and it all shows up in the linked tables. But when i view the sql server in mysqlserver manager. No new entrys are in there. I go back to my linked tables and its all there. Does anybody know why my sql server is not getting the new information and how can i correct this. I need to use access and the comma delimited txt file to add my data.
Many thanks

 

[namliam]

the records do not just disappear, if they are there in the linked tables they are in the database. To double check, close your access FE, re-open and check, if they are still there, they are just there.

Make sure you are connecting to the same server and same database...