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
-1
votes
1 answer

Difference between access 2003 runtime and access 2003 LI

What is the difference between access 2003 runtime and access 2003 LI regards Anna
Anna Smith
  • 57
  • 2
  • 2
  • 7
-1
votes
1 answer

Automatically adding ID number from different table to new entries?

So I'm entirely new at Access, and have only a very elementary background in SQL and general database stuff, but I've been asked at work to build a small database with book titles and authors. I've got a table of authors, who've got auto numbered…
Uuseer Naamee
  • 3
  • 1
-1
votes
1 answer

Linked SQL table in Access 2003 (!) not updatable

I'm working in a legacy app for the moment, upgrading Access 2003 to link to SQL Server tables (2008 R2 or later). With tables linked by code, I can insert, but not update or delete. I've tried everything on the web, no dice. Details below. Being…
Ed The Dev Prog
  • 21
  • 4
-1
votes
1 answer

How to Solve DLL error in access

I am developing an Excel project in Access using VBA. My project is working in Access 2007, but it does not work in Access 2003. If I try to run the file, it shows the DLL error. Anyone know how to debug this error?
raam
  • 7
  • 1
  • 3
-1
votes
1 answer

UCanAccess driver throws Exception when trying to connect with Access database while Jackcess connection works fine

1) This UCanAccess sample code works with database A (Access 2000) Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); Connection conn = DriverManager.getConnection(DATABASE_URL); System.out.println(conn); 2) The same…
Andreas M. Oberheim
  • 873
  • 9
  • 7
-1
votes
1 answer

Select users associated to Approved list/table using Ms Access 2003/2013 or Sql query

[Users] ID | UserID | City | Phone ----+-----------+-----------+---------- 1 | John | Rome | 12345 2 | Tom | Oslo | 12345 3 | Simon | Bogota | 12345 4 | Kurt | Tokyo | …
StickyFingaz
  • 29
  • 2
  • 6
-1
votes
1 answer

ms access 2003 .mdb cannot view the table

I'm using ms access 2007. I save the database contain table in 2003 format. If i open a file, i saw four table. But three table are able to open. one table is unable to open and occur a message unrecognized database format.Please help me. It's…
Shanmugarajan
  • 23
  • 2
  • 5
-1
votes
2 answers

How to write a SQL command to move all old data from access table into another database/table?

I have a table in MS Access 2003 in which I want to archive all old data. The criteria is that the creation data should be less than a specific date. I can write a SQL statement to select them, but I don't know how to move them to another…
mans
  • 17,104
  • 45
  • 172
  • 321
-1
votes
2 answers

Erorr on my Insert statement

I'm having trouble with my code, I am getting a Invalid expression term ')' not sure what I'm doing wrong. Here is my code. protected void btnSubmit_Click(object sender, EventArgs e) { OleDbConnection conn = new…
user2526337
  • 1
  • 1
-1
votes
1 answer

Textbox Field Name in access

Got this error #Name? on my text-box field..my Field Name in my design View a same as the One in my Control Source property text-box but I'm not sure why i still got this error.. Can someone shares some lights here
Tukai Nancy
  • 127
  • 1
  • 4
  • 12
-1
votes
2 answers

Counting distinct records across two tables

Question concerning counting unique combination of fields across two tables in SQL. MSaccess 2003. table1: id, fld1, fld2 table2: id, dateAndTime id is not unique; tables are joined across "id". I need a count, by date (dd/mm/yy - ignoring time) of…
JJJones_3860
  • 1,382
  • 2
  • 15
  • 35
-1
votes
2 answers

Import data from MS Access 2003 db using MS Jet OLEDB 4 drivers into Excel 2003 gives ISAM error

I am trying to run query stored in an MS Access 2003 database through Excel 2003. The connections string is as follows: flLoc=thisworkbook.path stDB= floc & "\list.mdb" stConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & stDB & ";" The db…
joiner
  • 47
  • 1
  • 2
  • 11
-1
votes
1 answer

I haven't found an answer to suit my needs yet. How do I populate multiple tables using a single form?

I have a main table that is populated by a single form. This table has all of my customer info and lists all of the products we sell with the amount sold of each product to each customer. I am creating seperate tables for each individual product. I…
Nate F
  • 1
-2
votes
1 answer

Error when "date" field is blank in Access 2003 through Java form

I'm making a Java program based on an Access 2003 database to keep all the data of clients, contacts, artists, works, exhibitions, etc for an art gallery. I have several fields in the DB where I need to store dates, so I've set the format (in the DB…
user1140461
  • 1
-2
votes
2 answers

there is a type mismatch error in this sub procedure,can anyone help me

Private Sub cmdenter_Click() If Option1.Value = True Then db.Execute "Insert into TM_REGISTRATION values('" + txtregdn.Text + "','" + txtformno.Text + "','" + Combo1.Text + "','" + Format(mskadmdt.Text, "mm-dd-yyyy") + "','" +…
Isaac Renthlei
  • 11
  • 3
1 2 3
…
53
54