Some Advice needed please!

[Bob Vance]

My database is getting so slow to open my Invoices, about 30 sec for each
one to open where as my earlier database with so many less records was on 3
sec to open, Actually I have 600 horses with their data , 400 of them are
finished , so only 200 are in use, is there some way I can code them to be
exported to another Database with their records, As my database is just
getting to big and slower, Please any help ...Bob
PS my database is not split!

 

[Jellifish]

First of all, have you compacted the database recently?
(Tools/Options/Compact and Repair)

 

[Jeff Boyce]

Bob

Before running Compact & Repair (suggested else-thread), consider making a
backup copy of your database.

The C&R routine has been known to fail, munging your database ... without a
backup (you ARE keeping backups, right?!), you're out of luck.

You haven't described the data (table) structure, nor the indices (if any),
nor the SQL statements for the ?queries for your ?forms and ?reports.

More specific description may lead to more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bob Vance]

Ok Thanks have Compacted every week and have plenty of back ups, I will try
to explain how my db works and post it in a couple of hours thanks...Bob