Unlink tables in a split database

[Gail]

Hi All,

I have an Access database to recording Incident and Injury
data which we have not long commenced using. The database
has been split to front end and back end. I am now faced
with needing to increase the size of a field in one of the
tables and discovered that the tables are linked and I
cannot make changes to the field properties. How do I go
about unlinking and subsequently relinking the table which
contains the field I need to enlarge.

All help greatly appreciated.
Gail

 

[Albert D. Kallal]

Actually, all you need to do is change the length of the field in the back
end, and then the front end will "see" this change.

In fact, all table design changes do have to be done in the back end part.
It is for this reason that often during the initial stages of development,
we do NOT split.

After you start getting closer to a production version of the application,
then you usually find that the number of table changes settles down to a
fairly low level. This is usually the time we then split, since not too much
change will occur in the back end.

However, it is fair to point out that it is MORE work to have to go to that
backend to make table changes. However, this amount of extra work is off set
by all the other savings in terms of ease of development, updating new code
etc that a split arrangement gives.

 

[Guest]

Thanks, I knew it had to be something simple I was
overlooking.