MS Access database - has 4 years of info, only need 1 year

[eSDee]

Hopefully there are some Access wizards here. One of my users has a huge database which contains 4 years of data on it. I am sharing it on one of my servers for multiple people to access from different shells. Because of the amount of records it is really slow. Is there a way to create a new database with just the year prior of data in the database for faster querying? If so is it a daunting task to do, or something that I could probably research and do pretty easily?

Thanks in advance.

[DarkFury]

Do you have a specific field that has just the year you want to query?

If so, then just do a filter for that specific year before querying your data.

[ray]

DF's suggestion will definitely work if you want to keep original information intact.

You can also try copying the existing table that houses all your data and then within the new table, strip out the 3 years you don't need and have your query point to that table instead of the original table.

[eSDee]

Well I don't know much about Access but from what I understand, the user will put in a query for a patient name and it searches 4 years of data for it. There is a date field within the database, which at the moment is not used in the query. Could it be as simple as adding a check box that limits the query to years 2005 and 2006 for instance?

[ray]

Could it be as simple as adding a check box that limits the query to years 2005 and 2006 for instance?

Pretty much you add in a string that limits that part of the query to a date range.

It's been about 2 years since i've done this, but i'm sure the tutorials online can point you in the right direction.

Maybe DF is more versed and refreshed than i am.

[YellowCoffee]

Well I don't know much about Access but from what I understand, the user will put in a query for a patient name and it searches 4 years of data for it. There is a date field within the database, which at the moment is not used in the query. Could it be as simple as adding a check box that limits the query to years 2005 and 2006 for instance?

You would need to modify the query to filter for the years you want. I'm assuming the table that this query is sourcing has a related date field. You would need to modify the query so that it filters for the appropriate year. I'm assuming you're using a form and you click a button to access the data? If this is the case, you would need to see which query the button executes when clicked.

It's hard to assist the situation any further w/o anymore specifics. Just know that you have to 1) identify the query that is being used, 2) Go into design mode, 3) Change/add a filter for the dates you want. Hope this helps.

[eSDee]

Thanks everyone! I'll give that shot on Monday :cheers: