mavtcr | The Blog Pros

Copying a database file from C drive to a pendrive

I have developed a software in VB6. I want to give a menu option for back up. ie. to copy the database files to a pendrive
I have given the below code

 Dim sourcefile,Destinationfile as string
  sourcefile = App.Path & "\HHA.mdb"
  Destinationfile = Textdrive.text & "\HHA.mdb"
  Filecopy sourcefile,Destinationfile

  When worked out the above code -Permission Denied - message is displayed.

  My source file="C:\My Documents\HHA\HHA.mdb"

  When I changed my source file to "K:\HHA\Support\HHA.mdb"  - the copying worked well.ie. From the C drive copying is not allowed
  Any body can help me? Any idea...

October 13, 2020

To count the number of months programmatically

I developed a programme in VB for recording my income and expenditure on a daily basis.I started recording from 5th , September ,2019. On 31 March , 2020 I want to know how many months I have recorded the transactions.Here it is September,October,November,December,January,February,and March=7.
How can I get this answer -7 by running the programme.Please anybody help me to write the code for this.

September 22, 2020

How to create help menu in VisualBasic programne

I have developed a software in VB. I want to add a help menu.Please help

GBase 8a Implementation Guide: Resource Assessment
No categories
1. Disk Storage Space Evaluation The storage space requirements for a GBase cluster are calculated based on the data volume of the business system, the choice of compression algorithm, and the number of cluster replicas. The data volume of a business s... […]
A Look Into Netflix System Architecture
No categories
Ever wondered how Netflix keeps you glued to your screen with uninterrupted streaming bliss? Netflix Architecture is responsible for the smooth streaming experience that attracts viewers worldwide behind the scenes. Netflix's system architecture emphas... […]
High Availability and Disaster Recovery (HADR) in SQL Server on AWS
No categories
High Availability and Disaster Recovery (HADR) play a vital role in maintaining the integrity of data, reducing downtime, and safeguarding against data loss in enterprise database systems. AWS offers a range of HADR options for SQL Server, which levera... […]
Terraform Tips for Efficient Infrastructure Management
No categories
Terraform is a popular tool for defining and provisioning infrastructure as code (IaC), improving consistency, repeatability, and version control. But you need to know how to use it properly to extract maximum value from it as an infrastructure managem... […]
Integration Testing With Keycloak, Spring Security, Spring Boot, and Spock Framework
No categories
In today's security landscape, OAuth2 has become a standard for securing APIs, providing a more robust and flexible approach than basic authentication. My journey into this domain began with a critical solution architecture decision: migrating from bas... […]

Proudly powered by WordPress