Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Error when running MDE file in Access Runtime 2007

Posted on 2012-08-21
Medium Priority
Last Modified: 2012-11-03
I have created an MDE from and MDB so that users who only have access runtime can use the application.

All features wouk except 1 (see attached screenshot).

On closing a form i delete some table records and run a few queries in VBA.

Works fine in access vbut not in runtime.

Any ideas why?
Question by:SweetingA
1 Comment
LVL 61

Accepted Solution

mbizup earned 2000 total points
ID: 38315711
The instr function is built into Access VBA, and should be usable from queries, etc.

Double-check that your database is in a 'trusted location' on your Runtime machines.

Also, if this database was developed in a different version of Access, make sure that your references are set properly for Access 2007 (tools --> references from the toolbar in the VBA Editor).

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question