Access error

[Kala Brewster]

Microsoft Access: Error message

Unrecognized database format ‘C:\ProgramData ChurchTrac\ctap p8.accdr’

Information: Can’t find the database you specified, or you didn’t specify a database at all.
Specify a valid database name in the command line, and include a path if necessary.

[NeoPa]

The file specified isn't a valid Access database. What more can anyone say?

[BikeToWork]

Try changing the last letter in your file extension from an r to a b. "Accdb" is the default file extension for Access 2007/2010 databases. See if "C:\ProgramData ChurchTrac\ctap p8.accdb" works.

[tuxalot]

Hi Kala,

This may be a shot in the dark, but you could try decompiling your project to see if an error has crept in somewhere. Create a shortcut on your desktop with this as the target (assuming your Access program has been installed in the default directory):

"C:\Program Files\Microsoft Office\Office14 \MSACCESS.EXE" /decompile

Double click this shortcut to open Access in "decompile" mode. Once Access opens, navigate to and open your database. If it opens, type ALT+F11 to open the Visual Basic Editor. Open a module and compile by clicking the Debug menu > compile (your DB name). Save and exit out.

Hope it works for you!

[Mihail]

Hi all !

Hi NeoPa !
It is not a really database but it is an Access file.
Here is a link to some explanations.
I know your skills in Access and I think that your English is better than my :) so you'll understand better.
If you wish you can "translate" for others like me after you read.

http://www.file-extensions.org/accdr-file-extension

[NeoPa]

My statement in post #2 was not based (solely) on the file extension shown, but on the error message. One way or another, the file specified was invalid. If the file had been referenced correctly in the code and it had been a valid Access database file, then this error message would not have shown up as it did.

I don't know whether the file itself is bad, or whether the reference to it was flawed, but I'm confident that the statement in post #2 is reliable and accurate.

[C CSR]

The ACCDR is created by the Developers Packaging feature. Where are you trying to open it from (my file opens fine by itself). It may have been corrupted or you don't have Access Runtime installed. The installation package even put an Icon on my desktop; is that where you're opening it from?