Fill in Datas from a SQL Server

[softboy12]

Hi all

one question:

we use Access for our customer database and now switched to MS SQL for a better performance and security

now i have imported the datas from the Access DB, so far so good

how can i now access the reports in Access via SQL?

the targeting is the following

if i open the web interface to search for a customer in the MS SQL Database and after i found it, we shoud be able to create datasheets within Access and fill in the datas from the SQL Server

how can i implement this?

 

[dhookom]

Not sure what you are looking for but you can:
link the sql tables to Access
create pass-through queries to retrieve the dat
create a Access Data Project (ADP) that integrates with SQL Server

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[softboy12]

Hi Duane

sorry i didn't explained it clearly

well what we need is the following:

if we add a new entry in the SQL Database (a Domain) after that we have to create datasheets (in Access or another program) which we can deliver via mail in PDF Format

and cause the reports are already defined in Access i thought it shoud be possible to fill in the necessary datas
(Domainname, Username etc) directly in the report

 

[dhookom]

This still isn't clear. I am not sure what you are attempting to do. Are you adding a new database or table or server or just records to a SQL Server? What do you want to do with the data on the sql server?

SQL Server has the ability (if set up) to send mail with query results.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[softboy12]

thanks for your information

i ment if a record exists in the SQL Table it shoud be transferred (via OLE or similiar) to Access, which will create the report file filled in with the necessary value
from the SQL Server (p.a. Domainname, Username, Passwort etc)

--> how can i use the Mail Ability in MS SQL?

 

[dhookom]

I think you can create a pass-through query to SQL that allows you to dynamically set the connection string and SQL properties to retrieve any values you want from any server from any table.

The pass-through query can be the record source of a report assuming your fields/columns are the same. You can send the report to snapshot or PDF (assumes you have the Writer). All of this can be controlled with code.

There are probably a dozen or more steps to automate this solution. If you have questions, please confine them to one or two specific steps.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.