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 |
|
associates
Starting Member
31 Posts |
 Posted - 2006-08-17 : 23:05:59
|
| Hi,I have a question to ask. I'm new to SQL Server but have been trying to learn it. I have just installed the SQL Server 2000 SP4 and have a dummy Access database that need to be migrated to SQL Server 2000 for a test. I used the DTS wizard provided by the SQL Server 2000. It was successful - no error appears. I have also successfully done the link tables from Access to SQL Server. Now, my question is how do i add/edit/delete some records in SQL Server via Access. I need your help or guidance on this.Thank you in advance |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-08-18 : 02:40:15
|
| >> Now, my question is how do i add/edit/delete some records in SQL Server via Access.Why do you want to do that with access, when you can do the same with SQL server.------------------------I think, therefore I am - Rene Descartes |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-08-21 : 11:50:19
|
| file >> open >> in the file types choose ODBC connection, and you cant take it from there.however, its better if you use Query Analyzer |
|
|
|
|
|
|
delete records in SQL Server via Access