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 |
|
aarahman
Starting Member
2 Posts |
 Posted - 2002-05-13 : 17:09:20
|
| I know we can link a SQL table to access. Is there anyway we can link a access table to sql server 7.0? So If I update the table in access we should be able to see the changes in SQl Server. I linked the sql table to Access tbale but I cant update the table via access. So I need a way to link the access table to SQl. Please sos.Thanks. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-05-13 : 19:30:53
|
| 1) If you're having trouble updating a table in SQL (as you mention late in your question) one of the most common issues is that there is no primary key defined on the table. There has to be one in order for Access to update it.2) You can query a table in Access from SQL Server by using a linked server. Look in BOL under OPENQUERY |
 |
|
|
aarahman
Starting Member
2 Posts |
Posted - 2002-05-14 : 09:13:12
|
| I guess I was not very clear in my first question. The problem is I have an access DB. I want to update the table in access, which I can do. The question is, is there any way we can linked that access table to SQL so we can view the change in SQL server? Please let me know.Thanks |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-05-14 : 10:46:01
|
| Check for Linked Servers in BOL.-------------------------------------------------------------- |
|
|
|
|
|
|
Linking Access 97 table to sql server 7.0