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 |
|
SQLUSERNAME
Starting Member
4 Posts |
 Posted - 2007-07-24 : 10:43:23
|
| Is there a way to link an Access 97 database to a SQL database which would update weekly as changes in the Access 97 database were made? In fact, the SQL database will be just a copy of an Access database. If there were tables added in the Access database these tables should also be added to the SQL database as well. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-24 : 13:35:11
|
| You can use dts/ssis to copy existing tables. Why don't use sql as main db server by the way? |
 |
|
|
SQLUSERNAME
Starting Member
4 Posts |
Posted - 2007-07-24 : 15:21:55
|
| SQL will be the main db soon, but first im trying to get them running together. Really what I need is for it to check if theres any new tables in Access then copy the new tables to SQL. Any code suggestions to start me off? |
|
|
|
SQLUSERNAME
Starting Member
4 Posts |
Posted - 2007-07-24 : 15:27:13
|
| Also whats ssis? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-24 : 16:30:55
|
| Integration service in sql2k5, similar to dts in sql2k. |
|
|
|
|
|
|
Update from Access