Search results for query: *

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

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...

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...

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...

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

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...

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.

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...