Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Office

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-15-2012, 09:08 AM
REDSHIFT1 REDSHIFT1 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 5
REDSHIFT1 is on a distinguished road
Default Access 2003 I know This Is the Wrong Place But...

...I can't seem to sign in on Access.net. Anyway, a few years ago I used Access 2003 to create a database for addresses to print labels from. I just bought a Dell 8300 and reinstalled MS Office 2007 (eventually I will get around to upgrading). I tried to view the database with MS 2007 Access and I can't...I get a message "incorrect file type" or something. And now for some reason, the file is connect to Adobe Reader. The extension of the file in question is access (.wbd). How do I get this file to open in MS 2007 so I can use it?
Reply With Quote
  #2  
Old 02-15-2012, 06:17 PM
Nick.Ryan Nick.Ryan is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Feb 2012
Location: Wellington, New Zealand
Posts: 3
Nick.Ryan is on a distinguished road
Default

Dumb question maybe but have you tried renaming the extension to mdb?
Reply With Quote
  #3  
Old 02-16-2012, 04:57 AM
REDSHIFT1 REDSHIFT1 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 5
REDSHIFT1 is on a distinguished road
Default

Well, I am not techo-savy, so I looked up how to do that. And it works...halfway: Access 2007 does now see the file, but when I try to open it, I get a message:

"unrecognized database format"

Any more ideas? I have the original MS Works that came with the original PC (Dell 4600). Is it possible to reinstall the Access 2003?
Reply With Quote
  #4  
Old 02-16-2012, 12:38 PM
Nick.Ryan Nick.Ryan is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Feb 2012
Location: Wellington, New Zealand
Posts: 3
Nick.Ryan is on a distinguished road
Default

Ah, OK, then it's not an Access 2003 database, it's a Works database. You will need to change the extension back and then you should be able to load it using Works.

A quick search on Google reveals various methods of converting an mdb to a format like Excel are available. Perhaps rather than reloading Works on your new machine, you could try one of those methods?
Reply With Quote
  #5  
Old 02-16-2012, 03:38 PM
zyzzyva57 zyzzyva57 is offline Windows 7 32bit Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 413
zyzzyva57 is on a distinguished road
Default

You cannot simply change a file extension, because there is a world of difference between Access 2007 or 2010 and Access 2003

If you can open the db enough to SaveAs this should allow an easy update the db




Reply With Quote
  #6  
Old 02-17-2012, 07:36 PM
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 9,882
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
Default

Quote:
Originally Posted by zyzzyva57 View Post
You cannot simply change a file extension, because there is a world of difference between Access 2007 or 2010 and Access 2003

If you can open the db enough to SaveAs this should allow an easy update the db
If you paid attention to the original post, Redshift said:
Quote:
I used Access 2003 to create a database for addresses to print labels from
Access files are stored in the mdb format. Given that the file extension referred to in the post (wbd) was incorrect, it would not be unreasonably to suspect that the extension's been changed in error. Hence renaming the extension was valid advice. If, in fact, it's a Works databse, the extension would be wdb - not wbd.

Redshift: To use the Works database data in Access, see: http://office.microsoft.com/en-us/ac...001054737.aspx
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 02-23-2012, 09:19 AM
REDSHIFT1 REDSHIFT1 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 5
REDSHIFT1 is on a distinguished road
Default

Ok macropod, I looked at your suggestion. So which one of those on the link should I use? I made this database with just names and addresses just to print mailing labels from.
Reply With Quote
  #8  
Old 02-23-2012, 01:11 PM
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 9,882
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
Default

I'd probably go with the first one, though any of them should do.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
access 2003 on office 2010 franor Office 1 11-23-2011 06:52 AM
Access 2007 Upgrade After Initial Install - Access 2003 Won't Remove wcb Office 1 01-25-2010 03:08 AM
How do I call/execute an Excel macro from Access 2003 KramerJ Excel 2 05-11-2009 11:33 AM
can't read mail in outlook 2003 web access faithgirl Outlook 1 10-19-2006 11:42 PM
Access 2003 query with wildcards into Word 2003 mail merge Poingdexter Office 1 10-30-2005 05:17 PM


All times are GMT -7. The time now is 11:23 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft