Subform Recordset Not Linked After Import

[dr_destructo]

Here's what I have:
An accde in which I have a main for with a continuous subform.
I also have my original .accdb where I'm able to make changes to forms and such as neccessary as I'm doing some real-world testing.

So as I use my accde file, I input data as neccessary, and when I run into issues, I import my tables to my .accdb and fix what is needed.

This has worked perfectly until the last time I did this. Now my subform is not displaying the records associated with the main form. I've checked into the relationships in both my .accdb & .accde files and they're identical. Any thoughts on this would be greatly appreciated.

 

[boblarson]

1. Your database should be split - Backend (tables only and on server), Frontend (all other objects) and on each user's machine.

2. Backend would normally be an accdb file - no need to compile as there is nothing to compile.

3. Frontend you work on is the ACCDB file and then you convert it to ACCDE and distribute to the users (you can use an auto updater like referenced in my signature).

4. The master ACCDB is what you keep and work on. You would normally have a copy of the backend to attach to the master so you can do testing without affecting the live database and then relink when it is time to distribute.

5. If you have frequent changes to tables going on then I would say that your database is likely not properly normalized. Changes to tables should be very, very rare.

Does that help? There should not be any Importing of objects going on between your accdb file and accde file.

 

[dr_destructo]

Bob -
Thanks for the info, I will definitely be doing this. But, unfortunately it doesn't solve my current issue of why my continuous subform is not working correctly with my main form. Any thoughts on that?

 

[boblarson]

I've noticed that if you aren't changing the subform source via code - manually changing it, if you import a form and delete the old, it won't work unless you go in and manually select the source form again even if it is just selecting the same form from the list. Don't know why that happens, but it has happened to me before.