Solved

Syntax Question - How can I CALL a procedure in the Backend of my split database?

Posted on 2013-12-15
5
297 Views
Last Modified: 2013-12-20
I use MS Access 2K and a split front/back end structure.
The backend is also MS Access.

I have written a Public procedure in the MS Access back end that I need to call from the front end.

The name of the procedure in the backend is:

DeleteMyTable

which is setup as follows in a module

Public Sub DeleteMyTable
<<code here>>
end sub

How can I execute the DeleteMyTable code from the front end?
0
Comment
Question by:pcalabria
[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
5 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39721151
<<How can I execute the DeleteMyTable code from the front end? >>

 You can't easily.  Far better off to move the procedure to your front end.

  That after all is the setup a FE/BE should have; BE is nothing but data, FE is everything else.

Jim.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 39722519
Does the code delete the table in your FE database or the BE database?
0
 
LVL 19

Expert Comment

by:Richard Daneke
ID: 39722792
The code can be called from the VBA in the front end.  You would have to create an instance of the backend database and call the code from the front end VBA connection.

If the code to delete a BE table were to be run from the FE database, wouldn't it just delete the linked table info and not the be table data?
0
 

Author Closing Comment

by:pcalabria
ID: 39730943
Thanks all.  I was trying to delete a table in the BE.  I wrote code in the BE and hoped to run it from the FE.

I solved the problem by writing different code in the FE do delete the BE table.  I never found a way to run the code from the FE.
0
 
LVL 57
ID: 39731570
<<I solved the problem by writing different code in the FE do delete the BE table.  I never found a way to run the code from the FE. >>

 Well to answer that, the simpliest way is to set a VBA reference to your BE DB, at wich point you'd then be able to execute procedures in the BE.

If your dealing with code that works with objects in the curent DB (in this case the FE) then it's pretty stright forward.  But if in the called code DB (in this case the BE), you would need to be very careful with your coding.   You can lookup CodeDB() in the on-line help for additional comments.

The other way would be to invoke a second instance of Access with OLE automation, then execute the code.

Neither of those is really attractive for several reasons, so the best answer is to simply move the code into the FE.

With DAO or DML SQL statements, it's very easy to manipulate tables in a BE DB.

Jim.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MMC can't display 1 53
Exchange 2007 SP upgrade 9 105
Use System DSN 6 91
Format underline a range 2 94
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

726 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