Stack Overflow
Stack Overflow

Questions tagged [ms-access-2003]

Microsoft Access 2003 - a rapid database application development tool - Use this tag for questions specific to Microsoft Access 2003. Also use the more generic [ms-access] tag for general MS Access questions and [access-vba] for questions involving MS Access Visual Basic for Applications

Office 2003 reached end of support on April 8, 2014. If you haven't already begun to upgrade your Office 2003 environment, Microsoft recommends you start now. MS Access is a member of the MS Office suite of applications, included in the current Office 365 edition.

Use this tag for questions specific to Microsoft Access 2003. Also use the more generic [ms-access] tag for general MS Access questions and [access-vba] for questions involving MS Access Visual Basic for Applications

803 questions
0
votes
2 answers

How to find last used date for .mdb file in C#

We have .mdb files of MS Access 2003 and we have to find out last date when this database was used. We have to do it programmaticly like read .mdb file and find out last used date. Also we need to figure out last modified and date of database…
user2525155
  • 15
  • 4
0
votes
1 answer

Create record and INSERT INTO with Constant field & Variable field data

Within VBA, in Access 2003, I need to Create a record in TableA with a new AutoNumber as the primary key (AID) and the current date Create several records in TableC which associate AID from the new record in TableA with multiple foreign keys (BID)…
QtheNovice
  • 95
  • 3
  • 13
0
votes
1 answer

Working with Outlook using MS Access 2003 - VBA

I've made the following program that takes a list of email addresses from a table in MS Access and sends each a test email. Here is the code: 'Get data back from field birth date Set fld = rcdSet.Fields("Email Address") 'Subject …
Katana24
  • 8,706
  • 19
  • 76
  • 118
0
votes
1 answer

MS Access 2003 - Really simple query

If I try to duplicate an access file (this file is split into mdb and be mdb, and also has mde files), by importing everything into a brand new access application, why won't the table links work? Everytime I click anything it says that the tables…
Justin
  • 4,461
  • 22
  • 87
  • 152
0
votes
1 answer

Adding the value of a combobox to a hidden column when a user enters a new record in Access 2003

I have a table with a 'category' column, a form which hides the category column, and a combobox to filter the category, let's say R, C, and F. I want to have the value of the comobox applied to the hidden 'category' column when a user enters a new…
user2682696
  • 1
0
votes
2 answers

Performance comparison for SWITCH vs IIF?

Background: migrating legendary Excel Reporting projects into MS Access for the very need of database structure. Limitation: Development environment is within Excel and Access. Due to large chunks of data processing and keeping of moving n-Months…
bonCodigo
  • 14,268
  • 1
  • 48
  • 91
0
votes
1 answer

MS Access 2003 Company Report

I'm running MS Access 2003, and I am not that familiar with it. The database tracks billing for companies and their line of business. Company ID's are matched with LoB ID's. On a report, for example, the company might be GAP and LineofBusiness may…
Mark C.
  • 6,332
  • 4
  • 35
  • 71
0
votes
2 answers

SQL replace value in a field in a row if it exists, else create a row and populate that value

My request is a little strange and specific, please bear with me. I have an Access 2003 database with a Comments table that has several hundred thousand lines in it. There are several fields - let's call them A, B, C, D and comment. Columns A-C form…
nclfrk799
  • 35
  • 1
  • 8
0
votes
1 answer

Rename a file with FileSystemObject while looping through files

As a preface, I'm writing code in Access 2003, but will have users using Access 2013, and so I need it to be compatible for both. I have a loop that uses the Application.FileSearch to loop through a number of files in a directory. It is my…
Michael T
  • 1,745
  • 5
  • 30
  • 42
0
votes
1 answer

Finding the difference between the results of two queries in Access 2003

I would like to create a query in Access 2003 that combines two queries to find the difference between the results. Query 1: [all] SELECT mars.Name, mars.Location, mars.Business_Unit FROM mars GROUP BY mars.Name, mars.Location,…
user2617010
  • 1
  • 3
0
votes
0 answers

Inserting a record on a form based upon a query

I haven't done much in Access for years, but I have picked up a bit of support work to help out. Database is an Access 2003 one, running on 2010 in compatibility mode (Behaviour was the same on 2003 though) with the data in a SQL Server 2005…
Carlovski
  • 121
  • 4
0
votes
1 answer

can i save a report / form in access 2003 to PDF format?

I know this is easily done in access 2010 by using ConvertToPDF, there is however no option for this in 2003. How did people save to PDF before version 2007 onwards? Also if this could be done without needing to download any extra .dll that would be…
germantom
  • 405
  • 2
  • 6
  • 15
0
votes
1 answer

Storing hashed password in Ms access?

After hashing a password (SHA256) what data type must i use in MS access to save the hashed password, i am using the code from "http://www.codeproject.com/Tips/186585/Password-Storage-How-to-do-it", he says to use a "varbinary" column, but that is…
user1955810
0
votes
1 answer

VBA - Unwanted Listcount Representation Changes Based On Selection

I'm using Access 2003 to develop an application where a user can dynamically generate a query, and then browse through a listbox with the results of their GUI defined query. I allow the column heads to show which counts as an extra row in the…
Elias
  • 2,602
  • 5
  • 28
  • 57
0
votes
1 answer

Microsoft.ACE.OLEDB.12.0 for MS Access 2003

I'll be specific here... my database is designed in Access 2007 with an .accdb extension.... I deployed my application where Office 2003 is installed.. I know the simple thing would be to just install Office 2007 on the machine. But is there any…
Abeer Islam
  • 33
  • 1
  • 2
  • 7
1 2 3
…
53 54