Go Back   Computer Forums > General Computing > Programming
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 01-05-2006, 08:58 AM   #1
Solid State Member
Join Date: Jun 2004
Posts: 11
Default Access2k taable relationship question?

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?


Access2mex is offline   Reply With Quote
Old 01-10-2006, 05:19 AM   #2
Site Team
root's Avatar
Join Date: Mar 2004
Posts: 7,872
Default Re: Access2k taable relationship question?

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.
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 03:41 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0