Solved Do queries belong in the back-end or front-end of a database?

[Sampoline]

So I have a query that is running a delete blank records on form_open. Should that query be on the front or back end file?

Also while I'm here, same question for Modules.. do those go back or front end? Thanks.

 

[theDBguy]

The only thing that belongs in the backend, usually, are the tables/data.

Everything else belong in the front end.

 

[Sampoline]

The only thing that belongs in the backend, usually, are the tables/data.

Everything else belong in the front end.

Yep, I thought so! Just double-guessed myself there. Makes sense why. Thankyou.

 

[theDBguy]

Yep, I thought so! Just double-guessed myself there. Makes sense why. Thankyou.

You're welcome. I said "usually," because that's what I would expect for Access backends. But if the backend is something like SQL Server, then obviously the BE can have more than just tables in it.

 

[Sampoline]

You're welcome. I said "usually," because that's what I would expect for Access backends. But if the backend is something like SQL Server, then obviously the BE can have more than just tables in it.

Oh right, I think I had read this somewhere too and that's why I confused myself here. But yes, this is just Access I'm working on, so tables/data it is! Thanks.

 

[theDBguy]

Oh right, I think I had read this somewhere too and that's why I confused myself here. But yes, this is just Access I'm working on, so tables/data it is! Thanks.

Good luck!