CODEWITHSUNDEEP
ms-access
Standage
Standage

Reputation: 1517

Opening an Access database on Windows 7

I'm getting the following error message on some users machines:

The expression On Open you entered as the event property setting produced the following error: There is an invalid use of the . (dot) or ! operator or invalid parentheses.

This error message appears when trying to open the Access database on some peoples' machines using Access 2010 on Windows 7 from a shared location.

Using the same shared network location the database opens fine on Windows XP with Access 2003.

I've checked the registry for the Sandboxmode (2).

The folder location is shared and open for all users.

Looks from the code its not liking the main menu, its complaining about the ! in this form:

strCriteria = [Forms]![MainMenu]![Text22]

Upvotes: 0

Views: 2193

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123409

I see two issues here:

  1. Compiled .mde (and .accde) files are a lot more "fussy" about different versions of Access than .mdb (and .accdb) files are. This is presumably because .mde files have the source code stripped out of them so Access cannot re-compile things "on the fly" like it can with an .mdb file. Years ago I began stipulating that if the Access application is using an .mde front-end then all users must be running the same version of Access and the .mde must be compiled for that version. Even so, an .mde file will occasionally "act up" but re-building the .mde from the source .mdb will usually fix it. (Subtle changes introduced by Office patches and Service Packs may account for at least some of that.)

  2. If multiple concurrent users are opening the same .mde file from a network folder then you will almost certainly encounter problems. For many years it has been well-known among Access developers that a multi-user Access application must be split into a front-end and a back-end (which you have apparently done), and each user must have their own local copy of the front-end file. Even Microsoft is recommending the practice now (after many years of their being conspicuously silent about the matter).

Upvotes: 1

Related Questions