LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel VBA - ActiveX Data Objects (ado) Performance

Hi All,

I am working on an Excel Application which is a Fronted to a Microsof
Access Database. Initially the con-current users was going to be aroun
10, this has now blown out to 50 users.

Is there a figure that any one would recomend as the maximum number o
users?

When I run a query(based on table 'A') which is stored in the Acces
database are all the records in table A passed back to Excel via AD
then filtered via the query? If so this might explain my performanc
issues.

If anyone has any information on this or general performance with AD
it would be appreciated.

Thanks,
Adam. :

--
Message posted from http://www.ExcelForum.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data comparison and performance george Excel Discussion (Misc queries) 1 April 16th 09 09:20 PM
setting Excel to reference microsoft activex data objects libraryfrom Access Laoballer Charts and Charting in Excel 0 March 25th 09 03:55 PM
Compare Data to Track Changes in Performance Big_Tater[_2_] Excel Discussion (Misc queries) 0 February 13th 09 06:55 PM
Excel: Find/Replace for Data Validation text or Worksheet Objects [email protected] Excel Discussion (Misc queries) 3 May 22nd 06 07:16 PM
Missing: Microsoft ActiveX Data Objects Recordset 2.7 Library Debi[_2_] Excel Programming 2 March 4th 04 06:37 PM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"