By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,244 Members | 1,972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,244 IT Pros & Developers. It's quick & easy.

Linking to an MS Access ADE

P: n/a
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?
Nov 20 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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:
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?

Nov 20 '05 #2

P: n/a
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:
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:
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?


Nov 20 '05 #3

P: n/a
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:
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:
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?


Nov 20 '05 #4

P: n/a
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:
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:
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?


Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.