Is there any code solution to force a database to use the Jet engine for Access97, but to gracefully close down if a later version of Access attempts to open the MDB?
Management tasks take longer as disks get bigger - tasks like virus scans, backup and defragmentation are now getting to crisis point for some of us. There will not be enough hours in the day. I am defragmenting a 20 gig partition which I have just deleted a load of garbage from. Even though it...
Is there any way to get the initial letter of a string value in a field using SQL?
For instance, I can say:
SELECT Master.Name, Asc([Master].[Name]) AS AscCode
FROM Master;
- which returns the Ascii code of the first letter of Name
Now all I need to do is return the Character corresponding...
I use WindowsXP Professional with several versions of Access and need to use a specific version to open a database over our network. Both the path to the version of Access I want to use (97, not the default Access2002) and the path to the database file I need to open contain spaces in the folder...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.