Access Questions


Fingerprint recognition in Java
i want a programing source code for fingerprint recognition time and attendance payroll system in java language and also the source code for capturing a fingerprint image and storing in ms access in java language for the same projcet

Answer Question   |  January 14, 2012  12:17 PM
Access, Fingerprint authentication, Java, Java programming, Source code
asked by:
5 pts.

how to use databases made in access or excel in sql
how to use databases made in access or excel in sql   importing readymade databases in sql

Answer Question   |  January 21, 2011  1:34 PM
Access, C#, excel, Import external data, SQL Server, SQL Server database
asked by:
5 pts.

Converting from Access 2003 to Access 2007
hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop’s. because of that diference i convert [...]

Answer Question   |  January 17, 2011  5:05 PM
Access, Access 2003, Access 2007, Access Database
asked by:
225 pts.

Print Preview and Printing Drops Pages from Reports
WE have been using the same ACCESS Database for 7 years.  Suddenly, worksheets and reports that have always printed out perfectly are not dropping entire pages; for example, if there are five pages of information, it will drop page 2-3-4 but print page 1 and 5.  What would cause that?

Answer Question   |  December 2, 2010  6:37 PM
Access, Access Database, Access Database Design, Access Functions
asked by:
5 pts.

How to pick a source for a subform in Access 2003?
I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A’s plainid the DB the user is in. To check the DB-A’s planid against DB-B’ plainid then use the [...]

Answer Question   |  November 29, 2010  2:13 PM
Access, Access 2003, Access 2003 forms, Access Database, IF statement, Microsoft Access subforms
asked by:
10 pts.

Get the latest unique entries for user ID in Access database
I have a database with a table that lists message entries. Each entry has an autonumber field ID, and a UID field that groups messages. My question is, how can I get the latest entry for each UID? Example Table: ID UID Message 1  1     Some Text 2  2     More Text 3  1     [...]

Answer Question   |  November 24, 2010  3:46 PM
Access, Access Database, Access Database Format, Access Tables
asked by:
5 pts.

Copy Table in SQLPLUS
How to copy a table from an access database using sqlplus

Answer Question   |  November 8, 2010  2:18 AM
Access, Access Database, SQL tables, SQLPlus
asked by:
5 pts.

SQL Server error 7125: Updated driver to get around?
I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs: #7125: The text, ntext, or [...]

Answer Question   |  November 2, 2010  5:32 AM
Access, ODBC, SQL Server, SQL Server error messages, SQL Server errors, SQLSRV32
asked by:
5 pts.

Importing a “flat” field into a Lookup Table format in SQL database
    * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated…).     * I have created a table called tblPurpose with the [...]

Answer Question   |  November 5, 2010  10:54 PM
Access, SQL, SQL Database, SQL Query, SQL Records, SQL Server Flat File Input
asked by:
5 pts.

Old Recovering Access database password
A client of mine worked on a database 5 years ago for a research project, but she had to quit for a while for cancer treatments. She’s now responded well enough to go back to the project but her database, done probably in Access 2003 (perhaps even an earlier version, but certainly not a later [...]

Answer Question   |  November 5, 2010  1:08 PM
Access, Access 2003, Database security, Password recovery, Windows XP SP3
asked by:
130 pts.

Total Balance for Concatenated Unique ID in Access and Excel
Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it against the [...]

Answer Question   |  October 29, 2010  2:05 AM
Access, compare reconciliation balance unique identifier, Concatenate, excel
asked by:
5 pts.

Green Boxes in Access 2007 form after deleting O’s & 1′s from database
I have a database tracking the information turned in on a hard copy form. If a patient triggers specific questions the data must be input: so if someone triggers the depression, I in their suicide rating, treatment plan, etc… I have the access form use check boxes but the data base use -1′s. I need the [...]

Answer Question   |  October 27, 2010  2:54 PM
Access, Access 2007, Access 2007 forms, Access 2007 functions, Access Database
asked by:
20 pts.

Developing a project using VB.net front end, and Access in back end
i m developing a project Using vb.net front end, and using ms access in back end,i would like in this project (with customer record save his photo in data base in vb.net5.0. when i add customer photo in form it is show with customer record How i could do this could u help me pls.

Answer Question   |  October 25, 2010  4:49 PM
Access, VB.NET, VB.NET 2005, Visual Basic developers
asked by:
5 pts.

Creating Access table
How do I create an ERDiagram from this table of information? Table=CUSTOMER- Customer_ID LastName FirstName Address PhoneNumber ContactNumber Email Address and add the following tables with this information: Table names: COSIGNEE -DRIVERS- PICKUPMANIFEST-DELIVERY_TRUCK_DETAILS-DELIVERY_MANIFEST

Answer Question   |  October 18, 2010  8:04 PM
Access, Access Database, Access Database Design, Access Tables, Database design, ER diagrams, Windows 7
asked by:
5 pts.

Converting text to number for calculation in Access 2003
I have a field that stores time taken as text i.e. 5 mins, 10 mins,15 mins, half hour – for various kinds of activities. I need to do a report that calculates the total time taken for each activity – which means converting to number somewhere along the line. Any ideas?

Answer Question   |  October 20, 2010  1:19 PM
Access, Access 2003, Access 2003 forms, Access Functions
asked by:
25 pts.

How to implement crosstab query in Access?
How to implement crosstab query

Answer Question   |  September 23, 2010  4:24 AM
Access, CrossTab Query, SQL Server, SQL Server 2000
asked by:
75 pts.

How to update a row in grid view?
how to update a row in grid view when changes made to database..

Answer Question   |  September 16, 2010  11:09 AM
Access, DataGridView, GridView, GridView RowUpdating, VB .NET, Visual Basic .NET
asked by:
5 pts.

Software application to build database
I’m Planning to build an application to store/update and retrieve data (say employee details) Could you please suggest me the best frontend and backend technologies to build this application?

Answer Question   |  December 14, 2010  6:26 PM
.NET, Access, Database, Database frontend, Java, Visual Basic, Web development, Web development tools
asked by:
5 pts.

Exceeding maximum record locks in Access
i have written code to import information from several text files into a linked table. It works fine for a while, but eventually I always get an error about exceeding the maximum allowed locks. I do not want to change the registry – i would rather just not have any locks (because I don’t need [...]

Answer Question   |  August 26, 2010  4:17 PM
Access, Access Records, INSERT statement, Windows XP
asked by:
25 pts.

Subquery in Microsoft Access
[em]   Trying to create a subquery for a table in Access.   I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the  table, and don’t want to create another [...]

Answer Question   |  August 20, 2010  7:13 PM
Access, Access query, Access Tables, Subquery
asked by:
5 pts.