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

Copy large amount of data from ms access table (with 2.3 mimion recs) to sql 2000 server using ADO in VB6

i have a ms access (2.3 mimion recs) table and need to copy to sql server 2000 DB, every day i have new 15000 Recs to be imported to sql server 2000 so i need a sql statement NOT a loop to copy data from access to sql. using vb6, ado
Achala Dissanayaka
  • 1
0
votes
1 answer

Selecting Specific Information Using Two Tables

I have two tables: Players Player_id email_address highest_level Login login_id ip_address player_id login_date login_time I'm looking to count the number of distinct logins per player, but only for login date 2014-06-01 and only for player email…
PVic
  • 417
  • 1
  • 4
  • 13
0
votes
1 answer

Run-time error '3073': Operation must use an updateable query

I have some vba code that I am trying to use to export the results of a query,and every time my code tries to export It throws me an error, Run-time error '3073': Operation must use an updateable query, and I'm not sure why. exporting other tables…
PsychoData
  • 1,198
  • 16
  • 32
0
votes
3 answers

Having trouble exporting to text file

I am having some trouble exporting out to a file from VBA. Some things to be aware of are that JobDetail is a valid export SpecName and 2_JobDetail is a query that combines some info with stuff from other fields and tables. When I try to run I get…
PsychoData
  • 1,198
  • 16
  • 32
0
votes
1 answer

Does the data object have a maximum query length?

I have an old vb6 program which queries an access 2000 database. I have a fairly long query which looks something like this: Select * from table where key in ( 0, 1, 2, 3, 4, 5, 6, 7, 11, 12, 13, 14, 15, 19, 20, 21, 24, 27, 29, 30, 35, 38, 39, 40,…
Mansfield
  • 14,445
  • 18
  • 76
  • 112
0
votes
1 answer

Access 2000 - Editor & Line numbers?

Anyway to get Access 2K Module (vba code) editor to show line numbers?
Alex
  • 2,081
  • 14
  • 49
  • 76
0
votes
1 answer

Show records being processed in status bar

I have a query that I process by looping through each record via VBA. It takes a while to run and the users are impatient. To them it appears that the program has locked up. How do I control the status bar to show the user that the query is in…
Ed Felty
  • 91
  • 2
  • 11
0
votes
0 answers

Random, intermittant "unspecified" errors connecting to Access via ODBC in ASP

I have an old classic ASP web app that connects to MS access 2000 using ODBC. I was able to get the site moved to IIS7 on windows 2008 and connected to the database. When the app is launched, it works fine - but every now and then it gives an…
Arcadian
  • 4,312
  • 12
  • 64
  • 107
0
votes
1 answer

ACCESS 2000 REPORT

I have a query which pulls data based on a from and to date. It pulls eight fields which is all fine. The problem i am having is the report that i create from this, i need to group by the site name which is all fine i get the site name and the…
Johnathan McAuliffe
  • 1
  • 3
0
votes
1 answer

Access 2000 reporting functionality substitute

Here in my job, we use Access 2000 as our only report deployment tool, and as many of you know, Access 2000 has some limitations, like not supporting OOP. My question is: What is the better replacement for it, Crystal Reports, Active Reports or SQL…
Diego Garcia Vieira
  • 93
  • 1
  • 2
  • 10
0
votes
2 answers

Using OpenRowSet to connect to an Access 2000 Database from SQL Server Management Studio

I am trying to connect to an Access 2000 database from SQL Server Management Studio. My current query is: sp_configure 'show advanced options', 1; RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries', 1; RECONFIGURE; GO Select FName From…
charles082986
  • 141
  • 1
  • 3
  • 12
0
votes
1 answer

MS Access/JET "Join Expression Not Supported" Any Way to Fix This Query?

MY CODE (Im using MS Access 2000 with JET Database engine) SELECT Members.First_Name + ' ' + Members.Last_Name AS Member, iif(NULL,Friends.My_E_Mail, Friends.Friend_E_Mail) AS E_Mail, Members.First_Name AS Name FROM ((Members …
James Putin
  • 13
  • 5
0
votes
1 answer

"Union Operation not allowed in sub query" is there a way to fix this in one single query?

This Query Dose NOT work in Access 2000 SELECT (Members.First_Name + " " + Members.Last_Name)AS Member, (SELECT Friend_E_Mail, FROM Friends,Members WHERE My_E_Mail = ? and Friend_E_Mail <> ? UNION ALL SELECT My_E_Mail,FROM Friends,Members WHERE…
James Putin
  • 13
  • 5
0
votes
2 answers

How to store a String (length > 255) from a query?

I'm using Access 2000 and I have a query like this: SELECT function(field1) AS Results FROM mytable; I need to export the results as a text file. The problem is: function(field1) returns a fairly long string (more than 255 char) that cannot be…
ponponke
  • 113
  • 2
  • 3
  • 11
0
votes
1 answer

Unable to get a textbox' default value to populate from a query

I have a form field that I'm trying to populate from a query named qryCreditsUsed. The query is listed below and works as expected. The result should the number of billing records associated with a given authorization number. The result can, but…
Joseph McLaughlin
  • 1
1 2 3 4
5
6