You are here:

Visual Basic/Access and Data Report

Advertisement

Expert: Golfnut_1969 - 3/2/2008


Question
Sir,
Please, may I know the number or records that a table in MS Aceess can contain?

I am having problem with using two or more commands(parent and Child(children) of a DataEnvironment on one Data Report form.Can you help me with the step by step approach?

I hope you can help me. Thanks in advance.

Ben Ayawli

Answer
There is no limit on the number of records per se, however your table is limited to 2 GB in size (minus the space used for system objects). So the number of records you could insert into a table is going to depend upon the size of each record.  

I don't understand the second question.

Visual Basic

All Answers

Answers by Expert:

Ask Experts

Volunteer

Golfnut_1969

Expertise


Instantiating form variables instead of using Global instances.
User Defined Types
DLLs, ActiveX Exes
String Manipulation
Working with Classes
Custom User Controls
Object Oriented Programming
Database access (SQL Server, MS Access, RDO, DAO, ADO)
Use of Arrays

I do not answer questions regarding databound controls so please ask those questions of one of the other experts.

Experience

I've been working with Visual Basic 5.0 and 6.0 for over 8 years. I've worked extensively with multi-tier database business solutions created in Visual Basic. I've also been working in Visual Basic .NET for over 2 years and Visual Basic .NET 2.0 since its first BETA release. I currently work developing custom applications for a variety of industries. In addition to all the work in Visual Basic 6.0 and .NET I have also worked extensively with ASP .NET and ASP .NET 2.0.

Education/Credentials
Associate’s Degree: Computer Programming St. Louis Community College at Florissant Valley (4.0 gpa) Microsoft Certified Technology Specialist (MCTS) .NET Framework 2.0 Windows Applications

Past/Present clients
Mallinckrodt Pharmaceuticals Commerce Bank CitiMortgage Elmwood Marine Services FedEx Memco Barge Lines Crounse Corporation AG Edwards

©2012 About.com, a part of The New York Times Company. All rights reserved.