Access database with 1.8 million addresses | AccountingWEB

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 ( )

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

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


David Carter |


Anonymous |


Anonymous |

the old Copy and Paste did it

David Carter |


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 |