Stack Overflow
Stack Overflow

Questions tagged [ms-access-2000]

Microsoft Access 2000 is an older version of Microsoft's entry-level, SQL, database application platform.

Resources:

88 questions
1
vote
2 answers

Access 2000 Query Execution Time

I have two tables like Parent-Child. In Parent table, there are 7211 records. In Child, there are 169498 records. Between these two tables, there is no relationship (means haven't set Foreign Key, but using parentID). In Child table, there are extra…
soclose
  • 2,773
  • 12
  • 51
  • 60
1
vote
4 answers

SQL Server rows not editable for Access after Insert

I have this problem: I'm using a SQL Server 2008R2 backend and MS Access 2000 frontend where some tables are connected via ODBC. Following Structure (Tables all on SQL-Server): Import (not connected to Access) Products (connected via ODBC to…
Misc
  • 23
  • 5
1
vote
1 answer

Make default value on textbox triggered when other field change

So I have some textbox on my form,and on the last textbox, I turn off the enable so instead of asking the user for the input, I want to make the value on the textbox calculate automatically when the user input on another textbox, so I set the…
Fajry Hamzah
  • 68
  • 9
1
vote
2 answers

How to create an Access 2000 database from a 64 bit .NET assembly?

Our application needs to create an .mdb (MS Access 2000) file from VB.NET. We use ADOX for this using as connection string Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5; This works well. However, now we want to allow 64-bit compilation…
Dabblernl
  • 15,831
  • 18
  • 96
  • 148
1
vote
1 answer

Issue with ms access 2000, repeating display of same field in query

I was having an issue with ms access 2000 in which I try to enter the same field in a query multiple times and it only displays the field once. As in if I entered the field with the number being (for example) 8150 multiple times, it would only…
Ninjatix
  • 75
  • 1
  • 1
  • 7
1
vote
3 answers

"Concurrency violation: the UpdateCommand affected 0 of the expected 1 records" when updating a new added record in MS Access database from C# app

Please help to resolve my problem. I'm getting an error "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records" when trying to update a newly added table record in MS Access (2000 format) database (.mdb) from my application…
kdg82
  • 11
  • 1
  • 4
1
vote
1 answer

ADO To Drop A Query

I know you can use Drop Table to drop a table, but is their a way to delete a query? I'd prefer to use ADO and not DAO to achieve this, if that is possible, as with DAO you have to open the database and ADO you do not.
Big Pimpin
  • 427
  • 9
  • 23
1
vote
2 answers

Updating access 2000 database through code in VB6

I have an application that uses an access 2000 database currently in distribution. I need to update one of the recordsets with additional fields on my customer's computers. My data controls work fine as I have them set to connect in access 2000…
Mark
  • 11
  • 2
1
vote
1 answer

Add Comma If Next Field Is Not Null

I need to display data in a lastname, firstname, salutation format. However there are a few rare instances where salutation is null, so I wouldn't want to display firstname, if salutation is null. Or there (doubtful) could be a possibility that…
MasterOfStupidQuestions
  • 925
  • 1
  • 16
  • 37
1
vote
1 answer

"Invalid use of Null" in Access Query

I have two near-identical databases (the second was a copy of the first, and then modified with different company/product information). There is an aging report that never worked right, that I had to fix. I have it working on one database (A), but…
Justin C
  • 57
  • 9
1
vote
1 answer

How to setup a linked server to Access 2000 database?

I am using SQL 2005 Server Express. How can I setup a linked server to an MS Access 2000 database?
Alex
  • 2,081
  • 14
  • 49
  • 76
1
vote
0 answers

Convert Access 2000 application to access 2013 application

We have an Access 2000 application linked to SQL Server 2008 database. Now we are going to convert it to Access 2013 application (again linked to SQL Server 2008). What issues I'm going to face, and what is the best solution to take? Thanks for your…
Mike Ezzati
  • 2,968
  • 1
  • 23
  • 34
1
vote
1 answer

SQL executes well in MS Access but not in C# when "Validation Rule" is set

I am having a strange problem. I have written a query in MS Access which inserts a value perfectly in database when run from MS Access, but when same query is executed from C# then it shows the "Validation Text" as OleDbException and insert command…
Computer User
  • 2,839
  • 4
  • 47
  • 69
1
vote
0 answers

Query time of ms access on network

A ms access 2000 mdb file is hosted on a network drive. Inside this mdb, tbl_History table has 42,223 records. Every month, new 2,400 records are stored on this table. A customized application developed by VS 2005 is queried on this table. The query…
soclose
  • 2,773
  • 12
  • 51
  • 60
1
vote
1 answer

Converting Access 2000 database to Access 97 using Access 2003

I have an access databse (from an opensource project) that's in Access 2000 format. All text fields, I've looked at, have ALLOWZEROLENGTH set to TRUE and DEFAULT to "" (empty string). On conversion to Access 97 (using Access 2003) the…
kjack
  • 2,004
  • 3
  • 26
  • 41
1
2
3 4 5 6