Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 7th, 2003, 08:34 AM
Registered User
 
Join Date: Jul 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked Table working very slow with client program

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
How to tell the user that the program is working? chobo2 C# 1 November 10th, 2007 06:05 AM
Can a Make Table Query produce a Linked table? kronik Access 5 May 16th, 2006 06:17 AM
Linked Table sdilucca Access 1 February 24th, 2006 07:29 AM
optimizing MySQL table joins - script running slow crmpicco MySQL 7 January 31st, 2006 10:54 AM
linked table Tasha Access VBA 1 August 6th, 2004 03:04 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.