Is there a way to open another Access DB from within an already open Access DB? After updating my back-end I would like to call the front-end to process the updated data.
Is there a way to open another Access DB from within an already open Access DB? After updating my back-end I would like to call the front-end to process the updated data.
Yes, You can open other databases from within your current database.
Here's a demo
But I'm not sure what this really meansCode:'--------------------------------------------------------------------------------------- ' Procedure : testdb ' Author : Jack ' Created : 12/8/2009 ' Purpose : Test opening second A2003 database. '--------------------------------------------------------------------------------------- ' Last Modified: ' ' Inputs: N/A ' Dependency: N/A '------------------------------------------------------------------------------ ' Sub testdb() Dim dbsCurrent As DAO.Database Dim dbsSecond As DAO.Database Dim tbl As DAO.TableDef 10 On Error GoTo testdb_Error 20 Set dbsCurrent = CurrentDb 30 Set dbsSecond = DBEngine.Workspaces(0).OpenDatabase("c:\users\mellon\downloads\EquipInventoryOrLocation.mdb") 40 Debug.Print dbsCurrent.name 50 Debug.Print dbsSecond.name 60 For Each tbl In dbsSecond.TableDefs 70 Debug.Print " " & tbl.name 80 Next 90 Debug.Print Now() 100 On Error GoTo 0 110 Exit Sub testdb_Error: 120 MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure testdb of Module Module5" End Sub
From within your frontend, you could open the second database, get whatever info you need and execute some process that could update your backend. This would imply 3 databases:After updating my back-end I would like to call the front-end to process the updated data.
-your frontend (that you would open first)
-the second database from which you need some info
-the third database (your backend) which contains the tables (linked) that you want to update.
But maybe I have misunderstood your intent.
If the front-end and back-end are already linked, I don't think that would be necessary. The changes should be evident immediately, You may just need to close your object and re-open it to refresh the data.
I have weekly letters to print from the Front End after the Back End is updated. I'm trying to set it up so someone not familiar with Access can process the letters. I have written instructions so that same someone can update the Back End first. It would be nice if the didn't also have to locate and open the Front End. This is a :Nice to Have" option, not "Must Have".
I just need to print letters from the Front End after the Back End is updated. Only two files are involved.
What, then was the importance of opening a second database?
If you have a split database -which means every user has their own copy of the FRONT END on their PC, and there is a single BACK END database on a server. The FRONT END is linked to the Tables in the BACK END. There are no tables in the FRONT END.
Please explain what is involved in the Updates.
Where does the data to be used for the update come from?
How does the update process work --step by step?
How does the process of printing letters work -- step by step?
Download data from a website to Excel (7 files in all):
Absences
Excused Absences
Tardies
Class schedules
Currently active students (SDE)
All students enrolled since the start of the school year (SDE_YTD)
Each file is imported into Access (appended to the appropriate table)
Other subordinate files student ID's appended to them using SDE
The SDE_YTD is not needed for the letters.
However data from the other files is required for all absences and tardies and classroom numbers and sessions (we have 3, AM Mid and NT)
We have 6 campuses that require individual letters for students getting letters (adult age >18, minor <19)
Hope that helps the understanding.
Please remember, I have some users that don't have a clue about Access, so I have to try to make it as much point and click as possible.