MS Access - OLE Server Error....HELP!!

views:

368

answers:

MS Access - OLE Server Error....HELP!!

So I developed this access database application (just the back end), on a lap top, and now I have tried to move it onto a network drive. The purpose of this thing is to track data for metrics, so there is a lot of data (700k rows at 15 fields for main table), and it runs these top N queries that it builds charts with...

so i put it all on the network shared drive today and tried to run one chart..

the query seems to get stuck in the middle (just judging from the little progress bar on the bottom left side), and after waiting 5 minutes if I control break i get a message that says OLE Server Error.....

please don't tell me that it will work on a laptop and not on a network shared drive?

anyone know whats up with this?

+1 A:

Examine your queries and your connection method to ensure you are not dragging large volumes of data over the network to be processed/filtered in the front-end.

Mitch Wheat 2009-07-23 00:48:21

whenever I run one of these queries to produce the charts it has to "scan" the main table which is 700k rows @ 15 fields. now there are quite a bit of parameters per query (timeframe: month, quarter, fy) the type (ID, descrip, class, etc)....but to preform the top nth that is required by the client, i dont see any way around itand this is just the "back-end"...meaning pre-split, pre-MDE...i just wanted to try to run some procedures to see if everything was placed back together properly (relationships, etc)....should this matter?this is the trouble being a rookie....

Justin 2009-07-23 01:40:59

problem solved. i am embarrassed to even say what the problem was here, but none-the-less is got resolved when I checked my queries, and trimmed the fat on some of the queried tables. thanks!

Justin 2009-07-24 13:31:46

ansaurus

tags:

views:

answers:

MS Access - OLE Server Error....HELP!!

related questions