Try going into the Linked table manager and refresh all the tables. Also, where are the linked tables residing? Are they properly indexed?
--- In [email protected], Mahesh kumar <[EMAIL PROTECTED]> wrote: > > Hi , > > Can anybody help me...its urgent. > > I have application (GUI Form) developed in Access'97. Which uses linked database tables. This form is to pass on parameters to queries based on linked tables. When user enters the parameters from form, it is generating one report using linked table. This is fine and working very smoothly. > No my problem is when I tried migrate/convert this A'97 application to Access'2000 using > menu TOOLS > Database utilities > Convert Database...it is converting successfully, but performance is so reduced that for any query it is taking more than 20 Mins where in A'97 it is about 1min or less. Why So? > > Is there any way to increase the performance.... any process to be followed .... > please help.... > > > Thanks in advance. > > > > > > > > --------------------------------- > Never miss a thing. Make Yahoo your homepage. > > [Non-text portions of this message have been removed] >
