Search results

Thanks Mr.HightecCoach, I just happened to use the below mentioned option and Linked some tables to achieve this after lot of R&D :) So far I have just tested for 2 tables and they got updated directly in SQL Server tables using MS-Access forms :) I had tested this out on one of the Microsoft...

Hi HiTechCoach :) Thanks for the quick response. I am Not very sure, what you mean by "Note: You can use an Access front end with SQL Server" Current Architecture My_test_project.mdb is the MDB file This MDB file has 4 FORMS embedded in it. On execution, it would connect to some of the...

Hi, I am currently migrating an database application from MS-Access to MSSQL Server 2005. Details of MS-Access application Certain VB Forms has been designed within the MS-Access database. They wil be talking to some tables in the MS-Access DB and make necessary updates. What is that I have...

Hi Galixiom, I just noticed your reply in the mail thread. Thanks a lot for the real quick response. I appreciate that :) Regards Kamath

Hi, Thanks for the real quick reply. I just happened to do that yesterday itself. I used the below query to fix my issue that i was facing. Which query fixed the issue INSERT INTO Table2 (Name, Roll, Marks) SELECT Table1.Name, Table1.Roll, Table1.Marks FROM Table1; What I did to Fix the...

Hi, While writing some query i got struck What is the requirement How can I copy Data from one table to another? Table1 has about 500 rows and 25 columns(col1, col2 ....col25). I want to copy selected columns from Table1 to table 2. i.e. I wanna copy Col1, col2, col3, col5, col6, col7, col24...