Run-time error based on file extension

Novice1

Registered User.
Local time
Today, 14:41
Joined
Mar 9, 2004
Messages
385
I have a database saved in Access 2007 (sample.accdb), which runs fine as is. In order to bypass a security screen every time the database loads, I change the file extension (sample.accdr).

If I run a report, without data, I get the following error, "Execution of this applicaton has stopped due to a run-time error." If I change the database file extension back (sample.accdb) I don't get the error.

Why? What can I do to fix this error?
 
Here is a link to a page from Microsoft the should shed some light on the subject for you:
http://office.microsoft.com/en-us/access/HA100678311033.aspx?pid=CH100645711033

To quote from the link above:
The .accdr file is a new file name extension that enables you to open a database in run-time mode. By changing a database's file name extension from .accdb to .accdr, you can create a "locked-down" version of your Office Access 2007 database. You can change the file name extension back to .accdb to restore full functionality to your database.

From your very brief description, which included the reference to "bypass a security screen every time the database loads", I would suggest taht you may not have defined "Trusted Locations" for you databases. Access 2007 expects you to define these trusted locations and open your database applications from these locations.

If this is not the security you are trying to avoid, then if you can provide a little more detail, perhaps someone will be able to provide more assistance
 

Users who are viewing this thread

Back
Top Bottom