Objects Are Weird After Unsplitting the DB

[ALewis06]

I split a db then had to undo it in order to make some changes to a some tables. Now that I rejoined the front and backends, some of the objects are behaving peculiarly. For instance when I go into the design of a macro, the window opens minimized. When I maximize it, it opens up in the database window but too much--the object window is so big that the minimize/maximize/close options are hidden; I can't see them.

If I open a report, in report view, same thing.

Is there anything I can do about this? Or is it just one of those quirky things that happen as a result of rejoining a split db that I have to live with?

 

[pbaldy]

I've not experienced or heard of that type of problem, but wanted to make sure you realize you didn't have to unsplit the db. You get everybody out of it, make the necessary changes to the back end table(s), then relink changed tables in the front end (via the Linked Table Manager).

 

[HiTechCoach]

Try setting the Access Options >> Current Database >> Document Windows Options >> select to Tabbed documents not overlapping windows.

FWIW: I start every database split. I will only work on a database that is split.

I would NEVER "rejoned" a database. I have never found a single good reason or need to import the tables back into the front ends so it is un-split. Just the opposite ... every data needs to be split for development.

My thoughts: Splitting your Access database into application and data