•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 397,846 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,437 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser:
Views: 1888 | Replies: 6
 |
•
•
Join Date: Jul 2007
Location: bangalore
Posts: 42
Reputation: 
Rep Power: 2
Solved Threads: 3
Light Poster
How can i access data from MS Access using VB6 (I need the connection code) How can i access data from MS Access using VB6 (I need the connection code) can u plz tell me the code for accessing tables in MS Access using Visual Basic 6. my access tables are in a server not in my local computer..... plz let me know the code
•
•
Join Date: Nov 2006
Posts: 709
Reputation:
Rep Power: 3
Solved Threads: 95
Master Poster
Hi,
Get Connection String here:
http://www.connectionstrings.com/?carrier=access
Change the Path to Server Path.
Regards
Veena
Get Connection String here:
http://www.connectionstrings.com/?carrier=access
Change the Path to Server Path.
Regards
Veena
•
•
Join Date: May 2007
Location: India
Posts: 493
Reputation:
Rep Power: 2
Solved Threads: 45
Posting Pro in Training
'using connection object
'in general section
dim conn as adodb.connection
dim rs as adodb.recordset
'in form load
set conn=new adodb.connection
set rs=new adodb.recordset
conn="provider=microsoft jet.4.0.oledb;data source=<ur database name>;persist security info=false"
conn.open
rs.open "select *from ur tablename",conn,adopendynamic,adlockoptimistic
'in general section
dim conn as adodb.connection
dim rs as adodb.recordset
'in form load
set conn=new adodb.connection
set rs=new adodb.recordset
conn="provider=microsoft jet.4.0.oledb;data source=<ur database name>;persist security info=false"
conn.open
rs.open "select *from ur tablename",conn,adopendynamic,adlockoptimistic
•
•
Join Date: Jul 2007
Location: bangalore
Posts: 42
Reputation:
Rep Power: 2
Solved Threads: 3
Light Poster
will this work for a database which is in a server not in my local computer
•
•
Join Date: Jul 2007
Location: bangalore
Posts: 42
Reputation:
Rep Power: 2
Solved Threads: 3
Light Poster
thanq mr.choudhuryshouvi
will that work for a database which is in a server not in my local computer...
will that work for a database which is in a server not in my local computer...
•
•
Join Date: Nov 2006
Posts: 709
Reputation:
Rep Power: 3
Solved Threads: 95
Master Poster
Hi,,
Add "Microsoft ActiveX objects 2.0" References to the project. Share the Folder in Server With Full Access.
use this code:
Dim rs As New ADODB.Recordset
Dim AC As New ADODB.Connection
With AC
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\ShareFolder\db1.mdb;Persist Security Info=False"
.Open
End With
ssql = "Select * from MyTable"
Set rs=Nothing
RS.Open ssql,AC
REgards
Veena
Add "Microsoft ActiveX objects 2.0" References to the project. Share the Folder in Server With Full Access.
use this code:
Dim rs As New ADODB.Recordset
Dim AC As New ADODB.Connection
With AC
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\ShareFolder\db1.mdb;Persist Security Info=False"
.Open
End With
ssql = "Select * from MyTable"
Set rs=Nothing
RS.Open ssql,AC
REgards
Veena
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Linear Mode
•
•
•
•
access activation adsl adsl1 adsl2 adsl2+ api blogger blogging blogs broadband cable code combo connection dani daniweb data data transfer development dreamweaver dropdownlist gdata google hardware html innovation internet key linux microsoft module net news openbsd product programming reuse rss second serial storage tags vista web wikipedia wysiwyg xml 240000
- VB6 and MS Access Problem (Visual Basic 4 / 5 / 6)
- MS Access and other applications on VB6.0 (Visual Basic 4 / 5 / 6)
- VB6 Access error Please Please Help !!! (Visual Basic 4 / 5 / 6)
- Pls help me regarding to access database in vb6 (Visual Basic 4 / 5 / 6)
- Change Access Title in VB6 (Visual Basic 4 / 5 / 6)
- VB6 and MS Access 2002 (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: .:: Web Login Help ::.
- Next Thread: sending mails using Visual Basic 6
