Are you using the BDE to connect to the SQL Server? If so, why not use ADO? Also, its not a permissions problem on the table thats causing error? You have checked its not trying to access a field that is misspelt or something?
Jeremy -----Original Message----- From: "Eion McIntosh (Christchurch)" <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Mon, 4 Nov 2002 12:33:46 +1300 Subject: [DUG]: SQL Access error > Hi > > I have an app which connects via ODBC to an SQL database on a WIN2k > server, > which depending on the 4 parameters passed, automatically starts, runs > and > prints 1 of 7 reports. > One of the reports is creating an access violation against IDAPI32.dll > when > opening one of the tables. > If the program is run manually, ie a form appears to put in the > parameters, > it works fine. The same table is used in most of the other reports and > they > all run automatically ok. It's just this one which does not. > I've checked the assignment of the tablename and index, and they appear > ok. > The permission against the tables are all ok, so I'm unsure what to try > an > check next. > > Any ideas please? > > Eion McIntosh > PPCS Ltd > > > ####################################################################### > ############## > This e-mail message has been scanned and cleared > ####################################################################### > ############## > ----------------------------------------------------------------------- > ---- > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
