dBrococo Posted May 8, 2007 Share Posted May 8, 2007 Hi all,I am programming an Access 2000 database that contains approximately 3700 records stored in a relational table structure.When I split the database and moved the tables to the server side, my performance worsened drastically: a query that runs in under 5 seconds when the tables are on the client side takes over 45 seconds with tables on the server side.I've tried a variety of solutions (changing the subdatasheet name property to [None] in the tables, creating an MDE file from the MDB file), but they haven't helped.Any suggestions about how to speed performance are greatly appreciated! Thanks a lot! Link to comment Share on other sites More sharing options...
aspnetguy Posted May 8, 2007 Share Posted May 8, 2007 I think you'll find that Access itself is the problem. Access is not intended or optimized to be an online database plus Access does have it's limits after it gets a lot of data it begins to chug. I would suggest you upgrade to MySql or Sql Server. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.