1

I'm very new to Access and I don't have any experience. At work, I was ask to research about migration of MS Access 2003 databases to 2007.

I have read on the Internet that usually if you open .mdb files in Access 2007 it will normally work. But in my case I'm getting an error:

Action Failed

Now I'm not sure if I'm getting the correct file here.

Here is the structure of the file of the database. The database name is: Energy.

Folder Energy:
Access2003
Energy.app
System.MDW
Energy (it's a link)
Energy.ini

I made a copy of my Energy.app and then renamed it to Energy.mdb. And this file Energy.mdb I opened in Access 2007. Then I got the error. How can I find the .mdb file? Did I do the right thing?

I also read that I have to make a copy of the front-end or back end of my database. I'm not sure where is the front end and back end now.

Is it in the SQL Server? Thanks for your help in advance.

Additional Question

I tried to follow this one from the website:

Method 2: Move the database to a trusted location

To do this, follow these steps:

  1. Determine trusted locations to which you can move the database. To do this, follow these steps:

  2. Click the Microsoft Office Button, and then click Access Options. Click Trust Center, and then click Trust Center Settings under Microsoft Office Access Trust Center.

  3. Click Trusted Locations, and then use one of the following procedures: Note the paths of the trusted locations that are listed. Add a new trusted location. To do this, click Add new location, and then specify the path of the location that you want to add.

  4. Move the Access 2007 database to the trusted location that you want.

But it seems it didn't work. The error I'm getting is after I deactivate the macro under option is this:

Error in Connection
SQLState '28000'
SQLServer Error 18452
[Microsoft][ODBC SQL Server Driver][SQl Server] Login Failed for user '(null)' Reason: not associated with a trusted SQL server connection

But I already added a new folder to the trusted location, as mentioned on the KB

Improve this question
3
  • Are you certain the original file, "Access2003 Energy.app" is not named "Access2003 Energy.adp"? If so, don't rename it to MDB, just open it directly -- ADP is the alternate front end format for connecting to SQL Server databases. It's no longer actively promoted by the Access team, though, so you don't want to invest too much energy in it -- it's a dead-end technology. Commented Sep 23, 2009 at 1:40
  • hi David,that's the one I can see in the folder of this database. The folder name is Energy and in it are these: 1) Access2003(this is another folder) and in it are Energy.app and System.MDW. 2) Energy (a link) and 3) Energy.ini Commented Sep 23, 2009 at 6:34
  • i'm not sure how to identify the front-end format and back-end. Could you please show me how to differentiate it? Do you mean I'll just open the Energy.app directly in ms access 2007? Thanks Commented Sep 23, 2009 at 6:37

1 Answer 1

Reset to default
2

Have a look at this

Are you allowingtrusted mode?

Improve this answer
Sign up to request clarification or add additional context in comments.

33 Comments

hi astander, thanks for the link. Do I have to do this in ms access 2007? Or in SQL Server?
the link says that you need to do this in ms access 2007. Are you moving from access to sql server?
First I would like to open the .mdb files to access 2007 see if it works. If it works then we have to migrate from 2003 to 2007.
At the top, below the ribbon, it give you a warning "Security Worning - Certain content in the database has been disabled - Options..." do you see this?
yes I see this. Actually I tried to open this several times and also activate but still I'm getting an error message.
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.