Click here to Skip to main content
15,894,825 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: how to pass a two dimensional dynamic array in a function Pin
DaveAuld7-Sep-10 4:41
professionalDaveAuld7-Sep-10 4:41 
GeneralRe: how to pass a two dimensional dynamic array in a function Pin
jainiraj7-Sep-10 4:46
jainiraj7-Sep-10 4:46 
GeneralRe: how to pass a two dimensional dynamic array in a function Pin
DaveAuld7-Sep-10 5:11
professionalDaveAuld7-Sep-10 5:11 
GeneralRe: how to pass a two dimensional dynamic array in a function Pin
jainiraj7-Sep-10 22:53
jainiraj7-Sep-10 22:53 
QuestionHOW TO SET Crystal Sub report Paper source Pin
Anoop Brijmohun7-Sep-10 0:50
Anoop Brijmohun7-Sep-10 0:50 
QuestionHow to show that Datagridview is Enabled/Disabled. Pin
Sam Martini6-Sep-10 22:48
Sam Martini6-Sep-10 22:48 
AnswerRe: How to show that Datagridview is Enabled/Disabled. Pin
Tom Deketelaere7-Sep-10 0:09
professionalTom Deketelaere7-Sep-10 0:09 
QuestionMS Access database not closing Pin
Charles Wolfe6-Sep-10 19:43
Charles Wolfe6-Sep-10 19:43 
I have a VB application that updates one database using input from another database. The code looks like:
Dim InputDC as OldDatabaseConnection
Dim OutputDC As ...
InputDC.Open
OutputDC.Open
For each table in Input Database
Read data from old table
Copy data to new table
Write new table to Output database
...
InputDC.Close
OutputDC.Close

Sometimes [often] the Output database does not close, that is the Output.ldb file is left hanging around for an indefinite time period. Sometimes the program runs fine e.g. 50 times in a row; then suddenly it will hang. I've been programming for 45 years and have done consulting and know the first rule is that "Users lie about no changes"; however in this case there ARE no changes to the code. The program wants to rename the data bases so that Input.mdb becomes Input_Old.mdb and Output.mdb becomes Input.mdb. With the control file (Output.ldb) hanging around, the Rename causes an exception. It is [almost] always the Output.ldb file that is still around implying that Output.MDB is still open...

I have taken the code apart line by line; there is only one open and close per database. There are closes within Catch paragraphs. But, there is only one .Open per database.

I've tried a variety of loops testing for the .ldb to go away, but this usually just results in the program running for a very long time doing nothing. When the program is terminated thru its main form's Exit button, the .ldb files go away almost immediately. I can watch the history of file creation, etc. in Windows Explorer as the program runs.

Has anyone experienced this "feature"? If so have you figured out how to solve it?
Charles Wolfe
C. Wolfe Software Engineering

AnswerRe: MS Access database not closing Pin
David Mujica7-Sep-10 3:40
David Mujica7-Sep-10 3:40 
AnswerRe: MS Access database not closing Pin
Luc Pattyn7-Sep-10 3:43
sitebuilderLuc Pattyn7-Sep-10 3:43 
AnswerRe: MS Access database not closing Pin
Member 195743615-Nov-10 1:53
Member 195743615-Nov-10 1:53 
Questionhow to use compare function Pin
zhiyuan166-Sep-10 19:37
zhiyuan166-Sep-10 19:37 
AnswerRe: how to use compare function Pin
Dave Kreskowiak7-Sep-10 1:50
mveDave Kreskowiak7-Sep-10 1:50 
AnswerRe: how to use compare function Pin
Luc Pattyn7-Sep-10 2:05
sitebuilderLuc Pattyn7-Sep-10 2:05 
QuestionHow to store a string in Byte array in hex form Pin
jainiraj4-Sep-10 23:49
jainiraj4-Sep-10 23:49 
AnswerRe: How to store a string in Byte array in hex form Pin
Dave Kreskowiak5-Sep-10 3:17
mveDave Kreskowiak5-Sep-10 3:17 
QuestionREgarding sending data when using socket winsock Pin
jainiraj4-Sep-10 20:38
jainiraj4-Sep-10 20:38 
AnswerRe: REgarding sending data when using socket winsock Pin
Dave Kreskowiak5-Sep-10 3:13
mveDave Kreskowiak5-Sep-10 3:13 
QuestionHow to interact a Context Menu with a web browser... Pin
thebiostyle4-Sep-10 11:31
thebiostyle4-Sep-10 11:31 
AnswerRe: How to interact a Context Menu with a web browser... Pin
Mycroft Holmes5-Sep-10 13:06
professionalMycroft Holmes5-Sep-10 13:06 
GeneralRe: How to interact a Context Menu with a web browser... Pin
thebiostyle5-Sep-10 13:34
thebiostyle5-Sep-10 13:34 
QuestionRegarding long data type .. Pin
jainiraj4-Sep-10 2:43
jainiraj4-Sep-10 2:43 
AnswerRe: Regarding long data type .. Pin
DaveAuld4-Sep-10 4:15
professionalDaveAuld4-Sep-10 4:15 
AnswerRe: Regarding long data type .. Pin
Luc Pattyn4-Sep-10 4:29
sitebuilderLuc Pattyn4-Sep-10 4:29 
GeneralRe: Regarding long data type .. Pin
jainiraj4-Sep-10 20:21
jainiraj4-Sep-10 20:21 

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.