Solved

SQL With Access97

Posted on 1998-08-19
6
206 Views
Last Modified: 2010-03-19
Hi,
I have created 2 tables in SQL server
t_Procedure and t_ProcedureSub
In access i have created a form (DataSource=t_Procedure) with subform (DS=t_ProcedureSub)

Every thing is ok.

but when i enter data in sub-form and come back to view it again the records show #DELETED where as if i use Isql/w Query and write select * from t_ProcedureSub all records are saved.

Why is access showing #DELETED?

THANKS IN ADV.
msa
0
Comment
Question by:msali
  • 3
  • 3
6 Comments
 

Accepted Solution

by:
shaloo earned 20 total points
Comment Utility
#DELETED usually indicates that the table you have attached has had a change in structure since you last attached it.  Try deleting the attached tables and re-attaching them.
0
 

Author Comment

by:msali
Comment Utility
I have figured out the problem.  It might be what u r saying but in my case it was different.  In my case when i defined the table i had 4 field in my table - i had unknowingly in my sql statement had identified all four field as primary keys.

thanks for you answer.  i am still going to reward you the points since your answer will help me in near future.  

ps. i am new at sqlserver and am using PowerSoft's Data Architect to design databases in  SQL Server with Access 97.  


0
 

Author Comment

by:msali
Comment Utility
Hi,
I have got the answer on my own but i will be awarding you the points since the solution u gave me might be useful to me next time;
btw: in my case while defining the table in sqlserver i had unknowingly (since i am new at sql server) identified all fields as primary keys. once i remvoed them as pks it is now working just fine.

on the other hands i have lot other questions for instance (just a recomendation) i have a procedure table with 3000 procedures defined in it; currently i have 20 customers and the rates for all customers are diferent for every procedure i.e., every customer must have their unieque 3000 procedure prices (Procedure defs are the same except for prices).  what is the best way to handle it (RECOMMENDATIONS ONLY)
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Expert Comment

by:shaloo
Comment Utility
msali, I don't fully understand the performance impact of 3000 procedures being repeated 20 times but could you not rewrite all procedures to call 1 procedure for the rate and based on 2 parameters (customer name and product) it could send out the price.  This procedure could either access a separate table or else just be a series of IF statements?
0
 

Author Comment

by:msali
Comment Utility
Ok here i go:
It is a hospital that performs 3000 different procedures e.g., ECG, Blood Test, Urine Analysis(Complete or Partial) etc...etc...
We have 20 companies on or customer list who get treated for same procedure but have settled different rates with each coustomer. and yet there are customers who are not from our member customer list but otherwize e.g., walk-in patients or other referals etc.

So what i was thinking was having a standard procedure table for regular customers and a special table for every customer.  When a patient comes in we know what company it is from and if that company is on our list.  if so that company's procedure table is attached with the customer chart.  (makes sence or no)

thaks any way.
0
 

Expert Comment

by:shaloo
Comment Utility
yes, what you said sounds like a good way to do it.  it is certainly not the most efficient as far as db design goes but certainly acceptable and easy to use.  To be most efficient you woudl hve a master table with procedure id, name and default price and a second table with the procedure id, customer id, and actual price.  In the firs table the procedure id would be autonumber and unqiue in the second table the procedure id would be a long number.  on the second table put a combined index on both the id fields and your queries will be faster enough also.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now