Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Amjath
Yak Posting Veteran
66 Posts |
 Posted - 2007-01-25 : 20:47:26
|
| 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 |
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-01-30 : 18:28:40
|
| Sharing data between SQL and Jet would require replication. SQL Express does not support being used as a replication publisher, so this will not work between Access and SQL Express, you would need to use one of the paid Editions, such as SQL Workgroup Edition.An alternative would be to write your own program to transfer the data between your two databases. This is a complex process when you consider handling updates from multiple users and data contention, but it's an option. There are many ways to make the connection between databases, Linked Servers is one of them, but you could also use Linked Tables in Access or just make the connection in ADO when your program is transfering data.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
 |
|
|
|
|
|
Linked Server