Access 2010- VBA code states "Project is not available"

I have recently upgraded from Excel/Access 2003 to 2010. I am working on moving a macro database from a co-workers computer to my computer since her last day is coming up. She is still on Access 2003 and the macro was created on 2003. When I open the macro in 2010 and try to run one of the modules it does not work and gives me this error:

MacroError.png

"The format in which you ar eattempting to output the current pbject is not available"

The function is supposed to export a list to excel. My immediate reaction is to look at the code to see where it is reffering to; however, when I try to access the VBA editor an error pops up that says "Project is not available."

I tried unsharing the database, no progress.
Then I tried adding/removing a digital certificate, both no luck.
I also tried decompiling the database and that didn’t work either.


I know this is an excel forum, but I am at a loss so I figured it was worth a shot.

Thanks for anyone who attempts to help!

Cross posted at: http://www.accessforums.net/programm...ect-38450.html

What steps have you actually taken to transfer the project?

Also you should have posted this in the Access section

I don't work with Macros in Access. I do everything in VBA. Macros in Access unlike Excel are not VBA driven.

I would urge you to convert the Macros to VBA. There is a built in wizard in Access that will allow you to do this.
1. Make a backup copy of your database and store it in a safe location in case you have to restore the existing one.
2. Make sure that you have activated the Developer Tab on the Ribbon in Access.
3. Open the form in which the macro is run from in design view. On the developer tab, there is an icon to convert the macros to VBA. Run it.
4. See if this resolves your issue.
5. If not, then we can analyze your VBA for this particular issue and see what is the cause.

I googled the error message as I had not seen anything like this before and there many possible scenarios that is causing this. Have you check your reference library to see if you are missing any entries?

In post 5, I am referring to the error message "The format in which you are attempting to output the current project is not available." I will research the other error code. I confused both messages. I am clear now.

For the Project Not Available is there an error message number and is that the exact wording of the error message?

First steps to try and resolve this VBE not opening.

Run a compact and repair. Try to open the VBE after this completes.

If the C&R doesn't work, then open a new blank database.

In Access 2010, go to External Data, Access. Import. Select all the tables, queries, forms, reports, etc. Be sure to indicate that you want data as well as the setup.

Save it with a new name and try to open it.

It is possible that your existing database is corrupt. Each of these steps are what I would try initially. Post back with your results.

HTH
Alan

This sounds like it may be protection issue. Was this db built in-house? or by an external developer? Is the person who built it available for consultation?

Also, are you able to provide me with information regarding my post #7. Error message number and exact wording?

Another thought. I have never used it, but can you check to see if there is user level security on the original .mdb file. It would be under the Tools tab in the original file and then Security.

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Cross Posted at: http://www.accessforums.net/programm...ect-38450.html

Look at this link http://support.microsoft.com/kb/823225

This is what MS has to say about the error message.

You are welcome. A good bit of news is that you can salvage the tables and queries. If necessary you can rebuild the forms and reports. That part is not the heavy lifting. Tables and queries tend to be the heart of the database.

Hmmmm. You need to have the original mdb to make the changes. With time, that may have gone away. This may be helpful, but I doubt it.

http://office.microsoft.com/en-us/ac...005239302.aspx

I'm guessing someone saved it as an MDE and then changed the file name to mdb. It is still an MDE. Only guessing at this.