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

Sampoline

Member
Local time
Tomorrow, 02:51
Joined
Oct 19, 2020
Messages
161
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.
 
The only thing that belongs in the backend, usually, are the tables/data.

Everything else belong in the front end.
 
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.
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom