-
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!
-
Hairy Member
Does it open in datasheet view? That might slow it down...
"Wah wah wah Dorothy Parker wah wah wah" - hanratty21
-
Waaambulance Pilot
How much ram does the server have that the database is on? Low ram could be the problem (<512)
It must be obvious day at camp stupid
-
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.
-
-
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*
-
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*
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|