Speed Up Access Backend / Frontend configuration - Is SQL the ansa?

[chrisbee]

I have a databse - backend approx 35000 reocords 50 fields per record.

The front end is stored on all the workstations that links to the Backend over the network - using simple linked tables.

How can I make this as quick as possible - would convertinf the table to SQL and linking that to the Front ends be any quicker?

Currently - even though all the relevent fields are indexed it takes too long (sometimes 5 seconds) to find a record (even without wildcards)

 

[chrissie1]

try using MSDE same engine as sql-server and can be used with access projects this would mean you would have to rewrite parts of the access frontend or you could use the upsize wizard and see what he makes of it (far from perfect).

Depends on how much users you have ofcourse.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting