Access database with 1.8 million addresses

Needing to do some cold calling to drum up a bit of business I've bought myself the Yell UK Business Directory - amazing value at only £79 with 1.8 million addresses, phone number, no of employees, ISIC codes etc ( http://www.yell123.com/index.php?event=detail&id=12 )

My problem is that it comes in an Access database, and at 1.4 gigabytes and 1.8 million records my PC is grinding to a halt trying to handle it.

To make it manageable I'd like to chop it up into separate files - one for each county. But whatever I try, it simply locks up.

Can any Access expert tell me the simplest way of achieving this? Thanks

David Carter

Comments
There are 13 comments. Login or register to view them.

Yes

David Carter |

Astounding!

Anonymous |

David

Anonymous |

the old Copy and Paste did it

David Carter |

and...

listerramjet |
listerramjet's picture

boxing clever

listerramjet |
listerramjet's picture

Suggested reading ....

Anonymous |

Acces specs

neileg |

re Bob

Fred Hoad |
Fred Hoad's picture

Alternatively - try linking ...

Anonymous |

Not sure if it will work, but.

Richard Willis |
Richard Willis's picture

I think your stuck!

3569787 |
3569787's picture

Try SQL Server Express ....

Anonymous |