Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to view the code in an Access 2007 developed application

Posted on 2014-11-13
6
Medium Priority
?
343 Views
Last Modified: 2014-11-13
Hello All,

I am trying to migrate an office Access developed application to a different folder in another server.

The application its comprised by 2 files, one is called Interface and the other is called DATA.

When I first migrated it, I copied the 2 files over to the new server, but when I open the Interface file its seems that its still pointing to the DATA file in the old server location, I can see this in the time stamp reflected on the file. I am trying to see if I can find this link in order to edit it and point it to the new location but my knowledge in Access is very limited.

This application was developed by the previous manager but he did not make or leave any documentation.

Any hints on how to find and edit this link will be greatly appreciated!
0
Comment
Question by:LuiLui77
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 40440628
in the interface version,
right click in any of the tables and select Linked Table Manager
in the Linked Table Manager window
* check the box for Always prompt for new location
* click on Select All button
* click OK

in the dialog that will open, navigate to the folder where the DATA db is and select the the DATA db.
0
 

Author Comment

by:LuiLui77
ID: 40440744
Thanks Rey!
I was able to Link the interface to the new DATA file location!

Also Rey, there are certain buttons on the interface that I want to discover what is it that they do. For instance I know that there is a button that generates a report and I want to see what happens behind the scene when the user clicks on that button (i.e. what table they query and what calculations it does).

How can I see this?
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 2000 total points
ID: 40440768
open the form in design view
select the button, then hit F4
in the property window of the button, select the Event tab
look for the On Click  event ,
if you see [Event Procedure],
     * click the (...) on the right end of the click event, this will open the VBE window and you will see the codes behind the click event of the button

if you see [Embedded Macro]
    * click the (...) on the right end of the click event, this will open the Macro assigned to the button
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:LuiLui77
ID: 40440977
Cool!

What I see is HandleButtonclick(1) on the field, this might be a customize event or something. If I click on the dropdown button I can see some other events with some key names. how can I check on the events design?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40441078
ok, what you are seeing is a switchboard type of form, this is a complex situation for a beginner.
you need somebody who has advanced knowledge of access and vba to handle this.
0
 

Author Closing Comment

by:LuiLui77
ID: 40441326
I guess you are right. I got  what I wanted though. Thanks for everything!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question