Click here to Skip to main content
15,569,768 members
Home / Discussions / Database
   

Database

 
QuestionAlert when row deleted (SQL Server 2012) Pin
Member 1151899220-Apr-15 3:03
Member 1151899220-Apr-15 3:03 
AnswerRe: Alert when row deleted (SQL Server 2012) Pin
Tim Carmichael20-Apr-15 3:14
Tim Carmichael20-Apr-15 3:14 
AnswerRe: Alert when row deleted (SQL Server 2012) Pin
David Mujica20-Apr-15 4:31
David Mujica20-Apr-15 4:31 
GeneralRe: Alert when row deleted (SQL Server 2012) Pin
Member 1151899221-Apr-15 0:44
Member 1151899221-Apr-15 0:44 
QuestionDebugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 14:20
Kyudos14-Apr-15 14:20 
AnswerRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 15:11
professionalMycroft Holmes14-Apr-15 15:11 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 15:27
Kyudos14-Apr-15 15:27 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 16:19
professionalMycroft Holmes14-Apr-15 16:19 
It is the same with SQL Server and has always been an irritant. With SQL Server you have sql profiler and you can trap the actual statement passed to the database including data. You can then manually execute the command in management studio. This gives you a more detailed error response and you can use the mark I eyeball to inspect the data.

I know you can execute sql strings in Access but I do not know where to trap the command passed to the database from the client.

I would strongly suggest moving the database from Access to SQL server if possible.
Never underestimate the power of human stupidity
RAH

GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 16:41
Kyudos14-Apr-15 16:41 
AnswerRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 17:02
Kyudos14-Apr-15 17:02 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 18:37
professionalMycroft Holmes14-Apr-15 18:37 
QuestionHow to remove a 1000 seperator from a number Pin
Ambertje14-Apr-15 1:35
Ambertje14-Apr-15 1:35 
AnswerRe: How to remove a 1000 seperator from a number Pin
Jörgen Andersson14-Apr-15 2:30
professionalJörgen Andersson14-Apr-15 2:30 
GeneralRe: How to remove a 1000 seperator from a number Pin
Ambertje14-Apr-15 3:04
Ambertje14-Apr-15 3:04 
GeneralRe: How to remove a 1000 seperator from a number Pin
Mycroft Holmes14-Apr-15 15:15
professionalMycroft Holmes14-Apr-15 15:15 
Questionhow to write xml code to manually create pdf without using third party in oracle apex Pin
Member 1159668313-Apr-15 20:28
Member 1159668313-Apr-15 20:28 
QuestionVB.NET MYSQL loop through records while adding Pin
Pauls Pauls13-Apr-15 10:40
Pauls Pauls13-Apr-15 10:40 
QuestionRe: VB.NET MYSQL loop through records while adding Pin
ZurdoDev13-Apr-15 11:09
professionalZurdoDev13-Apr-15 11:09 
AnswerRe: VB.NET MYSQL loop through records while adding Pin
Pauls Pauls13-Apr-15 11:48
Pauls Pauls13-Apr-15 11:48 
AnswerRe: VB.NET MYSQL loop through records while adding Pin
Mycroft Holmes13-Apr-15 15:21
professionalMycroft Holmes13-Apr-15 15:21 
GeneralRe: VB.NET MYSQL loop through records while adding Pin
Pauls Pauls13-Apr-15 21:09
Pauls Pauls13-Apr-15 21:09 
GeneralRe: VB.NET MYSQL loop through records while adding Pin
Mycroft Holmes13-Apr-15 21:39
professionalMycroft Holmes13-Apr-15 21:39 
GeneralRe: VB.NET MYSQL loop through records while adding Pin
Pauls Pauls14-Apr-15 2:47
Pauls Pauls14-Apr-15 2:47 
QuestionPICTUREBOX IMAGE IN VB.NET Pin
Pauls Pauls13-Apr-15 1:18
Pauls Pauls13-Apr-15 1:18 
AnswerRe: PICTUREBOX IMAGE IN VB.NET Pin
Corporal Agarn13-Apr-15 1:35
professionalCorporal Agarn13-Apr-15 1:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.