p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

access thread: Access and MSDE

Message #1 by "Tom Campbell" <axsdata@l...> on Mon, 25 Jun 2001 21:37:46
I just purchased Access 2002 and wanted to start working with MSDE as 

preparation for working with SQLServer 2000 and Access.  My problem is 

this - I installed MSDE and the server runs fine.  I created the Access 

data project and then I imported a single Access table to be practising 

on.  TO give it a workout the table had 119,000 records.  Now Access (jet) 

has no problem with this many rows.  Sorting finding etc. work fine.  But 

MSDE seems to labor mightily over this many records.  Just a simple action 

like asking it to go to the last record in a table seems to lock it up.  I 

have tried this on 2 different PC's.  One is running WIndows 98 with 256 M 

ram.  The other is running Windows 2000 Pro. with 128 M ram.  The latter 

is worse, but both exhibit the same problems.  I thought that MSDE would 

be more powerful than Jet in handling larger tables, but this does not at 

all seem to be the case.

Can somebody tell me what I might be doing wrong?

Tom Campbell

  Return to Index