A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

relationships



 
 
Thread Tools Display Modes
  #1  
Old August 11th, 2004, 11:35 AM
Maureen
external usenet poster
 
Posts: n/a
Default relationships

HELP!

I have an access 02 database, split frontend/backend
(backend is tables only) being run on an NT 2000 server
in a multiuser environemnt.

I have a company table, where all companies are stored
with a unique COMPID value, set to be the primary key;
indexed, no duplicates

I have an Inquiry Table, where all inquiries are stored
with a unique INQID value, set to be the primary key,
indexed, no duplicates.

When A company makes an inquriy - it gets recorded
through a form - which has the Inquiry table as it's
record source (through a query that sorts the records).
The company making the inquiry is recorded using the
COMPID code only - The query shows the COMPID code from
the INQUIRY TABLE - which is joined to the Company table
so all of the details about the company can be viewed on
the Inquriy form.

I have set up a one to many relationship (CompID Comapny
Table to CompID in the Inquiry Table) and enforced
referential integrity. So no inquiry can only belong to
an existing company - no inquiries to companyies that do
not exist (or so I thought).

I just found an instance where two users were inputting
companies and inquiries - something got screwed up and
the inquiry generated belongs to a companyID that does
not exist. It belongs to a company that one user was
trying to create at the same time but the company record
did not get saved - I have since modified the form to
SAVE RECORD once a company name has been typed in so I
believe that will improve this situation - BUT HOW DO I
HAVE AN INQUIRY BELONGING TO A COMPANY ID THAT DOES NOT
EXIST???


  #2  
Old August 11th, 2004, 01:11 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default relationships

Maureen

Are both front-end and back-end on the NT 2000 server?

--
More info, please ...

Jeff Boyce
Access MVP
  #3  
Old August 11th, 2004, 01:51 PM
Maureen
external usenet poster
 
Posts: n/a
Default relationships


-----Original Message-----
Maureen

Are both front-end and back-end on the NT 2000 server?

--
More info, please ...

Jeff Boyce
Access MVP
.
Hi Jeff,


Thanks in advance for your help.

Both the FrontEnd and The BackEnd are on the server -
HOWEVER the FrontEnd is also installed on the local PCs
of the multiple users - the users are supposed to use the
local frontend which links to the single backend on the
server.

I believe I had one user on the server's frontend and one
user on his local copy at the time data got mixed up and
an inquiry was generated with a CompID value that does
NOT belong to a current company.


  #4  
Old August 12th, 2004, 04:08 AM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default relationships

Maureen

Given the likelihood of corruption if more than one user "hits" the same
front-end (located on the server), the generally-accepted practice is to
never put the front-end on the server.

Distribute a "local" copy of the front-end to each PC/workstation.

--
Good luck

Jeff Boyce
Access MVP

 




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Disappearing relationships Dan Database Design 2 August 6th, 2004 06:43 AM
Not seeing all relationships in layout window jettabug General Discussion 3 June 18th, 2004 05:42 PM
Relationships SCHNYDES General Discussion 5 June 9th, 2004 11:21 PM
removing relationships. FFira General Discussion 1 June 4th, 2004 05:33 AM
Table Relationships Design Tom Database Design 1 May 5th, 2004 11:56 PM


All times are GMT +1. The time now is 01:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.