Go Back   Access World Forums > Apps and Windows > VB.NET

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-08-2016, 11:50 PM   #1
pratikshah2232
Newly Registered User
 
Join Date: Jun 2016
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
pratikshah2232 is on a distinguished road
.accdb database

Hallo All,

I am developing an app in VB:NET to access and modify .accdb database.

This is very heavy file (around 1GB) and I need to update it every day for around 100 times a day and around 100 queries each time.
This is making the process very slow.

Is there any possibility to speed up. Or is it possible that each time I need to update the database, I create a local copy in visual studio, then update it locally and then update the original database on server.

Here is the small sniplet of the code I am using to update database currently:
Private Sub ExecuteSQL(str As String)
myConnection.Open()
cmd = New OleDbCommand(str, myConnection)
Try
cmd.ExecuteNonQuery()
cmd.Dispose()
myConnection.Close()
Catch ex As Exception
Log_inputstring = ("Error - " & ex.Message)
Try
My.Computer.FileSystem.WriteAllText(LogFilePath, Log_inputstring & vbNewLine, append:=True)
Thread.Sleep(200)
Catch ex2 As Exception

End Try

Application.Exit()
Process.Start(Application.ExecutablePath)
End Try
End Sub

Your help will really be appreciated.

Thank you.
With best regard's,
Pratik Shah


Last edited by pratikshah2232; 06-09-2016 at 12:03 AM.
pratikshah2232 is offline   Reply With Quote
The Following User Says Thank You to pratikshah2232 For This Useful Post:
hassanogaibi (06-28-2016)
Reply

Tags
access database , vb.net , visual studio

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Replication database *accdb radek225 General 2 06-22-2015 12:35 AM
Database (.accdb) Password Recovery blackxsabah General 7 02-12-2015 10:56 PM
Can you convert a split database from mdb to accdb? bluetongue General 5 06-17-2012 11:55 AM
working fine in.mdb but not in .accdb database WalterInOz Modules & VBA 6 03-22-2011 06:35 AM
Question Access 2007 accdb creates Database.mdb Maritza General 0 08-17-2009 04:53 AM




All times are GMT -8. The time now is 04:36 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World