• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Profiler or tools of the same type exist fpor MS Access 2007

We are working in a DB in MS Access 2007.  We are currently trying to identify tables, codes, etc.

Is ther a tool like SQL Profiler where it displays the scripts and tables being affected by the application?
0
rayluvs
Asked:
rayluvs
  • 3
  • 2
  • 2
  • +2
4 Solutions
 
abkmaCommented:
There is no tool such as this in Access.  You can browse and view code modules within the Access application by clicking on the "Database Tools" tab on the ribbon menu bar.  On that ribbon you should see a button labeled as "Visual Basic."  Click on that button in order to see the code explorer.
0
 
BitsqueezerCommented:
Hi,

SQL Profiler is a tool to only see what happens between the frontend and backend of a SQL Server database. This will only show you the SELECT commands and so on which are sent to the server and the answers. There is no such tool for Access because the "normal" use of Access is as a desktop database in a single file so there is no command being sent over the network. In case of linked tables you can switch on logging in ODBC in Windows which gives you a little bit similar possibilities of SQL Profiler.

To identify tables, scripts and so on you need to open the database in design view. That depends on several things: You must have a full version of Access, the database needs to be a MDB/ACCDB format, the programmer has not locked the VB code.
In simple cases you can open a MDB/ACCDB database by holding down the Shift key while opening the database (in a full version) to not automatically start the application so you see the database navigation bar to work with all elements.
But this key can be disabled in the application with some tricks so you cannot get into the design view. And if the programmer locked the VB code you need the password to open the code.

Cheers,

Christian
0
 
Helen FeddemaCommented:
My Extras Plus add-in (link below) has (among other features) two menu add-ins that create reports with lists of all tables and fields, or all queries and fields, with the fields either in alphabetic order or table/query order.  This may be helpful to you.  Here is a screen shot of one of these reports:
http://www.helenfeddema.com/Files/code20.zip
Table-Fields-Report.jpg
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Richard DanekeTrainerCommented:
Access offers Object Dependencies  on the Database Tools menu.   This addition (since Access 2002) opens a pane on the right side.  From here, you can see the object relationships.  The radio buttons offer Objects That Depend on Me and Objects That I Depend On.   This does not expose the VBA code in forms and reports which can be viewed directly in Visual Basic.
Also, in Database Tools, is Performance Analyzer which will examixe the VBA code and database structure to recommend changes.  For example, adding Database Explicit to the code for performance gain, reducing or increasing indexes on common tables.
0
 
rayluvsAuthor Commented:
Bitsqueezer,

              Am I to understand that if I link or work with the Access
              DB via an OBDC, I can use the SQL Profiler?

Helen_Feddema,

              Thanx!  looks super interesting and hell'of lot easier
              to keep all tables/fields visible; we'll give it a try.

DoDahD,

              Don't quite follow you.  On theright side I can see
              the Tables being opened?


In general, what we need to see are the tables that are being hit by the code.  The application uses .NET on the Access DB.  We are setting Stops on the code so we can analyze what is doing.  With the help of a tool that will tell us what DB has been opened up to that "Stop" would help.



0
 
Richard DanekeTrainerCommented:
When you select Object Dependencies from the Database Tools, a new task pane  opens on the right side of the Access program window.  It will reflect your currently selected Access object from the left side pane - Navigation Panel.   When you select a different object, click the refresh link in the Object Dependencies task pane.
When working with code, the Immediates window is often used, I have be using the Watch window so you can add values and see the changes.
0
 
BitsqueezerCommented:
Hi,

you can only use SQL Server Profiler if the backend tables are hosted by SQL Server. In ODBC you have only the option of logging which writes a log file to the harddisk where you can check what happens. But this works ONLY if the access between .NET and Access works over ODBC (but as .NET has a lot better possibilities than ODBC I don't believe that someone creates a .NET program using ODBC).

Cheers,

Christian

0
 
rayluvsAuthor Commented:
Bitsqueezer,

                  thanx for the info.

DoDahD,

                we tried it, but it didn't seem to siaply anything.  I selected Object Dependencies, went
                and clicked on a database and start working with, butnothing displayed different
                on the right side.  Also ran the application developed for the DB and also nothin.

                Am I missing something?
0
 
rayluvsAuthor Commented:
Anything on why the Dependencies recommendation "04/05/10 11:09 AM, ID: 29816719" didn't work?
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now