469,578 Members | 1,560 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

sql update/access query

A user has a make table query, basically it does some summing and creates a
'summary' table. I'd like to get rid of it (it's the last one in the access
back-end) and use pure sql. Is the same thing easy enough to accomplish in
sql or would you still need to make the table in the FE and then update the
(same) table in sql..?
--
Thanks,
Lap
Nov 12 '05 #1
3 1392
DFS
"Lapchien" <bl**@blar.tv> wrote in message
news:10**************@ananke.eclipse.net.uk...
A user has a make table query, basically it does some summing and creates a 'summary' table. I'd like to get rid of it (it's the last one in the access back-end) and use pure sql. Is the same thing easy enough to accomplish in sql or would you still need to make the table in the FE and then update the (same) table in sql..?
Depends on how it's used, what kinds of summaries it contains, if FE users
have links stored to this summary table, etc.

--
Thanks,
Lap

Nov 12 '05 #2
When it's created (currently in the access BE) users have a link from their
FE, nothing fancy, just to lookup. The summaries it contains are just
currency transactions, basic 'sum' query expressions.
--
Thanks,
Chris
cc****@NOSPAMeclipse.co.uk

"DFS" <no******@nospam.com> wrote in message
news:vt************@corp.supernews.com...
"Lapchien" <bl**@blar.tv> wrote in message
news:10**************@ananke.eclipse.net.uk...
A user has a make table query, basically it does some summing and
creates a
'summary' table. I'd like to get rid of it (it's the last one in the

access
back-end) and use pure sql. Is the same thing easy enough to accomplish

in
sql or would you still need to make the table in the FE and then update

the
(same) table in sql..?


Depends on how it's used, what kinds of summaries it contains, if FE users
have links stored to this summary table, etc.

--
Thanks,
Lap


Nov 12 '05 #3
DFS
Lap,

Sounds like it's up to you to do what you want with it. If it contains
important codes or reference data, I say leave it. But if it's continually
dropped and recreated, I would wonder about how the data is used, who, how
often, etc.

I generally split tables up like this:

back-end
-------------------
TRANS - transaction tables (ie items rented)
REF - reference tables (lists of categories, codes, states, cities, etc
enforced on the transaction tables)
XREF - cross-reference tables (various xref between reference tables)

front-end
-------------------
TEMP tables (data summaries used for reports, etc.)
WORK tables or SYS tables (list of reports on a report menu, search
categories, things used with coding and processing, etc.)
(note: I sometimes place WORK tables in a separate db, or even in the
back-end)

"Lapchien" <bl**@blar.tv> wrote in message
news:10*************@ananke.eclipse.net.uk...
When it's created (currently in the access BE) users have a link from their FE, nothing fancy, just to lookup. The summaries it contains are just
currency transactions, basic 'sum' query expressions.
--
Thanks,
Chris
cc****@NOSPAMeclipse.co.uk

"DFS" <no******@nospam.com> wrote in message
news:vt************@corp.supernews.com...
"Lapchien" <bl**@blar.tv> wrote in message
news:10**************@ananke.eclipse.net.uk...
A user has a make table query, basically it does some summing and creates
a
'summary' table. I'd like to get rid of it (it's the last one in the

access
back-end) and use pure sql. Is the same thing easy enough to

accomplish in
sql or would you still need to make the table in the FE and then
update the
(same) table in sql..?


Depends on how it's used, what kinds of summaries it contains, if FE users have links stored to this summary table, etc.

--
Thanks,
Lap



Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by David Shorthouse | last post: by
10 posts views Thread by Randy Harris | last post: by
9 posts views Thread by James Butler | last post: by
2 posts views Thread by NigelMThomas | last post: by
3 posts views Thread by Michel Esber | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.