Access Front End database

[Guest]

Currently, I have an existing Access database which includes a front end
"user interface" and a back end. I am attempting to update the front end mdb
file using the back end mdb file. Can this be done? If so, How?

 

[aaron.kempf]

Access Data Projects are a much much simpler, yet more powerful--
program

-Aaron

 

[Guest]

Hi Anthony,

Can you explain exactly what you mean by "update the front end mdb file
using the back end mdb file."


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Vinson]

Currently, I have an existing Access database which includes a front end
"user interface" and a back end. I am attempting to update the front end mdb
file using the back end mdb file. Can this be done? If so, How?

I'm not at all sure what you're asking!

"Update the frontend mdb file using the back end mdb"????

What are you trying to update? Normally the frontend does not contain
ANY data, just links to the backend. If you make structural design
changes (say to the Forms or Reports) in the frontend, you just junk
the old frontend and give the user a new, updated one linked to the
same tables. The backend database doesn't play any part in this
process - you just need to be sure that the links in the new frontend
point to it correctly.

John W. Vinson[MVP]

 

[Guest]

Thank you for responding Tom . . . Let me see if I can explain this properly.
What I am referring to as the Front End is only for the User who inputs data.
There are no options for editing or linking data. This file is named MPT.mdb
The file I refer to as the Backend contains only tables (MPT_be.mdb). The
issue I'm having is I think some of those tables are linked to some of the
opening dialog screens on the Front end file. I tried to make some additions
to the backend tables and they do not show up on the front end file.

Maybe I'm approaching this in the wrong way . . . I am a newbie.

Any suggestions?

 

[Guest]

Hi Anthony,

I tried to make some additions to the backend tables and they
do not show up on the front end file.

By additions, do you mean that you added one or more new tables? If so,
open the front-end database. Then use File > Get External Data | Linked
tables... Navigate to your back-end database, select it, and press the Link
button. Select the new table(s) in question. Press the OK button.

On the other hand, if you meant that you added new fields to an existing
linked table, then they should normally show up. However, it is always a good
idea to delete linked tables in the FE database, compact the DB, and then
re-establish the linked table using the method in the above paragraph. This
should be done whenever you make any design (not data) changes to a table in
the BE database. Design changes include adding/removing fields,
setting/changing/removing indexes, including any changes to the primary key.
The reason that this is important is that Access can cache a lot of
information about the table structure in the FE database, and this
information can become out-of-date.

Does this help?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Peter Hibbs]

Anthony

If you want to add new tables and/or fields to the BE structure, have
a look at my BE Update Utility.mdb at :-
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S
which can do this for you automatically. You will need to enter a
little bit of VBA code however.

Good luck.

Peter Hibbs.

 

[aaron.kempf]

unnecessary complexity is neither simple nor necessary

use Access Data Projects

it's plug and play

-Aaron