A Flash Developer Resource Site

Results 1 to 7 of 7

Thread: a mighty difficult access question!

  1. #1
    Señor member
    Join Date
    Dec 2000
    Location
    Huddersfield, UK
    Posts
    1,819

    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!
    Company, Meet Creative
    sign up, help spread the word and win a shuffle.
    ------------------------
    welcomebrand

  2. #2
    Hairy Member robbmcaulay's Avatar
    Join Date
    Dec 2001
    Location
    Edinboro, yo!
    Posts
    1,596
    Does it open in datasheet view? That might slow it down...
    "Wah wah wah Dorothy Parker wah wah wah" - hanratty21

  3. #3
    Waaambulance Pilot sk8Krog's Avatar
    Join Date
    Apr 2001
    Location
    moo york city
    Posts
    1,980
    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

  4. #4
    mullet king
    Join Date
    Jun 2002
    Posts
    1,398
    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.

  5. #5
    Señor member
    Join Date
    Dec 2000
    Location
    Huddersfield, UK
    Posts
    1,819
    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

    (apart from swapping the bit where I do the job rather than you )
    Company, Meet Creative
    sign up, help spread the word and win a shuffle.
    ------------------------
    welcomebrand

  6. #6
    mullet king
    Join Date
    Jun 2002
    Posts
    1,398
    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*

  7. #7
    Señor member
    Join Date
    Dec 2000
    Location
    Huddersfield, UK
    Posts
    1,819
    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*




    Company, Meet Creative
    sign up, help spread the word and win a shuffle.
    ------------------------
    welcomebrand

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center