how can microsoft Access help us?
924500
Um, it's a database. You put data in it. You query data and get reports. You stick them on the net and have dynamic websites. Databases do that. However, this is Access we're talking about which is an unmitigated pile of crap. The only thing Access helps is the sale of painkillers when users repeatedly punch themselves in frustration.
462677
You can use Tables from MS Access or MS SQL Server Already loaded with Data
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.
571274
are you updating each individual person? the best way would be to create a database using MS ACCESS that will allow you to update individuals through a GUI system. You use a lookup to find the information of the individual which will be shown through the GUI and then edit them with the changes. Its easier than using a spreadsheet and faster as well.
304461
In Microsoft Access, it's the column that links different databases, it's typically the most important column.
474365
You can do this with Microsoft Outlook.
950967
Basically MS-Access is for small scale industries/businesses - thats what microsoft itself is claiming. MS Access cannot handle records more than say a few thousands. I myself have experienced it - after 80000 records - MS Access really struggles. However MS SQL Server is quite capable of handling large number of records/data - so does ORACLE.\n\nFor your requirement, MS Access will be just fine.
578192
answer is here http://www.access-programmers.co.uk/forums/archive/index.php/t-30557.html
238602
Microsoft Knowledge Base has the answers you seek.
187676
Your best bet would probably be a list of checkboxes to match each question.\n\nOnce all the checkboxes have been filled in then submit the form and all the information gets transfered to a database.\n\nDo this as a standalone webpage with a DB backend. Probably something like mySQL or SQL2k, SQL2003 would be your best bet as Access only supports 10 connections at a time and you may overload this if you have multiple people entering data at the same time.
470488
MS Access comes with some sample databases.  Other than that, you just have to look for some.
396944
Access 97 supports only limited SQL queries. Most of these can be generated with the query designer functionality in Access, but if you want to access the database using more advance SQL commands, try writing a VB program to do it and use an OLEDB jet connection. Then you get whatever functionatily you want on it.\nGood luck!
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
1127319
we used microsoft ACCESS here at work; this program is very powerful and will help you organize, see and print information on customers or other records in a variety of forms, this is useful if you have data that you'll be inputting yourself electronically\n\nif you have a lot of paper that you want to store electronically the way to go would be to get a high-speed, high quality scanner (these can be leased) and either buy a big file server or burn the stuff to CDs
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
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
766570
To connect to an MS Access databse use this code:\n\n<CFQUERY NAME="rs" \n DBTYPE="dynamic" \n CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)};Dbq=c:&#92;db&#92;mydb.mdb;Uid=Admin;Pwd=;"\n>\nSELECT SeekId, SeekUsername, SeekPassword from Seekers\n</CFQUERY> \n\nIncase you wan't to use an extended path use this code. \n<CFQUERY NAME="rs" \n DBTYPE="dynamic" \n CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)};Dbq=#ExpandPath('..&#92;bettergig&#92;cgi-bin&#92;bettergig.mdb')#;Uid=Admin;Pwd=pass;"\n>\nSELECT SeekId, SeekUsername, SeekPassword from Seekers\n</CFQUERY>\n\nBoth the connections that I have described above are DNS-less connection or ready-to-connect. So you need not setup any DSN.