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 |
|
Lin100
Yak Posting Veteran
70 Posts |
 Posted - 2006-09-22 : 01:13:00
|
| Access 2002 and SQL 2000 ServerIn an Access project file (.ADP), there is an option to import tables froman SQL Server or link tables from an SQL Server.1) Which should be use: import the tables or link the tables ?2) When I import the tables, and I made changes to one of the table, the change is reflected in the SQl Table ?3) Under what condition should an ADP file use link table instead of import table ? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-22 : 01:22:37
|
| ADP's do not hold any data. The import function you're talking about actually imports the data into SQL Server.that should answer all of your questions. |
 |
|
|
Lin100
Yak Posting Veteran
70 Posts |
Posted - 2006-09-22 : 01:47:20
|
| Thank you Timmy. |
|
|
|
|
|
|
Access ADP: import or link table