Linked Table working very slow with client program

Nerijus · July 7th, 2003, 08:34 AM

I have problem

I have two DB Access (Jet4.0) and another one MSDE 2000 and I need take (change) one table
data from Access to SQL Server.

Linked Table working very slow with client program which written with VB6 and which
have reference to appopriate view (generated with Linked Table option) at SQL Server.

After when i did action to open appropriate view (with Enterprise Manager) speed became correct ('Â± fast').
And such behave all time util computer not shutdown. When computer turn on, again client programs are
working slow,
since appopriative views are not opened with Enterprice Manager.

All computers using Windows 98.

Please ask me by mail: [email protected]
Nerijus