Speed up Access Network Program

[kennedymr2]

I need to speed up a access2000 project i have written.
The tables are very large , and when running with the .mde on a server and the forms on the local computer, it is to slow, even after trying all "tricks" i have found.

?? Will using say MYSql be able to solve the problem., and speed the whole thing up.

?? Is there a better way.

Appreciate any advice.

 

[Melagan]

Your .mde file is on a file server and your forms are on local workstations? Does that mean you created an .mde file for your tables, or are they still in .mdb format? Tables in .mde is not a very good idea because it totally takes away your option to update them, and might be contributing to the slowness over the network.

That aside, what "tricks" have you tried already?

~Melagan
______
"It's never too late to become what you might have been.

 

[kennedymr2]

I am considering converting the mde tables to MYSql on the server and using the mdb front end for the forms.

 

[JerryKlmns]

>Will using say MYSql be able to solve the problem., and speed the whole thing up.

Jet SQL engine is not as strong as mySQL - SQL Server - MSDN - Oracle - DB2 .....

So the answer is affermative as long as you create pass-through queries to get/add/delete/update records.

And and .adp (forum958) could be onother alternative to an .mdb file

 

[kennedymr2]

Thanks JerryKlmns

I will have a good look at ADP and sql server, i have overlooked this alternative.

Regards Kennedymr2