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 |
|
hizakemi
Starting Member
33 Posts |
 Posted - 2006-05-03 : 14:09:45
|
| Guys. Possible I will be able to get a quick response.I have MS Access database-, but I cannot be able to create links, create new table to perform any update. Is it possible u can let me know what do I need to do to be able to perform update.Thk |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2006-05-03 : 14:53:51
|
| Assuming you want to link to sql server database tables, First, you need to create a DSN on the machine to connect to SQL Server.Then in Access app, choose file, Get external data, link talbes, on files of type dropdown box, choose ODBC databases, then using the DSN you created to link. |
 |
|
|
|
|
|
MS Access question