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

How to do a OUTER JOIN on a query

I'm not sure if I was precise enought in my question so I'll explain the situation. I got 2 tables in which I need to do an left outer join to get the data even where there's no match. I did a query which is working fine except for one…
Simon
  • 75
  • 1
  • 1
  • 7
1
vote
0 answers

Adapt Access 2000 Split Database to SQL Backend

I have an Access 2000 Database created over a decade ago. The original creators are long gone. It's stored in a shared folder on a file server on the local network. The file was over 250MB in size, and is accessed by anywhere from a dozen to two…
Justin C
  • 57
  • 9
1
vote
1 answer

Use the data in a list box in an SQL query

I have a form with a list box in it. The list box displays the results of a SELECT query and I want the user to be able to push a button to delete the item that is selected in the list box. Here is the query I want to run when the user clicks the…
Cromulent
  • 3,788
  • 4
  • 31
  • 41
1
vote
1 answer

insert to sql server

I have to insert data from ms access to sql server. My logic is: Get list of names in ms access. Disable foreign key and triggers before insertion. Read each table. Change RowState of each row by SetAdded() method. Finally insert it using command…
faheem khan
  • 471
  • 1
  • 7
  • 33
1
vote
1 answer

Why does MS Access subdatasheet sometimes require additional clicks to render?

I'm using MS Access 2003 to open a MS Access 2000 .mdb that links to a SQL Server 2005 Standard back-end (I've tested and replicated my issue using both MSSQL and local Jet tables so it would be counter-productive to tag this question with SQL…
coge.soft
  • 1,664
  • 17
  • 24
1
vote
1 answer

Missing Operator Error in Access 2000?

I am using vba code in onchange event of a combo field. the code is as below Dim db As Database Dim rs As DAO.Recordset Dim qrystr As String Dim cond As String Dim qrystr_CID As String 'cond = [Forms]![PharmDrug].[Commercial drugs…
Gopipuli
  • 393
  • 1
  • 12
  • 37
1
vote
1 answer

Access Hangs on Subform recordsource set to SQL from VBA

I have a "Search" form in my database that takes in a string, explodes it into an array and builds an SQL string based on a selected join type ("Or", "And", or "Exact Phrase" radio buttons). My code works perfectly 95% of the time, but every once…
coffejor
  • 11
  • 3
1
vote
8 answers

C# and Access 2000

I have developed an network application that is in use in my company for last few years. At start it was managing information about users, rights etc. Over the time it grew with other functionality. It grew to the point that I have tables with,…
Mariusz
  • 908
  • 1
  • 13
  • 28
1
vote
1 answer

Checkboxes in a sub-form datasheet view in MS Access

I am new to MS Access. I have a subform on which I need a checkbox on each row displayed in the subform. My subform is in a datasheet view. There are a number of posts on the web that talk about this but none provide a clear answer. Can anyone help…
Nomad
  • 771
  • 4
  • 9
  • 19
1
vote
2 answers

Can you upgrade Access 2.0 to Access 2000 or later Access project?

Due to a merger, we have inherited a couple of legacy apps which run on Access 2.0. Ideally we would like to re-write them as intranet web apps but due to other priorities this is not going to happen anytime soon. Our main concern is to get the…
Gibbons
  • 355
  • 1
  • 3
  • 7
0
votes
1 answer

How to retrieve data from xml node in MS Access?

I am developing a database application by using MS Access 2000, and it will be access some web services. However, the data is returned in xml format. is there any way that I can import the xml data into a table in MS Access 2000?
Johnny Circle
  • 41
  • 1
  • 1
  • 4
0
votes
1 answer

Access 2000 Timeouts on bound recordset

Blast from the past... Got tasked to mange an aging Access 2000 adp used to manage data residing on SQL 2005 server. On one of the dataforms, whenever I try to make a change to a field and save the change back to the database, it times out after…
Ryan
  • 26,884
  • 9
  • 56
  • 83
0
votes
1 answer

Encrypt PDFs In Access 2000

My Access 2000 application is generating a PDF from a snapshot of a report using ReportToPDF. After I have the PDF file generated, I am converting it to binary and saving to MS SQL Server. I'm looking for a way to encrypt it before I save it to the…
Spidermain50
  • 689
  • 1
  • 12
  • 23
0
votes
0 answers

Making Access database field structure changes propagate through to a Delphi app

I have a Delphi 2007 app that interacts with an Access 2000 database. I have made changes to the database structure (addition of fields) and need to make them visible in the Delphi application but that is proving difficult. I made a minimal Delphi…
rossmcm
  • 5,493
  • 10
  • 55
  • 118
0
votes
0 answers

Access database acting randomly and inconsistently after being updated with OLEDB c#

So I am having a very weird issue, At first my code to insert items into my access database stopped working, it is a simple code like this: using (OleDbConnection myCon = new OleDbConnection()) { OleDbCommand cmd = new…
Zaid Al Shattle
  • 1,454
  • 1
  • 12
  • 21
1 2
3
4 5 6