Access2k taable relationship question?

[Acccessme]

Hi everyone,

I am new with access and I am wondering how the table relationship travels with the application. I separated my application to front and back-end, I keep my data on the server and the program I move a copy in each user's PC. If i make a change on the relation ship that's on the server it should work for all the user right?

Thanks

 

[root]

I think that the simple answer is no.

it's fine to keep your tables on the server, but if you are distributing a front end by linking the data source to the server, then relationship changes won't reflect in the clients, since the table structure is saved in the client copy, even though the data tables are not.

that is unless I misunderstand what you are doing.