Click here to Skip to main content
14,771,119 members
Home » Discussions » Database
   

Database

 
GeneralRe: Database ADO exception on adding new record Pin
Richard MacCutchan16-Oct-20 5:53
mveRichard MacCutchan16-Oct-20 5:53 
AnswerRe: Database ADO exception on adding new record Pin
CHill6016-Oct-20 6:18
mveCHill6016-Oct-20 6:18 
Quote:
This happens after a couple of hundreds of thousends writes.
Access is probably not the best database of choice for that many records to be honest.

How big (size on disk) is your .accdb file? There is an absolute maximum size for an Access database of 2GB - you may need to consider linked tables to bring the size down
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 2:58
MemberPeter Mortier19-Oct-20 2:58 
AnswerRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 3:00
MemberPeter Mortier19-Oct-20 3:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 8:07
MemberVictor Nijegorodov19-Oct-20 8:07 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 9:40
MemberPeter Mortier20-Oct-20 9:40 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov20-Oct-20 10:29
MemberVictor Nijegorodov20-Oct-20 10:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh14-Oct-20 0:17
Memberkarengsh14-Oct-20 0:17 
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 23:37
MemberMember 1260015012-Oct-20 23:37 
AnswerRe: Should I store files in a database? Pin
Richard Deeming12-Oct-20 23:54
mveRichard Deeming12-Oct-20 23:54 
QuestionMYSQL Pin
Member 147129666-Oct-20 11:21
MemberMember 147129666-Oct-20 11:21 
AnswerRe: MYSQL Pin
ZurdoDev6-Oct-20 11:34
professionalZurdoDev6-Oct-20 11:34 
QuestionDatabase scripts version control process/strategy? Pin
Member 1363071429-Sep-20 7:06
MemberMember 1363071429-Sep-20 7:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 8:48
MemberDavid Mujica29-Sep-20 8:48 
AnswerRe: Database scripts version control process/strategy? Pin
ZurdoDev29-Sep-20 10:05
professionalZurdoDev29-Sep-20 10:05 
QuestionSimple Database design Pin
fdanos23-Sep-20 21:23
professionalfdanos23-Sep-20 21:23 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 21:54
MemberVictor Nijegorodov23-Sep-20 21:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 13:18
professionalMycroft Holmes24-Sep-20 13:18 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 3:35
professionalfd97507-Sep-20 3:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 5:18
professionalJörgen Andersson7-Sep-20 5:18 
GeneralRe: Why does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 22:14
professionalfd97507-Sep-20 22:14 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 8:03
professionalZurdoDev21-Sep-20 8:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 15:51
Memberrodgerm25-Aug-20 15:51 
AnswerRe: How to use a FileInfo control to add a filename to an Access database Pin
Richard MacCutchan25-Aug-20 22:16
mveRichard MacCutchan25-Aug-20 22:16 
QuestionDATABASE KEY Pin
Member 1492238425-Aug-20 1:42
MemberMember 1492238425-Aug-20 1:42 

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.