split database

[Guest]

I have a split database and have to make a change in one of the tables. The
only way I have been able to figure out how to do this is to
1) delete all linked tables (one at a time)
2) use Get External Data to import the tables back into the database
3) make the change in the table
4) then re-split the database.
Is there an easier way to do this? I have tried to just import the one
table, make the change, then export it back to the backend, but could not get
it to work.

Thanks -- Garry Gross

 

[Allen Browne]

Could you close the front end database, open the back end, and make the
changes there?

Then when you open the front end again, it will display the changes, and you
can then go on to modify any affected queries, forms, reports, and code.

 

[Albert D.Kallal]

I explain the issues of working with a split database here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

In the above, I explain how changes to tables need to be made...

 

[Guest]

Allen, Thanks, I did not realize you could open the backend seperately.
Makes it much easier.

Thanks again, Garry

 

[Larry Kahm]

Thank you for re=posting that link. I keep misplacing it.

Larry