Linking to an MS Access ADE

I am in the process of rewriting an MS Access application (access front end with SQL 2k database) in VB.NET and one of the things I would like to do is link in to the compiled Access ADE so that I can use the reports that have already been created. I have somewhere in the region of 200 reports already created in MS Access and I really don't want to have to create new ones.

I have successfully linked to the Access ADP, but would really like to use the ADE so that I am not exposing the code.

Can this be done?

Any ideas as to how I do it?

re: Linking to an MS Access ADE

What linking are your referring to? Tables and queries? An ADP/ADE has no
front end data. Thus there is no data to link with. How are your writing
in Access with VB.NET?

You should post in nntp://comp.databases.ms-access



Supa Hoopsa wrote:[color=blue]
> I am in the process of rewriting an MS Access application (access
> front end with SQL 2k database) in VB.NET and one of the things I
> would like to do is link in to the compiled Access ADE so that I can
> use the reports that have already been created. I have somewhere in
> the region of 200 reports already created in MS Access and I really
> don't want to have to create new ones.
>
> I have successfully linked to the Access ADP, but would really like
> to use the ADE so that I am not exposing the code.
>
> Can this be done?
>
> Any ideas as to how I do it?[/color]

re: Linking to an MS Access ADE

Sorry, I don't think I explained what I was after very well, or at least used the wrong terminology.

What I want to do is automate an MS Access 2000 ADE. The ADE is linked to SQL2k databse and contains links to the underlying tables, views and stored procedures. It also contains over 200 Reports written in Access. Rather than re-writing these reports, I would like to automate this ADE in VB.NET so that I can use it as a kind of black-box to generate, preview & print the reports.

I have read many threads on this forum, the MSDN & MS Knowledge base about automating an Access MDB or ADP in my case and I have managed to automate an ADP, but this exposes the database and code to the user.

While automating the ADP, I have also had a problem passing parameters across from VB. Each report uses a stored procedure and the parameters for the sp are definded in the "input parameter" property in the data section of the Access report, ie @JOBKEY=Forms![FrmJobs]![JobKey]. The code I am using from VB.NET is as follows:

ThisAccessProject.OpenAccessProject(filepath:="C:\ Aims.net Sourcecode\AIMS_Reports.adp", exclusive:=False)

ThisAccessProject.DoCmd.OpenReport(ReportName:="Jo bCostRpt", View:=Access.AcView.acViewPreview, WhereCondition:="[@JOBKEY]=47564")

So to summarise, I want to automate an MS Access 2000 ADE in VB.NET and to be able to call the Access Reports and pass across the necessary stored procedure parameters.


"Eric Sabine" wrote:
[color=blue]
> What linking are your referring to? Tables and queries? An ADP/ADE has no
> front end data. Thus there is no data to link with. How are your writing
> in Access with VB.NET?
>
> You should post in nntp://comp.databases.ms-access
>
>
>
> Supa Hoopsa wrote:[color=green]
> > I am in the process of rewriting an MS Access application (access
> > front end with SQL 2k database) in VB.NET and one of the things I
> > would like to do is link in to the compiled Access ADE so that I can
> > use the reports that have already been created. I have somewhere in
> > the region of 200 reports already created in MS Access and I really
> > don't want to have to create new ones.
> >
> > I have successfully linked to the Access ADP, but would really like
> > to use the ADE so that I am not exposing the code.
> >
> > Can this be done?
> >
> > Any ideas as to how I do it?[/color]
>
>
>[/color]

re: Linking to an MS Access ADE

Sorry, I don't think I explained what I was after very well, or at least used the wrong terminology.

What I want to do is automate an MS Access 2000 ADE. The ADE is linked to SQL2k databse and contains links to the underlying tables, views and stored procedures. It also contains over 200 Reports written in Access. Rather than re-writing these reports, I would like to automate this ADE in VB.NET so that I can use it as a kind of black-box to generate, preview & print the reports.

I have read many threads on this forum, the MSDN & MS Knowledge base about automating an Access MDB or ADP in my case and I have managed to automate an ADP, but this exposes the database and code to the user.

While automating the ADP, I have also had a problem passing parameters across from VB. Each report uses a stored procedure and the parameters for the sp are definded in the "input parameter" property in the data section of the Access report, ie @JOBKEY=Forms![FrmJobs]![JobKey]. The code I am using from VB.NET is as follows:

ThisAccessProject.OpenAccessProject(filepath:="C:\ Aims.net Sourcecode\AIMS_Reports.adp", exclusive:=False)

ThisAccessProject.DoCmd.OpenReport(ReportName:="Jo bCostRpt", View:=Access.AcView.acViewPreview, WhereCondition:="[@JOBKEY]=47564")

So to summarise, I want to automate an MS Access 2000 ADE in VB.NET and to be able to call the Access Reports and pass across the necessary stored procedure parameters.


"Eric Sabine" wrote:
[color=blue]
> What linking are your referring to? Tables and queries? An ADP/ADE has no
> front end data. Thus there is no data to link with. How are your writing
> in Access with VB.NET?
>
> You should post in nntp://comp.databases.ms-access
>
>
>
> Supa Hoopsa wrote:[color=green]
> > I am in the process of rewriting an MS Access application (access
> > front end with SQL 2k database) in VB.NET and one of the things I
> > would like to do is link in to the compiled Access ADE so that I can
> > use the reports that have already been created. I have somewhere in
> > the region of 200 reports already created in MS Access and I really
> > don't want to have to create new ones.
> >
> > I have successfully linked to the Access ADP, but would really like
> > to use the ADE so that I am not exposing the code.
> >
> > Can this be done?
> >
> > Any ideas as to how I do it?[/color]
>
>
>[/color]

re: Linking to an MS Access ADE

Sorry, I don't think I explained what I was after very well, or at least used the wrong terminology.

What I want to do is automate an MS Access 2000 ADE. The ADE is linked to SQL2k databse and contains links to the underlying tables, views and stored procedures. It also contains over 200 Reports written in Access. Rather than re-writing these reports, I would like to automate this ADE in VB.NET so that I can use it as a kind of black-box to generate, preview & print the reports.

I have read many threads on this forum, the MSDN & MS Knowledge base about automating an Access MDB or ADP in my case and I have managed to automate an ADP, but this exposes the database and code to the user.

While automating the ADP, I have also had a problem passing parameters across from VB. Each report uses a stored procedure and the parameters for the sp are definded in the "input parameter" property in the data section of the Access report, ie @JOBKEY=Forms![FrmJobs]![JobKey].

So to summarise, I want to automate an MS Access 2000 ADE in VB.NET and to be able to call the Access Reports and pass across the necessary stored procedure parameters.


"Eric Sabine" wrote:
[color=blue]
> What linking are your referring to? Tables and queries? An ADP/ADE has no
> front end data. Thus there is no data to link with. How are your writing
> in Access with VB.NET?
>
> You should post in nntp://comp.databases.ms-access
>
>
>
> Supa Hoopsa wrote:[color=green]
> > I am in the process of rewriting an MS Access application (access
> > front end with SQL 2k database) in VB.NET and one of the things I
> > would like to do is link in to the compiled Access ADE so that I can
> > use the reports that have already been created. I have somewhere in
> > the region of 200 reports already created in MS Access and I really
> > don't want to have to create new ones.
> >
> > I have successfully linked to the Access ADP, but would really like
> > to use the ADE so that I am not exposing the code.
> >
> > Can this be done?
> >
> > Any ideas as to how I do it?[/color]
>
>
>[/color]