.accdr file issue

[EdCanada]

Hi Guys,



In my company we have a billing system that we use and its build with Access Database. The way we access the file is by clicking on file with .accdr extension.

The file was working fine few days ago until a Microsoft update was installed. I noticed that there is an Access RunTime 2010 was installed.

Now, when we open the file we get the following message:

The expression On Timer you entered as the event property setting produced the following error: The OpenForm action was canceled.
* The expression may not result in the name of a macro, the name of a user-defined fucntion, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.
Details:
This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs.



I don't know how to fix this, I tried to uninstall RunTime 2010 and install RunTime 2007 but that didn't work.
I tried to rename the file from .accdr to accde or accdb and that didn't work either and I get a message saying unrecognized extension.
I tried to run the file from different machines and I get the same error.


I am not an expert in Access that is why I am here

So please guys help me out with any suggestion.

By the way there is Microsoft Access 2007 installed on the same machine that the file is located and its been like this for years now.

Thank you.

Ed

[ItsMe]

If you change the file extension from accdb to accdr, there should not be an issue changing it back to accdb. I am not sure why you get an unrecognized file warning. Maybe the accdr file was not originally accdb.

Where are the data tables, in the same accdr file?

I would try to open the file as an accdb and edit the macros to work on the newer 2010 RT.

[EdCanada]

Hi ItsMe,

Thank you for your reply. I have no idea if the file was originally in accdb, we've been using this file in it current format and nothing has changed. So just to understand, typically when there is an accdr file that means this is acting like a frond end and there is a back end database somewhere?

Also, how can I open the file in access? when I open access 2007 and go to open file, I don't see the accdr within the extensions and when I choose All File Extension I get the same error above.

Is there a way to convert this accdr file into an accdb file so we can use it again?

I googled the issue and I could not find a good solution, I am hoping that I can find a solution here..

Thanks,

Ed

[ItsMe]

So just to understand, typically when there is an accdr file that means this is acting like a frond end and there is a back end database somewhere?

No, I am curious if this is the case. Whether or not there is a backend file and a front end file would leead to additional questions.

Also, how can I open the file in access?

You just double click it. The file opens the same whether your machine is using the full version of Access or the RT version. There may be a way to tell Windows to open the accdr extension with the full version features vs. just the Run Time components. I do not know.

Is there a way to convert this accdr file into an accdb file so we can use it again?

Yes, replace the text in the file name; .accdr with .accdb
I am not aware of another way and this is part of the reason I asked some of the other questions. It may be possible to take an accde file and replace the e with r. I do not see any benefit in doing this but, it may be the reason you are getting the unrecognized file error. If what you have is an accde file you are not in a good situation. At least not to be able to edit said file to be compatible with other versions of access.

In order to edit the macros you need the original accdb file. If someone showed me an accdr file I would think that I was looking at an accdb file. Changing 'b' to 'r' is a technique I use to test apps I create and understand how they will behave in a runtime environment. I do not use any Publishing Wizard or anything. There may be a Wizard that does this but that does not seem likely, at least from my perspective.

[EdCanada]

Thank you for your reply.

Renaming the file is not working because I am getting the unrecognized extension when I try to open it with Access.

Have you or any in the Forums here seen this error before? By reading the error, what do you think its the problem? Is there a problem in one of the forms?

[ItsMe]

In order to open an accdb file you need a full version of Access installed on that machine.

[EdCanada]

I am still trying to troublshoot the issue. I installed Access Runtime 2007 on a new machine and I tried to open the file and this is what I got.

[EdCanada]

I will install uninstall the Access Runtime 2007 from the machine and install the Access Runtime 2010 and see if I get the same message.

[ItsMe]

Don't bother.

In order to open an accdb file you need a full version of Access installed on that machine.

Considering you need a full version of Access to do any edits to an accdb file I overlooked or assumed you were attempting all of this with a Full Version of Access.

[EdCanada]

You are right if the file is accdb but its not. Its accdr and renaming it looks like its not doing the job.

Now, I installed the Access Runtime 2010 and I got this message.

[ItsMe]

I am not going to argue over the internet. You can open accdb files with the Runtime you download from Microsoft. Not all versions, 2010, 2007 are created equal. Depending on what stuff is inside the ACCDB file will determine which versions of Runtime can open the ACCDB file. The only difference between an ACCDB file and an ACCDR file is the last letter (R vs B)

If you want to make your ACCDR file compatible with different versions, someone that knows how to develop apps will need to open it with a Full Version of Access and edit the stuff inside. Before they open it, they need to change the letter R to B.

[EdCanada]

Thank you for your help, I am not trying to argue with you or with anyone, I just want help. Again I tried to rename it and I got this message.

[ItsMe]

Do you have a Full Version of Access on that computer? When you go to Start>Programs; can you find Microsoft Access 2010 or Microsoft Access 2007 and launch Access?

[EdCanada]

Yes, I have full Access 2007 version installed on the computer.

[ItsMe]

Then my original assumptions may have been on the right track. Let me test something here to see if it works first. I am in 2010 but....