Re: Split Database Difficulties
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Sun, 22 Apr 2007 22:27:25 +0800
In general, if you are altering the structure of the back end, you need to modify the front end in the same way.
Delete from the front end any table than no longer exists in the back end, and attach any new tables:
File | Get External | Link
It is possible to do it programmatically.
This query will give you the list of tables in the back end:
SELECT MSysObjects.Name
FROM MSysObjects IN 'C:\MyPath\MyFile.mdb'
WHERE ((MSysObjects.Type = 1)
AND (Not ((MSysObjects.Name Like "~*")
OR (MSysObjects.Name Like "MSys*"))))
ORDER BY MSysObjects.Name;
But in general you have access to the front end at design time, so it's not something that is commonly done.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Peter Hallett" <PeterHallett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ADA7C45D-0F1A-4F32-828D-C3276D1495B8@xxxxxxxxxxxxxxxx
This question must have been asked before, but I cannot see anything of
relevence in the present posts so forgive me if I am duplicating an earlier
query.
If a table in a back-end database is renamed then it is no longer visible to
the front-end. Presumably, the same will also be true if a new table is
added to the back-end. Is there a way of relinking the databases after such
changes are made to the back end? On-line Help is particularly ‘help-less’
in this area and the several 4 Kg Access manuals that I possess also seem
remarkably coy on the subject. The only solution I can currently think of is
to reimport the back-end into the front-end and then re-split it. Surely
not!?
--
Peter Hallett
.
- Follow-Ups:
- Re: Split Database Difficulties
- From: Peter Hallett
- Re: Split Database Difficulties
- Prev by Date: Re: Company and multiple addresses DB design
- Next by Date: Re: Split Database Difficulties
- Previous by thread: Company and multiple addresses DB design
- Next by thread: Re: Split Database Difficulties
- Index(es):
Relevant Pages
|
