Paul Hartland
paul.hartland at googlemail.com
Fri Jul 6 08:05:04 CDT 2012
Stuart, Thanks for the reply, first thing I was going to do was look at the indexing and primary keys etc, good to know that the backend frontend shouldn't be a problem though, they did mention that their network guys are pretty strict on access etc, so that's another thing I will be looking at. Paul On 6 July 2012 14:00, Stuart McLachlan <stuart at lexacorp.com.pg> wrote: > I've got one site where all the BEs are still 97 and have not experienced > any issues, speed or > otherwise using FE in all more recent versions of Access. Some of them > being regularly hit > by 20-30 users. > > First thing I'd look at is indexing, with that few records, lots of > indexes including multi-field > ones should not be a problem. > > -- > Stuart > > On 6 Jul 2012 at 13:46, Paul Hartland wrote: > > > To all, > > > > I am leaving my current company soon to start with another company, at > the > > interview they gave me a demonstration of their current database, they > > estimated in total there were probably less than 10,000 records on the > > whole database. They acknowledged (which was obvious anyway) that the > > database is slow, now without getting to look at the underlying > > tables/queries etc before I start, I was wondering if there are any > common > > issues with speed that other users on here may of come across. The > backend > > database is in access 97 and the frontend in Access 2007, are there any > > common problems with this ? > > > > Thanks in advance for any help or pointers on this. > > > > -- > > Paul Hartland > > paul.hartland at googlemail.com > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Paul Hartland paul.hartland at googlemail.com