Results from MS ACCESS?
477569
try this query: select count(*) from tablename\nit will returns 73421.
39144
It's been a number of years since I worked with Access, but the answer above will work if the database is on another machine and you ONLY want to access the data over the network.  If, on the other hand, you need to download the .mdb to a laptop and take it on a plane, for example, I seem to recall there was an Access 'run time' option.  In that case, you'll probably want to compile your .mdb into a .mde file.  See the source(s) link.
117899
Have you tried Crystal XI - they have extended their db access methods. However you could always use ODBC or OLEDB...
185737
Try:\n\nhttp://www.accessmylibrary.com/
123133
Microsoft Access is a great prototyping tool.  If you are building an Enterprise level system for thousands of users, you are going to run SQL Server or Oracle.  But, during the design, you can design the tables and relationships in Access and throw together a few forms in minutes and show the customer "what/when/where/how" very easily.  Then, when they say, "no, I want it to do this", you modify it quickly and show them the next idea.\n\nGenerating a visual "working" sample application is all about what prototyping is - and Access is a great tool...
294787
A database will work very well for what you need. MS Access is the only one I have personal experience with. I'm sure there are better apps out there. Create a query based on the cert expiration date and run it as needed.
747603
Depending on where you are (the main form or the subform) and what you need to access, there are several different ways of doing this.  Check out the forum archives at:\n\nhttp://www.access-programmers.co.uk/forums/archive/index.php/t-77746.html\n\nto see how to do this.  I grabbed the text and saved it on my hard drive so I could get to it later; this cheat sheet really helps!\n\nPS: This is a MS-Access question, not a VB 6 question.  MS-Access uses "VBA" (vb for applications), VB6 has a compiler and it's own form editor.
459913
Excel has that limitation.\n\nLook into using MS Access instead.
793099
Works Database ? never heard it. its somekind like Microsoft Access?\n\nBut try to learn SQL. http://dev.mysql.com/doc/\nit's a powerfull language for database
1085254
1. create create a table in MS ACCESS and save it with the extendsion of .mdb\n2. open the control panel and select the ODBC data sources\n3. a window opens in that click Add\n4. another one opens in that select Microsoft Access Driver(*.mdb)\n5.click finish\n6. a window opens enter the data source name\n7. click select and search the database that u have created in the MS ACCESS  and then click ok\n8. then in vb place the adodc control and datagrid\n9. right click the adodc and select adodc properties\n10. in that select use odbc datasource name\n11. it will be displaying various name select the data source name u have entered\n12. then click the recordsource\n13. select the command type as 2-adcmdtable\n14. select u r table name\n15. click ok\n16. click the data grid and in the properties \nset the data source as adodc1(adodc name)\n17. run the program and u can find the information in the datagrid
324282
Access is great for "light duty" database work. If you've just got a few users, and you're not dealing with hundreds of thousands (millions is *really* pushing it) records, Access is fine.\n\nProblem is, Access is a file-based database, and, as a user, you pretty much have to open and wade through the entire file to find the records you need.\n\nOracle is a server-based database, so when you interact with it, you send a request to the server, which probably still wades through one or more huge files, but it does it very efficiently :-), and only sends the data you care about back to you.\n\nIt's better suited for large numbers of users, heavy usage and large numbers of records.
717820
Well, accessing the ms access database directly from j2me might be very dificult.\n\nWhat i would suggest is that you interface the two with a web scripting language (ASP, PHP, ASP .NET or JSP).  ASP and ASP .NET might be easier since they are also created by microsoft. I tried that myself also.\n\nSo, after interfacing the Webpage with the Access, you can access the Access data using your cellular phone by connecting to the web page.  Use the HttpConnection Class of J2ME in accessing the webpage.\n\nGood Luck!
643171
This forum will probably lack the comprehensive information you need.  The materials provided with the Access program can get you started, however I suggest visiting a book store for a "How TO" instructional book.\n\nDo a search for "Microsoft Access" on amazon.com as a starting point.\n\nOn the web, research these sites:\n\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr051202.htm (About Databases)\nAccess Database Too Big! \nAccess Database Too Big!\nhttp://databases.about.com/b/a/222380.htm (About Databases)\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr060902.htm (About Databases)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 2/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401b.htm (About Delphi Programming)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 1/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401a.htm (About Delphi Programming)\nBuilding an Access Database From the Ground Up \nIn this series of ten Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/od/buildinganaccessdatabase/index.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals \nhttp://databases.about.com/b/a/139756.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals\nhttp://databases.about.com/b/a/243511.htm (About Databases)\nBuilding an Access Database From the Ground Up \nIn this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm (About Databases)
126717
Access has limits in it's database it's not ment to be a bussiness database thats what sql is for...\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
924206
to display the records from Sales table and Purchase table, do like Monalisa said, but he/she missing 'WHERE' query.\n\nassume :\nCreate Table Sales (Sales_Date date, total integer);\nCreate Table Purchase (Purchase_Date, total integer);\n\nSelect Sales_Date, Total from SALES where\nSales_Date>='10/03/2006' and Sales_Date<='10/09/2006'\nunion all\nSelect Purchase_Date, Total from PURCHASE where\nPurchase_Date>='10/03/2006' and Purchase_Date<='10/09/2006'\n\nNotes :\n'UNION' will eliminate the same records from PURCHASE table.\nto get all records we must use 'UNION ALL' .\n\nTo sum sales and purchase in 3rd to 9th oct  :\n\nSelect sum(A.Total) as TotalSales, sum(B.Total) as TotalPurchase from SALES as A, PURCHASE as B where A.Sales_Date>='10/03/2006' and A.Sales_Date<='10/09/2006'\nand B.Purchase_Date>='10/03/2006' and B.Purchase_Date<='10/09/2006'\n\nps :\nmy query format maybe have a little different with ms Access query format, so if my query can't run in ms Access, try to change it to ms Access query format.
1015496
Access has the "forms" but I forget how to use it.