report backend database

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Report from backend database

Report from backend database

resolvedResolved · Medium Priority · Version 2007

Nathaniel has attended:
Access VBA course

Report from backend database

Hi,

I have a backend database with tables, queries and reports in it and a frontend databse with the forms and modules in it for updating the database etc. via recordsets and accessing the stored queries in the backend database.

The issue I have is trying to run a report that is stored in the backend database, is this possible?

I have no linked tables on the frontend so I cannot create the report this way.

Many Thanks,
Nathaniel

RE: Report from backend database

Hi Nathaniel,

Thank you for your question and welcome to the forum.

If your back-end database contains all the tables and queries, then creating reports from within there shouldn't be a problem.

Are you encountering a specific problem when you try and do this?

Regards

Simon

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 23 Nov 2012: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Server loaded in 0.08 secs.