|
Home > Archive > microsoft.public.cert.mcdba > February 2004 > Using SQL and Access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using SQL and Access
|
|
|
| If I want to use my front end of Access and SQL as
backend. How would I do this?
Would I Export all Access tbls etc into a new db in SQL?
If so how do I do this?
2nd question. I dont quite get how one would generate say
a report from SQL like you would from Access. Do most
companies use SQL like this or do they use it like say an
Access application? Does SQL need to be tied somehow into
another application like Access etc?
Please help in my confusion
| |
| Ray Higdon 2004-02-14, 10:23 pm |
| You have lots of options for your second question. MS has released Reporting
services for this exact task and is free with a valid SQL license. See here
for more info: http://www.microsoft.com/sql/reporting/default.asp
For your first question, you can use an Access Project for this, here are
some links:
http://msdn.microsoft.com/chats/off...fice_092602.asp
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9037
http://www.programmingmsaccess.com/...ag_articles.htm
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
---
"Troy" <anonymous@discussions.microsoft.com> wrote in message
news:fd2f01c3f34a$75e83eb0$a10
1280a@phx.gbl...
> If I want to use my front end of Access and SQL as
> backend. How would I do this?
>
> Would I Export all Access tbls etc into a new db in SQL?
> If so how do I do this?
>
> 2nd question. I dont quite get how one would generate say
> a report from SQL like you would from Access. Do most
> companies use SQL like this or do they use it like say an
> Access application? Does SQL need to be tied somehow into
> another application like Access etc?
>
> Please help in my confusion
| |
| Kael V. Dowdy 2004-02-16, 4:24 am |
| "Troy" <anonymous@discussions.microsoft.com> wrote in message news:< fd2f01c3f34a$75e83eb0$a101280a
@phx.gbl>...
> If I want to use my front end of Access and SQL as
> backend. How would I do this?
>
> Would I Export all Access tbls etc into a new db in SQL?
> If so how do I do this?
>
> 2nd question. I dont quite get how one would generate say
> a report from SQL like you would from Access. Do most
> companies use SQL like this or do they use it like say an
> Access application? Does SQL need to be tied somehow into
> another application like Access etc?
>
> Please help in my confusion
As far as the reports in your second question...if you feel
comfortable generating reports in MS Access, you can create a linked
table from SQL Server in Access and use the data in the linked table
just as if it were actually a table within Access.
This by no means is the best scenario as far as efficiency (processing
time) or obtaining advanced reporting functionality, but it will get
you on your way in the mean time after you migrate the data to SQL
Server. That way, you won't have to relearn another reporting tool
off the bat, and don't have to pay for it since you already paid for
Access.
By the way, I think the Reporting Services software Ray mentioned is
free, although you may have to request it directly from Microsoft. I
was thinking about Crystal Reports by Seagate Software when I
mentioned paying for a separate reporting tool...
Kael MCSD, A+
| |
|
| SQL Reporting services software is free to valid holders of a SQL 2000
Server license. HOWEVER, in order to make the report designer portion work,
you must have Visual Studio .NET 2003 (which is NOT free...try $1100). Even
with all this it is a pretty slick product.
Regards,
Ron Higdon, MCSE
"Kael V. Dowdy" <google@kaeldowdy.com> wrote in message
news:c9350f50.0402160041.1078ae9b@posting.google.com...
> "Troy" <anonymous@discussions.microsoft.com> wrote in message
news:< fd2f01c3f34a$75e83eb0$a101280a
@phx.gbl>...
>
> As far as the reports in your second question...if you feel
> comfortable generating reports in MS Access, you can create a linked
> table from SQL Server in Access and use the data in the linked table
> just as if it were actually a table within Access.
>
> This by no means is the best scenario as far as efficiency (processing
> time) or obtaining advanced reporting functionality, but it will get
> you on your way in the mean time after you migrate the data to SQL
> Server. That way, you won't have to relearn another reporting tool
> off the bat, and don't have to pay for it since you already paid for
> Access.
>
> By the way, I think the Reporting Services software Ray mentioned is
> free, although you may have to request it directly from Microsoft. I
> was thinking about Crystal Reports by Seagate Software when I
> mentioned paying for a separate reporting tool...
>
> Kael MCSD, A+
|
|
|
|
|