Access 97 Runtime & Database Properties

[Kafrin]

I have a developer version of Access 97 (as well as a normal version and also Access 2003), and I have a database that I need to distribute in the runtime version.

I've had a problem writing to custom database properties in the runtime version. This would all occur in vb code, with input boxes from the user. From either the mdb file or the mde file I can change the properties in the full version of Access, but the mde file in the runtime version just puts up errors. I can read the properties but not write to them.

Does anyone know if I'm doing something wrong or if this is a limitation of the runtime version of Access 97, and if there's a way around it?

(My best suggestion for a way around so far is to store the info in the tag of the form that opens on startup and stick it in a public variable in the OnOpen of that form).

Thank you!

 

[DCrake]

Members like Gemma-the-husky are the best people to answer this type of question as she still uses A97 for development.

BTW won't be long before all your staff are members here, the more the merrier. Tell JD I will PM him about my company changes.

David