whats operatin system you use? 1.)Access 2002 is perfect than 97 no argument for it,this can be the link u using(ODBC) 2.)why u not use oledb connection string,its perfect work with vb and access,sql server 3.)how you update records? r u sure u not update any null value to fields

anyone know how to Syncronised MySql with SQL SERVER

thanx Rob, earlier i didnt see the identity increment field its appear only when we set the identity property true, thanx Rajith Alwis

i import a huge database from access to sql server 2000, in Access database there were a field which is auto increment and primery key,but when i check SQL SERVER auto increment constraint not there and im not able to change data type to unique identifier field ,how i change it to auto increment? Rajith Alwis

1.)is it Windows Authentication mode ? 2.)SQL SERVER Authentication mode ? Rajith Alwis

user : Admin ; Password :************, one that u set

using ASP.NET (C#.NET) ,try to get a result from two table s using below quary, SELECT Sum(tbl_user_earned.point_awarded) AS SumOfpoint_awarded, Sum(tbl_transaction_history.points_chash_exchange) AS SumOfpoints_chash_exchange FROM tbl_transaction_history INNER JOIN tbl_user_earned ON tbl_transaction_history.uid = tbl_user_earned.uid GROUP BY tbl_transaction_history.uid HAVING (((tbl_transaction_history.uid)=1)); i tryied to execute this using PHPMYADMIN but this not working ,i got below error #1054 - Unknown column 'tbl_transaction_history.uid' in 'having clause' -RAJITH ALWIS RAJITH ALWIS

how do i save pictures to Access database using VB6 .i used picturebox and "insert into" sql ,it saved in Access,but how i retrieve it back, pl help me peace love unity respect