Question about Microsoft Visual Basic 6.0 for PC
I want to retrive data from password protected access database through VB can any one help me with code
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;" & _
Posted on Apr 22, 2009
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Jan 03, 2014 | Pc America Restaurant Pro Express
on Jul 12, 2010 | Computers & Internet
Oct 03, 2010 | Nokia 3110 Cellular Phone
Mar 09, 2009 | Microsoft Press MS Access 2000 and Visual...
Jan 07, 2009 | Computers & Internet
Dec 30, 2008 | Computers & Internet
Dec 10, 2008 | Computers & Internet
Sep 30, 2008 | Project Justice for Dreamcast
Aug 18, 2008 | Microsoft Office Access 2003 (077-02871)...
153 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: