Recent content by doj

Well I am completley flummoxed now. I created all my tables again in a new database,got all the relationships set up ok. went to insert information and i get these four faults: type conversion failure, key violations, lock violations validation rules violations. The code that i am using came...

Hello again, I am now trying to insert information into my tables. 1 I have checked that all spellling is correct, 2 made sure all fields are the same length, the code acceptable: I think? INSERT INTO Booking (Booking_No, Crown_Court_No, Case_No, Startdate, Enddate) VALUES ('B001'. 'C001'...

Hi again, How would you set up a primary key with two fields? The notes I have had off my lecturer werent very good i am afraid. thanks again doj

Another problem I've been trying to create another table, it requires two primary keys this is the code that I have inserted CREATE TABLE Defendant_and_Case (Case_Number_No TEXT(5), Defendant_Number TEXT (5) CONSTRAINT Case_Number_pk PRIMARY KEY CONSTRAINT Defendant_Number_pk PRIMARY KEY)...

HI Technellie, thanks for all the help. All i am aware of at the moment is that i have to add the code for the names addresses etc in the way shown. It seems to be very time consuming, i will create the information in excel and try and send it over? hope i can come back and get more advice...

HI Keith, I've only been study database for a very short time and am not upto speed on all the things that i should:o :o what actually is a record set? Would it help me to imput more than one line of data at a time? or would one query at a time make things easier in the long run? thanks...

thanks keithG and Technellie, I did what you said and found that technellie was right it didnt work. And my lecturer gave me that as an example. Anyway another question. Can i enter more than one line at a time?I'm trying this but it doesnt seem to work INSERT INTO Student ( Student_No, Name...

Hi all, I am creating tables in SQL view in Acess, Have managed to create the tables, but am having a little trouble understanding what to do next? I have an INSERT statement to add names, addresses etc, but cant seem to get it to work. I am trying to insert into the SQL view in queries, thats...