Hello everyone,
I have recently developped a program in VB6 using a MsAccess97 DB that
is on a network. The problem is the overall performance of the
program. I was creating a global connexion that my forms where using
to manipulate data (I was creating query with ADODB.Recordset):

Global connexion    As New ADODB.Connection
Dim strConnect      As String

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
Info=False;Data Source=" & appPath & ";Mode=Read|Write"
connexion.Open strConnect

Now I must do it again and I really need to upgrade the performance.
Furthermore, my program need to access DBF files from another program,
so I'm looking to create my new database with DBF files to have the
same type of data. So...
1-How can I create DBF files.
2-Should I keep Access DB? If yes, how can I have a decent database.
3-What other DB should I be looking for with their price.
4-Any tips on VB programming that would help.
5-Should I keep VB ?
6-How can I upgrade the overall performance?

Thanks everyone,have a nice day !