Back end relationships overwritten?

[paradiso]

Greetings,

I made adjustments to the table relationships in the backend database and printed out the relationship diagram. Next day I opened the frontend and encountered a bug that I suspected was a result of one of my changes. I opened the backend and -- no trace of the work I had done the day before. Were they overwritten?

There are some tables on the relationship diagram in the front end. Should I delete them? I know relationships should be set in the backend, but thought any stray tables listed in the front end made no difference.

Has anyone experienced this oddity? I'm working in Access 2003. All the tables in question were on the tables relationship view in the backend, and they are linked into the frontend.

thanks,
p

 

[LittleSmudge]

The Back End file is 'the back end' file.

You can have any number of Front Ends linked to some, none or all of the table in the BE.
You can make all sorts of changes in any of those FEs but they won't affect the BE schema etc.

If you make changes in the BE relationship window then you do need to save those changes.
Is there any chance that you clicked on No when asked about saving changes to the Relationship Window ?

Is there any chance you have a second ( backup ) copy of the BE that got swapped over ?

The fact that your FE has thrown up an error based on the chagnes you've made to the BE schema suggests that the BE did indeed save the schema changes.
Whether that is reflected in the Relationships window is another matter entirely.


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[paradiso]

Dear friends,

It's not that the relationship structure is being overwritten, it's that changes are not being saved.

Here is my observation:
I am creating a database description document and am creating screenshots of table relationships to explain them. I am using a separate copy of my back end file for the purpose. I place a number of tables onto the relationship layout form, relate them, save and exit. Later I realize I want to make some changes. I open the relationship form, delete one table and add one or two more. Save the layout and close the form.

Open the form again and the change has not stuck. The deleted tables are there, and so are the ones I added. Try another change, save, and this time exit the database. Reopen and the original relationship layout, complete with relationships, is there. My changes do not stick.

Truth be told I don't take much stock in this relationships form, and I create SQL updates to enforce what Access promises to do through this form, but nevertheless, this is scary.

Has anyone else noticed this?

regards,
p

 

[willir]

delete one table and add one or two more

If you are deleting and adding tables, you need to re-link the tables. The Access Front End database will not know about tables being added to the back end database.

Question:
If you are making changes to the back end so much, are you ready to be using a front end? Personally, I will develop with the back end database until I an satisfied with the database design will I split the database to the backend and frontend database.

Richard