Solved: Error in conversion from Access 2003 to 2007

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

JTaylor820

Thread Starter
Joined
Jan 8, 2013
Messages
2
Hello,

Several years ago I created a database in Access 2003. I recently converted it to 2007. However, since then it seems I no longer have access to design view, so I can't make any changes. Any suggestions? Thanks.
 
Joined
Jun 8, 2001
Messages
2,583
Welcome to TSG JTaylor. Lots of Access help around here.

First try Going to the File tab, Save and Publish and try to save it as a .accdb. If that doesn't work open an empty accdb and import every thing in. If there is security, custom tool bars or other elaboration you may have to rebuild some of that.

I had 2007 for a while but quickly changed to 2010. The big difference (to me) was the way 2010 handled macros. Also 2010 seems to open and work on most mdbs.
 
Joined
Jun 8, 2001
Messages
2,583
I see I mis-read your post.
Have you done this:
Open Access 2010 without opening a specific database. Just open it from the Start menu.
Once Access is open go to the File Tab and Select Options from the menu on the left:
Select the 'Trust Center'
At trust Center Locations check allow trusted location on my network
A window will pop up and put the db path in there
Next go to Macro settings and 'Enable all macros'

There may be other 'Options' to mess with depending on the install/environment
 

OBP

Joined
Mar 8, 2005
Messages
19,895
How are you trying to get to design View?
Have you tried right clicking the object and selecting design view?
 

JTaylor820

Thread Starter
Joined
Jan 8, 2013
Messages
2
Thanks to you both for your help. I was able to right click and choose 'Design View'. Not sure why the Design View icon is grayed out, but as long as it works, oh well. Thanks, again! I will mark solved.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top