Solved

How to view the code in an Access 2007 developed application

Posted on 2014-11-13
6
318 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
  • 3
  • 3
6 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 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 500 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

785 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