Access Database Programming Assistance

[MikeOxhard]

budgie smuggler said:

Do the six queries output the same columns? If so perhaps you could rewrite them as a union.

grumbas said:

I used to do a lot of work in Access about 15 years ago, what you've got there looks to be stretching the abilities of Access to the limits.

It's not, you'd be surprised how powerful it is. I used to work as a programmer for a place which had some very very big and complex systems running with Access as their front ends. Large financial institutions etc. You can use SQL Server (and possibly other ODBC sources, I forget now) as the backend with Access running as a frontend.

Thanks very much - I've created a union query and all working fine.

I think this will be a short term fix whilst we decide the way forward with CRM etc.

[SystemParanoia]

MikeOxhard said:

budgie smuggler said:

Do the six queries output the same columns? If so perhaps you could rewrite them as a union.

grumbas said:

I used to do a lot of work in Access about 15 years ago, what you've got there looks to be stretching the abilities of Access to the limits.

It's not, you'd be surprised how powerful it is. I used to work as a programmer for a place which had some very very big and complex systems running with Access as their front ends. Large financial institutions etc. You can use SQL Server (and possibly other ODBC sources, I forget now) as the backend with Access running as a frontend.

Thanks very much - I've created a union query and all working fine.

I think this will be a short term fix whilst we decide the way forward with CRM etc.

Short term fixes never stay short term..

there will be another dumpster fire for you to sort out tomorrow and you'll never get back to it