Look inlines,
>Hi,
Hi.
> I am doing a project in VB 6.0 using MS-ACCESS and SQL-SERVER as a backend and using ADO tech. in that how should I take a back - up in both cases. pls. give me an example.
I always prefer to use real backup application.
> Again, can I run Dos Commands through VB as we run in FoxPro using (!) sign e.g. !Del *.txt or by giving "Command" which takes us in the DOS.
You can use something like this
Private Sub Command1_Click()
Shell "COMMAND.COM /C del c:\*.txt", vbNormalFocus
End Sub
> Also how should I give double quotes(") in the double quotes in select clause.
If your double quotes are used has delimiter for field, you can replace them by single quotes.
> I am using a Data Grid in my project but in that when it dosen't show
>the cursor in any of its columns though it allows me to type in that
>also how should I restrict user not to enter more than a specific
>characters say user should not be able to enter more than Eight
>characters. How should I solve this Grid problems.
You can't do much while the user is inputing data. You can validate it afterwhile (using the AfterColEdit event if I remember well)!
HTH
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com