StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMigrating database ms access 2003 to 2007
text
Body
copied!<p>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. </p> <p>I have read on the Internet that usually if you open <code>.mdb</code> files in Access 2007 it will normally work. But in my case I'm getting an error:</p> <blockquote> <p>Action Failed</p> </blockquote> <p>Now I'm not sure if I'm getting the correct file here. </p> <p>Here is the structure of the file of the database. The database name is: Energy.</p> <pre><code>Folder Energy: Access2003 Energy.app System.MDW Energy (it's a link) Energy.ini </code></pre> <p>I made a copy of my <code>Energy.app</code> and then renamed it to <code>Energy.mdb</code>. And this file <code>Energy.mdb</code> I opened in Access 2007. Then I got the error. How can I find the <code>.mdb</code> file? Did I do the right thing?</p> <p>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.</p> <p>Is it in the SQL Server? Thanks for your help in advance. </p> <hr> <h2>Additional Question</h2> <p>I tried to follow this one from the website: </p> <h3>Method 2: Move the database to a trusted location</h3> <p>To do this, follow these steps:</p> <ol> <li><p>Determine trusted locations to which you can move the database. To do this, follow these steps: </p></li> <li><p>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.</p></li> <li><p>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.</p></li> <li><p>Move the Access 2007 database to the trusted location that you want.</p></li> </ol> <p>But it seems it didn't work. The error I'm getting is after I deactivate the macro under option is this: </p> <blockquote> <p>Error in Connection<br> SQLState '28000'<br> SQLServer Error 18452<br> [Microsoft][ODBC SQL Server Driver][SQl Server] Login Failed for user '(null)' Reason: not associated with a trusted SQL server connection</p> </blockquote> <p>But I already added a new folder to the trusted location, as mentioned on the KB</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload