Linked server

Hi All,
I'm using Sql Server 2005 express, what i want is?
in my requirement the LAN may disconnected for sometime for some reason what ever it may? during that time i want to store the details in MS Access database which is present in the local machine....once the LAN Connection established i want to transfer the data from MS Access to Sql Server...? IS it possible..? or otherwise i want to Sync the data between MS Access and Sql Server 2005 Express is it possible.

I'm using C# .net Desktop Application for development.

I taught of creating a linked server, Is it correct or some other things to perform to do this operation.
plz help me...

-Amjath

I don't think that the concept of a 'Linked Server' will solve your problem. You are indicating that the problem is that the link is not dependable. You indicate that you need the ability to store locally, and 'push' to the server when the server is available.

I suggest that you may find that having the application store the data locally as a 'persisted' xml dataset when the server is not available, and that the application could periodically check for server connection and 'push' the data to the server when connected. Alternatively, the data could be stored in a local Access database or even a local SQL Express database.

Storing locally in SQL Express and then using Replication might solve the problem, but it would require that the server was using SQL Standard Edition.