a mighty difficult access question!

Printable View

10-22-2003, 11:28 AM
jamble

a mighty difficult access question!

Well, difficult in that I'm about to provide very little information ....

I'm currently in the middle of pitching to win a new client and at the moment they're having some problems with an access database they've had programmed and installed by someone else.

The database is used (they are a courier company) to input new orders/delieveries and then it generates an invoice.

The problem they are having is that the database can take up to 20 seconds to open (once it's open it's fast) and they're unsure what might be causing this as it's only got a couple of hundred entries and it's running only on local machines (not online) so I would have thought it would be fast!

Sorry I can't provide much more info than that, basically I'm wondering if people might be able to suggest some common issues with access that they could look at? This would certainly help with my pitch if I could help out here!!

Thanks!
10-22-2003, 02:52 PM
robbmcaulay

Does it open in datasheet view? That might slow it down...
10-22-2003, 07:14 PM
sk8Krog

How much ram does the server have that the database is on? Low ram could be the problem (<512)
10-23-2003, 03:42 AM
mx_kid

Tell them for an extra £££ you can make them an order input interface to write directly to the database, and then contact me further about PHP/ASP.NET ;)

I cant think why it's slow to open, other than MS Access itself being slow. Its actually probably better to use mySQL or similar.
10-23-2003, 05:24 AM
jamble

Quote:

Originally posted by mx_kid
Tell them for an extra £££ you can make them an order input interface to write directly to the database, and then contact me further about PHP/ASP.NET ;)

I cant think why it's slow to open, other than MS Access itself being slow. Its actually probably better to use mySQL or similar.

that was basically what I said to them :p

(apart from swapping the bit where I do the job rather than you ;))
10-23-2003, 05:32 AM
mx_kid

haha my jedi mind tricks seem to weakening

*you dont want the work*

*you will give the work to graham*

*you will go across the street for some orange sher bert*
10-23-2003, 05:33 AM
jamble

Quote:

Originally posted by mx_kid
haha my jedi mind tricks seem to weakening

*you dont want the work*

*you will give the work to graham*

*you will go across the street for some orange sher bert*

*here is your orange sher bert*

:p