Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

Access how to find the data from vb to access

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 13 Answers
Re: access

From the database menu, click Modules, and then Design. Let me know if that helps.

Posted on Jan 11, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

How to link vb 6.0 to msaccess?

You Need ODBC to solve your link... ODBC is a gateway. Can Access by Microsoft Access or VB in same time... Note: Please in Code Programming you must lock or unlock you data if you want application running same time..

Jul 20, 2009 | Microsoft Business & Productivity Software

1 Answer

Adodb connection

In VB6 you would use ADODB. This is for ADO and is used for accessing data (read, write, update, etc.) from different data sources. Your connection string will vary based on the data source you need to connect to. Here is an example for a SQL connection:

"Provider=SQLOLEDB;Data Source=your_server;Initial Catalog=your_database;User ID=sa;Password=your_password;"

For VB.NET you would be using the ADO.NET toosl and a connection string as well.

Apr 27, 2009 | Business & Productivity Software

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

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)...

1 Answer


Use this line below:

Private Sub CommandButton_Click()

Dim NumericValue as Integer
Dim StringValue as String

NumericValue = CInt(TextField1)
StringValue = TextField2

DoCmd.RunSQL "INSERT INTO NameOfTable ( [FieldName1], [FieldName2]) VALUES (" & NumericValue & " , '" & StringValue & "');"


I Hope this work for you... God Bless

Jul 16, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Accessing data

Dear reader

Place an ADODC control on your form in VB.
In the properties of the ADODC control goto the TAB General.
click "Use Connection String. With the button Build you can point to your database.
Thats it.

With the following code you can connect to db:

With Adodc
.RecordSource = "SELECT * From YOURTABLE"
End With

Now you have the table in the adodc control.

you can now do this:

Label1.caption = Adodc.Recordset!YOURFIELD

YOURTABLE = the name of your table in the database.
YOURFIELD = the fieldname in YOURTABLE you want to show.

Kind regards Fred.

Jul 04, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Crystal reports in vb 6.0

The short answer is you can't do exactly what you have asked. There are many long answers. Here goes an overview. The data in VB is what you want to report on, that data is in a data base and Crystal Reports is the primo solution.
When you have it working CR and VB will be sharing the same data. VB crunches it and CR tells the world.
Get into CR design mode, for the fields in the reports tell it to use the db you have created and populated using VB .
All of the above is tough and unforgiving. I took a 2 day crash course on CR and left the training with nothing but two large manuals. VB has been my Nemesis for many years.

Jun 24, 2008 | Microsoft Business & Productivity Software

1 Answer

MS Access and application

You probably need to be inserting the value of a text object (ie, a String) , not the object itself. In VB.NET, a String object is an actual, not unlike a Java String object. In "classic" VB, a String object isn't really handled by the interpreter as an object in the C# / Java sense, so it can be referred to directly without resolving the value via a method call. So attempting to insert an object reference into a database field from C# code will probably not work unless the database knows to call toSting() on the object, which I am 99.99999% sure it cannot (depends on the database-- in this case Access, and more particularly, what version you are using, and if there is any .NET framework interoperability).

Calling myString.toString() though returns a String object in C#, so using that is likely not going to work. What you may need to do is return a character array using the 'chars' and 'length' properties of the C# String object.

Finally, after all this, your problem could be a lot simpler: the value(s) you are trying to insert may not be right for the field-- check the length of the values being inserted, etc. Use .trim() to eliminate leading and trailing whitespace, for example. If you post your INSERT statement and an example of the data you are using, I may be able to tell you more. Also, you are in ASP.NET and data transfer from web containers to Access databases is notoriously bedeviled work.

Mar 07, 2008 | Business & Productivity Software

1 Answer

Update record with two table

have an Access 2003 database that appears to be very corrupt.
I was having a problem and did a compact and repair on it, and I
lost my network connection during the process. Now when I try
to open it (or access it via DTS, VB, anything I can think of),
I get

"The Microsoft Jet database engine stopped the process because
you and another user are attempting to change the same data at
the same time".

I have rebooted the machine that was accessing it, and no
help. I can't reboot the server now because it's a 24/7 file
server. Is there any way to get this database open? I have
searched and found a bunch of demo programs that will
"uncorrupt" it and show some data (but not save it), so I know
it's possible, but is it possible without buying one of those

Jan 08, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Import excel sheet in 5

you have to make link in you vb then you can save the xls files on same format

Oct 08, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

Related Topics:

28 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides