Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. peterglick

    Excel - ODBC - column names - invalid characters

    I'm using Automate5 to perform a SQL query on an excel file. This works fine except when the header row of the excel file contains characters such as ? . ( ) etc Is there any way to write the SQL SELECT such that it refers just to col1, col2 etc, or to bypass the first row of the file? Peter
  2. peterglick

    Outlook, outlook express: contacts and addresses

    Ok - I'm confused. On my desktop (XP Home and Office 2000), I use Outlook2000 and my wife uses Outlook Express. What I want is for both programs to use (read, update, delete) the same set of names and addresses so that we share a common address book. I know this is possible because it is how...
  3. peterglick

    Version 2, XP and dates

    Access may not be case sensitive but what used to happen with the UK version of Windows 98 is that this came preloaded with the Regional Settings set something like dd MMM yyyy. AccessV2 then had all sorts of 'date syntax' errors until I changed the regional settings to dd mmm yyyy upon which...
  4. peterglick

    Version 2, XP and dates

    I'll see what the client thinks. They have two databases - each with about 50 screens (some very complex), 40 reports, 200+ queries, 400+ macros, history going back about 8 years with 10,000's of customers, 100,000's of order details etc etc. I've tried doing a simple conversion using the...
  5. peterglick

    Version 2, XP and dates

    Ken, You can change the XP settings but not in the way that Access v2 demands, i.e. either all capitals or all lower case (can't remember which). Upgrading to a later version of Access will cost the client £10,000+ (I'm expensive and the application is very, very large), Peter
  6. peterglick

    Version 2, XP and dates

    One of my clients has started to run one of my huge Access V2 applications under Windows XP (previously 95 and 98). We are now getting some date handling issues (e.g. invalid syntax errors) that we used to get in Windows 98, because the Control Panel/Regional Settings did not match what...
  7. peterglick

    Corrupt, exploding database

    It's not that - we compact frequently and the database is never more than 12 Mb or so when working properly. The cause of the corruption is also causing the file size to grow/be corrupted.
  8. peterglick

    Corrupt, exploding database

    I am getting a problem where my networked Access 2.0 databases are becoming corrupt and unrecoverable. The strange thing is that their file size grows from 10 megabytes to 1 gigabyte plus! This occurs with the server database which holds the data. Client side databases with the code are also...

Part and Inventory Search

Back
Top