query with conditional source table

[Lord Byron]

I'm facing a problem with an Access application I built.

The Access application is linked to a third party financial software (the supplier gave permission to figure out the purpose of all its underlying tables). When I developped my tool, the main data was stored in a single table on its SQL database. In the latest version of that software, this is split into one table per year.

Now since I only export one month's data, I need to adjust this so that it exports from the correct table.

I currently use passthrough queries that call a stored procedure on the SQL Server.

The options I can think of are the following:

- Create a VBA script which in its turn creates a stored procedure to update the stored procedure

- Put the code for the stored procedure in thepassthrough query and write a VBA script to update the table from which to take the data.

Which would be the best solution? Or are there other (and possibly better) ways to do this. And finally, how would I go about this?

Thanks.

 

[Lord Byron]

Nobody?

I'm sure that there are experts in here whom know how to tackle this one. So please give me advise.

Thanks,

Lord Byron