Solutions to common problems

Below are answers to common Microsoft Access problems. Contact us if you need additional help.

Question: You're using Microsoft Access 2000 and get the message; Error accessing file. Network connection may have been lost -or- This action will reset the current code in break mode.

Answer: This can occur when you install a VBA application (Microsoft Office 2002 or Visio 2002) when you already have Microsoft Access 2000 installed. This is because these new applications install a new library program that writes over the one used by MS Access 2000. The fix for this is to get the latest service pack for Microsoft Access 2000.

Question: You get a question about blocking unsafe expressions. What is this about?

Answer: Microsoft is very concerned about security. This is the latest attempt at making Microsoft products more secure. It is easily fixed but you need to download a driver or use a hack to stop this mesage. The better solution is to download the latest JET drivers. These are used by Access and other applications to get data.

Click here for instructions on how to get the latest JET (Microsoft Access) drivers

The *not* recommended hack is to lower the security settings on you Microsoft Access macros. I do not advise this.

Question: You get an error message; Microsoft JET Database Engine (0x80040e10) No value given for one or more required parameters -or- Microsoft JET Database Engine (0x80040e10) Too few parameters. Expected 1. What is this about?

Answer: There are three reasons for this error.

* You have column names in your query that do not match up to the underlying fields for the data.
* You do not have the correct delimiters for text, numbers, dates.
* You have not supplied enough parameters for your query.