Hi all,
I am having problems with some ms access mdb queries that used to work
fine up to about two weeks ago. All they now do is lock the database
(produce an ldb file) or say there are key violations. Nothing has
changed to the asp pages or the database so I am scratching my head
(amongst other things) to work out what the problem is - any help much
appreciated to restore sanity! I even get the same errors when I try
the sql statements below on a local copy of the database (its about
50mb) on my local machine.
sql1
-----
INSERT INTO students (StudentID, School_id, EntryDate, Postcode,
NoStudents, nickname, age, sexmale, sexfemale, schoolyear, Distance1k,
Distance2k, Distance3k, Distance5k, Distance6k, Youcycle, TrainPass,
FamilyNocar, FamilyOneCar, FamilyTwoCar, approved ) Values ('ta0837gte
sldkf',76,#1/5/2005#,'sldkf',4,'test',10,4,0,'7',0,0,0,0,4,4,0,0,4,0,True)
;
sql2
------
INSERT INTO surveydata (StudentId, Schooldetails, EntryDate,
Direction, NoWalk, NoCycle, NoScBus, NoOtherBus, NoTrain, NoCar,
NoOther, PrefWalk, PrefCycle, PrefScBus, PrefOtherBus, PrefTrain,
PrefCar, PrefOther, CountOwn, CountAccompany, CountAdults,
CountFriends, CountMixed, approved) Values ('ta0837gte
sldkf',76,#1/5/2005#,'to',4,0,0,0,0,0,0,0,0,4,0,0,0,0,0,4,0,0,4,TRUE) ;
tbl structure
--------------------
Download in Word format here -
http://www.youngtransnet.org.uk/dbstructure.doc
Thanks,
Richard
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
