• Microsoft Access table dropped primary key and index

    I am using MS Access 2007 on Windows XP Professional. The main table in my Purchase Ordersdatabase has dropped its primary key and index (no duplicates). Previously, it worked without any problems, and caught duplicate values. Now, when I try to reset the primary key, I get the message, "The...

    Swd14420 pointsBadges:
  • T-SQL query to ACESS 2007 database

    I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

    DamMan5 pointsBadges:
  • Access – Bound sub form trying to set the value of an unbound field

    I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

    TJay85 pointsBadges:
  • database saves to new file

    Hi all. Why would an access database save to a new file each time it is worked on? Mine keeps saving to db1, db2, db3, etc.

    Shazzie70 pointsBadges:
  • Microsoft Access Audit Report

    I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...

    WayneW194720 pointsBadges:
  • table from gridviewwith sql vs2008

    hello, help, i have a access database with menu items--id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the headings...

    Zpupster65 pointsBadges:
  • With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?

    With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form when...

    Swd14420 pointsBadges:
  • Access Database Capacity

    What is the data volume that an Access Database can effectively handle?

    Tlee10 pointsBadges:
  • MS-Access

    Hi all, I'll try to describe the problem in a simple way: I once created an Access DB with everything necessary, e.g. mdb, mdw and then put them all in a shared network file something ununderstandable happened: a colleague, whom I granted ONLY read-access, click on the DB he could write in the...

    PIEGR10 pointsBadges:
  • Query showing vbCRLF in string data

    Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....

    Sandisk25 pointsBadges:
  • Retrieving Records based on Record Selection from another table

    I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...

    Tjlevin10 pointsBadges:
  • Performance Issue with an Access File Updated through an .accde file with Linked Tables

    I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...

    EngTech5510 pointsBadges:
  • How a S/W in c# working in N/W accesses access database from other computer not having access

    hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn't have ms-access, then how will i connect to it and run my project?

    Fairy5 pointsBadges:
  • Access Course/Student Database

    I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with...

    AccessFlunky50 pointsBadges:
  • Access Database update question

    So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database it...

    Tgoody30 pointsBadges:
  • Autopopulating following fields

    I have created my first Access database form, and now when I enter data into some fields, it autopopulates the three following fields. If I enter data in one of the following fields, it changes all of the other fields. It seems that my fields are all connected to the same row in my tables. How can...

    Dknielson5 pointsBadges:
  • AccessDataSource and ‘?’ parameters asp.net

    I have been stuck on something for days and wondering if anyone can offer any help. I am using an Access Database, so i am using the accessDataSource in asp.net I drag and drop an accessdatasource on the form, and also a datagrid. This is a simple datafile with 2 fields. An ID and an EmailAddress....

    OrangeMiro20 pointsBadges:
  • Trying to learn – How to filter dates…

    I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only get current dates needed. I need to know a way...

    Beginner095 pointsBadges:
  • Date a specific record in Microsoft Access

    I have a database where I would like to specifically date a record when a value/change is made in one of the fields of the record. Specifically, my database has addresses for donation solicitation, and I wish to date a donation made by a receipient at a particular address. So, basically, if I...

    Sfd41065 pointsBadges:
  • Update Access Databse

    How do I set up web application, using classic Asp to update access 2002 database?

    VicB5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following