![]() ![]() To start viewing messages, select the forum that you want to visit from the selection below. You may have to register before you can post: click the register link above to proceed. Thirdly, you didnt mention the technology you want to use. You can map the share using both IP or UNC or use the file without mapping. Secondly, Access is basically just a flat file so what you need is access to the file itself. LINQ Provides links to topics that describe how to use LINQ with Visual Basic. Solution 1 First, if you have a choice, dont use VB6 which is a legacy environment. NET Provides links to pages on creating applications that work with data, using Visual Studio. Type or paste the following code: Note The sample code in this article uses Microsoft ActiveX Data. Accessing Data in Visual Studio Provides links to pages that discuss incorporating data access functionality into your applications. Note In Access 2007, click Module on the Insert menu in the Visual Basic Editor. ![]() Note In Access 2007, click Visual Basic in the Macro group on the Database Tools tab. Specify an SQL command in your SQL command string. VB6 and Access Database If this is your first visit, be sure to check out the FAQ by clicking the link above. On the View menu, point to Database Objects, and then click Modules. Open the connection with the following code: This example uses a database named "Public." If you don't know this information, you may need to contact your database designer or administrator.Ĭonnect.ConnectionString = "DSN=Public UID=MyUserName PWD=MyPassword " Send your database connection information to the connection object using the "ConnectionString" method. Create a set of variables in the VB6 file to hold database connection information, including a connection variable, a record variable and a string variable to store and send SQL commands:ĭim connect As ADODB.Connection Dim records As New ADODB.Recordset Dim com As StringĬreate a connection to the database through the "connect" variable on the next line: Enterprise Edition Support for Apex, COBOL, PL/I, RPG and VB6 Portfolio Management & PDF Executive Reports Project PDF reports Security Reports Regulatory.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |