Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run Module on Back End Linked Table from Front End?

Status
Not open for further replies.
mmogul

mmogul

IS-IT--Management
Dec 1, 2003
218
US
I want to run a macro or module that resides on the back-end database but call this module from the front end. Is this possible? In this case, both the front-end and back-end are mdb files.

If so, how?

Thanks.... Mark
 
Sort by date Sort by votes
Code: 
Dim AppAccess As New Access.Application
Set AppAccess = CreateObject("Access.Application")
AppAccess.OpenCurrentDatabase ("c:\issues.mdb")
AppAccess.Visible = True
AppAccess.DoCmd.RunMacro "marconame"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
299
aldi07
aldi07
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
363
Dan Stoica
Dan Stoica
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
753
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
460
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top