In my company we use a quite old program made in vb6 with access 2000 database.
We use dao 3.6 to work with the database
Our server was windows 2000 and the computers were xp until some months ago when we changed to windows server 2008 64 and windows 7.
Now everything goes very slow, the program needs 30 sec. to open when it was less than 10 sec. before.
I don´t know if the problem is we have changed the operative systems in the server and the other computers or we are using WIFI in most of the computers or we should change code in the program ...
We work 8 persons with this program, I know the solution would be to change from access to sql but this would be very complex as we use dao and we have many code to change.
The database size is now 75 mb
I would apreciate any help to get the program goes faster.
these are some parts of the code of the program:
Set db = Workspaces(0).OpenDatabase(BASEpath$ & "SECRE.MDB")
Set ds = db.OpenRecordset("SELECT * FROM clients", dbOpenDynaset)
If ds.RecordCount <> 0 Then
Do Until ds.EOF
if not isnull(ds!code) then