I have Microsoft Office XP SP3 installed on an Windows 2000 Pro PC. It works great except for when I'm attempting to run one query in Access XP. This is a query that is based on imported data from Excel 2000. The query was also built from Access 2000 (Office XP is a new upgrade for this PC). The query works fine from PCs running Access 2000, but causes Access XP to crash with no warning. (the application just closes completely and gives no error message) Can anyone provide information on this problem? Is there an application log I can …

Member Avatar
Member Avatar
+0 forum 1

Hello all~ Currently I am writing an ESL book that is a compilation of modern day terms/phrases in American English. I have put all of the information that I have gathered into an excel file and would like to search the internet for examples of the terms/phrases used to include in the book. My problem is that I do not want to have to manually type in each term/phrase. I am wondering if there is anyway that I can use a prog./application that will automatically take the information from my excel file and plug it into a search engine that …

Member Avatar
Member Avatar
+0 forum 1

I am having problems making my code access the primary key, and to print information out to screen in a C++ program that I Am writing. Need some help PLEASE ! The Primary Key Name is ID1. HERE IS THE CODE #include <windows.h> #include <stdio.h> #include <conio.h> #include <iostream.h> #include <tchar.h> #include "ODBCWrapper.cpp" //make sure you include the namespace using namespace std; using namespace ODBC; int main(void) { MDBConnection link; if(link.Connect("C:\\Documents and Settings\\Chester Mayle\\My Documents\\My Data Sources\\db1.mdb")) { ODBCStmt Stmt(link); SQLExecDirect(Stmt, (SQLTCHAR *) _T("USE Foo"), SQL_NTS); int pos = 1; TCHAR strQuery[256] = _T("SELECT car1 FROM \ID Data Base\where ID1='2%'"); …

Member Avatar
Member Avatar
+0 forum 2

Hello, I'm new here, and new at using Access... grrrrrr... To start off, I want to create a database for all correspondence, i.e. invoices, quotations, etc. etc. 1. Is it a good idea to use Access for this? 2. Any tips pleaseeee? Best wishes!!!! :p

Member Avatar
+0 forum 0

I have Windows 2000, Service Pack 4 currently and I need to update my Microsoft Access 2000 to 2002 for a class that I'm taking. I'll try to ask this in the best way that I can. If I get the 2002 Office upgrade, do I also need to upgrade my Windows to XP as well in order to get it to work? In other words, I like Wuidows 2000 and all I really want from the Office XP is the Access upgrade. I'm not too familiar with installing upgrades, so my main question is can I get away with …

Member Avatar
Member Avatar
+0 forum 3

I have a table. I will add thousands of records to this database each year. It’s essentially needed to maintain inspection records. Each problem found get it’s own record. Its possible to go into a building and come out with 20 or more problems (20 new records). Records older than 3 years I could legally delete, so unless access has a limit on number of records I could use one database. Ok the real problem is this. When we find a problem it goes into the database. I need a means to identify any single record and the best way …

Member Avatar
Member Avatar
+0 forum 1

First of all it's free... [url="http://www.edmunds-enterprises.com/linux/cart.php/ba/pdtl/product/123"]http://www.edmunds-enterprises.com/linux/cart.php/ba/pdtl/product/123[/url] So far I've found it to be a better program than MS Office 2000, are there any pros and cons I should know of as far was word processing, spreadsheets, or presentations go? Edit: I don't know much about MS Access since it's been a while since I took a class and haven't used it since, but does SOT Office have a program similar to Access?

Member Avatar
Member Avatar
+0 forum 2

hello, I am trying to help Jennifer who uses Access. The MS office is XP/2002. When she keys in the information she needs it bring up all the data and not just the data she is asking for, so it's not filtering. When she views SQL an astericks * shows up on one of the lines and it shouldn't. I tried uninstalling and re-installing. Does anyone have any suggestions? Also I asked when she used to have this problem. She statest she got the laptop in May and all worked well it had 2003 office then. But our company rolled …

Member Avatar
Member Avatar
+0 forum 5

The End.