Feb 7 2005, 09:27 AM
I have a database that is used throughout the company. We have all differing versions. I have split be/fe. On the '97 fe version, I have a query that runs every time the database is open. If I have DAO 3.6 the query runs perfectly. But if I run the query using 2.5/3.5 Compatibility it doesn't work. Below is the query:
UPDATE tblGenInfo SET tblGenInfo.UserName = UCase(Left([FName],1) & Left([MI],1) & Left([LName],6))WHERE (((tblGenInfo.UserName) Is Null));
I've tried DoCmd.openQuery and DoCmd.RunSQL they both don't work with 2.5/3.5
Feb 7 2005, 01:41 PM
Check references and be sure that no items are marked "MISSING" on the machines where you get the error. If any are then uncheck them and see if that fixes the problem. I assume that DAO 3.6 does not show as an option on the machines in question and if no items are marked missing then I guess you will have to update the versions of Access on the machines in question...
Feb 7 2005, 02:59 PM
Thanks Jack! I tried MS Article 194374 and it still didn't work for me, so you're right I will have to upgrade the machines that are causing the nuisance.
Feb 7 2005, 03:16 PM
You are welcome and I am glad to hear you know what you need to do to fix the problem...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here