Question about Microsoft Visual Basic 6.0 for PC

1 Answer

Retrieving acess data which is password protected thru VB

I want to retrive data from password protected access database through VB can any one help me with code

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 289 Answers

You will need to use a connection string. But - before you can configure the string correctly, I'd need to know how the data is stored (Access, SQL, ODBC, etc). You can find examples online. Just know that you are looking for "Connection String." Here's two examples:
1. For MS Access (Jet files):
' Set up the connection string.
m_strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strDestDBPath & ";" & _
"Jet OLEDB:Engine Type=5" ' NOTE: Use Type=5 for Jet 4.x.

2. For SQL database:
g_strADOConn = "Provider=SQLOLEDB;" & _
"Data Source=SERVER_NAME;" & _
"Initial Catalog=DATABASE_NAME;" & _
"User ID=mssql_userid;" & _
"Password=mssql_password;"

Posted on Apr 22, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Could not retrive datatable


hi robert,
it looks like one of two things. both are serious. your SQL master table is corrupt or the cresql table is missing or corrupt. cresql is rpe's data tables. if you have a good backup, you could try to restore it and see if your problem is fixed. otherwise you need database help. i'm available if you would like to discuss this.
sysadmin@ccybernet.com
Feel free to email me with more details if need be.

Jan 03, 2014 | Pc America Restaurant Pro Express

Tip

Access Password Recovery 5.0


MS Access is one part of Microsoft Office Package and it is one of the most popular database programs used in millions of offices worldwide. Password protection is an important feature that limits access to authorized personnel only and prevents strangers from obtaining confidential data. Unfortunately, people do lose or forget their passwords, making it impossible to access that data. Luckily, it does not mean that the data is lost forever. Access Password Recovery 5.0 will help the user to recover lost or forgotten passwords for MS Access database files. http://www.recoverlostpassword.com/products/accesspasswordrecovery.html

on Jul 12, 2010 | Computers & Internet

1 Answer

Password forgot


give Police IT nearest to you for retrieval it might help.
otherwise remove the casing and slave to a computer for data retrival.
thnks

Jun 26, 2013 | Transcend (660955) External Drive

1 Answer

What is the compatible database for visual basic 6.0?


Microsoft Access uses the Jet Engine. In VB 6, you can create a data connection using ODBC or OLE DB. Here is an example of OLE DB:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourAccessDB.mdb;User Id=;Password=;" Good luck

Mar 09, 2009 | Microsoft Press MS Access 2000 and Visual...

1 Answer

How to link database to vb 6.0


make sure that you have ODBC drivers that match the database you want to get data from. Often there is security involved and the correct ODBC driver will prompt you for security information to get at the desired data and handle the necessary protocols to exchange data

Jan 07, 2009 | Computers & Internet

1 Answer

How to add columns(Vertical) only in Msflexgrid from database table using VB.


you have to open your current project in VB then go to "add references" (its somewhere in the menu bar) then go find microsoft acess and add it as a reference. then go to object browser and you'll find all the functions you need to interface between your project in VB and MS Access.

good luck !!!

Dec 30, 2008 | Computers & Internet

1 Answer

Code for find the Ms access database size using visual basic


The way to get the database size is to point to the directory that the database is do a DIR statement with an output to a file as in DIR payroll.mdb>dbsize.txt and then read from the text file, the first field of the second line being the name (which you really don't need) then the size value of the database.

To import the text files using VB 8 use

'Imports System.Data.OleDb Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\path\filename.mdb") Dim cmd As New OleDbCommand("SELECT * INTO [import] FROM [Text;Database=d:\path;Hdr=No].[dbsize.txt]", conn) conn.Open() cmd.ExecuteNonQuery() conn.Close()

Nov 10, 2008 | Microsoft Office Standard for PC

1 Answer

Database connectivity


Hello,
Please follow the link below to help with connecting to a database and displaying data using visual basic.
http://www.freevbcode.com/ShowCode.Asp?ID=1257

Please let me know if you have any questions.
Thank You, Raph30

Sep 30, 2008 | Project Justice for Dreamcast

1 Answer

How to use passwd character in a table in ms-access 2003


When you create table where you want to store passwords, go to Edit Table, then select a field where the password will be stored, go to Input Mask field in Properties and type Password in that field. That will set up the field needed for storing passwords.

Aug 18, 2008 | Microsoft Office Access 2003 (077-02871)...

Not finding what you are looking for?
Microsoft Visual Basic 6.0 for PC Logo

149 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...