Solved Do queries belong in the back-end or front-end of a database? (1 Viewer)

Sampoline

Member
Local time
Tomorrow, 08:24
Joined
Oct 19, 2020
Messages
144
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

I’m here to help
Staff member
Local time
Today, 13:24
Joined
Oct 29, 2018
Messages
14,077
The only thing that belongs in the backend, usually, are the tables/data.

Everything else belong in the front end.
 

Sampoline

Member
Local time
Tomorrow, 08:24
Joined
Oct 19, 2020
Messages
144
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

I’m here to help
Staff member
Local time
Today, 13:24
Joined
Oct 29, 2018
Messages
14,077
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

Member
Local time
Tomorrow, 08:24
Joined
Oct 19, 2020
Messages
144
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

I’m here to help
Staff member
Local time
Today, 13:24
Joined
Oct 29, 2018
Messages
14,077
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!
 

Users who are viewing this thread

Top Bottom