Click here to Skip to main content
15,867,308 members
Home / Discussions / Database
   

Database

 
QuestionIndex on nvarchar column doesnot affect performance (sql server) Pin
Heba Kamel23-Oct-18 1:29
Heba Kamel23-Oct-18 1:29 
AnswerRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Richard Deeming23-Oct-18 1:58
mveRichard Deeming23-Oct-18 1:58 
GeneralRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Heba Kamel23-Oct-18 2:03
Heba Kamel23-Oct-18 2:03 
GeneralRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Richard Deeming23-Oct-18 2:04
mveRichard Deeming23-Oct-18 2:04 
QuestionMessage Removed Pin
21-Oct-18 23:35
dayakar_dn21-Oct-18 23:35 
Questionhow do i scan a image from a flat bed scanner using python and Microsoft access Pin
Member 1401815918-Oct-18 3:19
Member 1401815918-Oct-18 3:19 
Rant[REPOST] how do i scan a image from a flat bed scanner using python and Microsoft access Pin
Richard Deeming18-Oct-18 3:28
mveRichard Deeming18-Oct-18 3:28 
AnswerRe: how do i scan a image from a flat bed scanner using python and Microsoft access Pin
CHill6018-Oct-18 4:50
mveCHill6018-Oct-18 4:50 
Have you contacted the manufacturer of said scanner and asked them how to interact with it programmatically? Probably through an API that they would have to provide.

As things stand, I could probably tell you how to interact with my old scanner - but you can bet your bottom dollar it won't work for yours. So more detail would be needed.

As an aside, storing the actual scanned image onto your "database field" is probably going to be a very bad idea. The Access file is going to get very big very quickly. You should consider storing the image on the file system (it's what it is designed for) and storing a link to it on the database itself (hint - using explicit paths or drive mappings is not a good idea - a rather bitter experience with FileNet proved this to me in the past)
Generalthank you for your reply how you suggest i do it? Pin
Member 1401815918-Oct-18 20:52
Member 1401815918-Oct-18 20:52 
GeneralRe: thank you for your reply how you suggest i do it? Pin
CHill6021-Oct-18 2:20
mveCHill6021-Oct-18 2:20 
QuestionACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER Pin
Member 1401815918-Oct-18 0:41
Member 1401815918-Oct-18 0:41 
AnswerRe: ACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER Pin
Richard MacCutchan18-Oct-18 1:22
mveRichard MacCutchan18-Oct-18 1:22 
QuestionSQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion8-Oct-18 21:58
Hotaxion8-Oct-18 21:58 
AnswerRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming9-Oct-18 2:15
mveRichard Deeming9-Oct-18 2:15 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion9-Oct-18 15:20
Hotaxion9-Oct-18 15:20 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Victor Nijegorodov9-Oct-18 22:03
Victor Nijegorodov9-Oct-18 22:03 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion14-Oct-18 17:20
Hotaxion14-Oct-18 17:20 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming10-Oct-18 7:57
mveRichard Deeming10-Oct-18 7:57 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion14-Oct-18 17:23
Hotaxion14-Oct-18 17:23 
AnswerRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
CHill6017-Oct-18 5:05
mveCHill6017-Oct-18 5:05 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming17-Oct-18 9:04
mveRichard Deeming17-Oct-18 9:04 
QuestionNeed good, easy to manage "mail merge" program, free or not Pin
Charles Wolfe7-Oct-18 21:39
Charles Wolfe7-Oct-18 21:39 
AnswerRe: Need good, easy to manage "mail merge" program, free or not Pin
Victor Nijegorodov8-Oct-18 8:32
Victor Nijegorodov8-Oct-18 8:32 
GeneralRe: Need good, easy to manage "mail merge" program, free or not Pin
Charles Wolfe9-Oct-18 19:47
Charles Wolfe9-Oct-18 19:47 
GeneralRe: Need good, easy to manage "mail merge" program, free or not Pin
CHill6017-Oct-18 8:45
mveCHill6017-Oct-18 8:45 

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.