Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / General MS Word Questions / September 2007

Tip: Looking for answers? Try searching our database.

2007 access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mmaphq - 26 Sep 2007 19:55 GMT
Converted our database to 2007 file format & tried to run a word vba program
with the new 'db.accdb' reference. Got a 3343 error. So how to you 'set
object=opendatabase("path/db.accdb")'. TIA
Dian D. Chapman, MVP - 27 Sep 2007 04:13 GMT
>Converted our database to 2007 file format & tried to run a word vba program
>with the new 'db.accdb' reference. Got a 3343 error. So how to you 'set
>object=opendatabase("path/db.accdb")'. TIA

You posted this to the WORD group. You need to post this Access Q to
the Access group.

Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified Instructor, Editor/TechTrax Ezine
https://mvp.support.microsoft.com/profile/Dian.Chapman

Free PC Tutorials: http://www.mousetrax.com/techtrax
Free Word Tricks eBook: http://www.mousetrax.com/books.html 
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
ted - 27 Sep 2007 04:59 GMT
Don't think so. Its a vba program in word 2007.

> >Converted our database to 2007 file format & tried to run a word vba
> >program
[quoted text clipped - 13 lines]
> Optimize your business docs: http://www.mousetrax.com/consulting
> Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
Dian D. Chapman, MVP - 27 Sep 2007 21:10 GMT
>Don't think so. Its a vba program in word 2007.

True, the VBA code is running in Word, but the error, 3343 is an
Access (or at least a DB) Runtime error that means: "Unrecognized
database format."

It could mean that the DB is corrupt. In which case he might have to
try to copy to a new, blank DB....or use a backup.

However, assuming he's using ADO to connect to the DB via Word, it may
be that the Provider isn't recognizing the new format. I haven't yet
been brave enough to convert any of my Word <--> DB ADO projects over
to 2007 DBs, so I haven't been hit with this problem YET. But it may
mean that you need to use a new Provider, versus the one for JET.

But as I said, the Access MVPs may have better info about the 2007
format, as I've been chicken to work with it much yet. And since few
Word users take advantage of ADO DB connectivity, even the Word VBA
group would be better than this new users group, where most Qs are
basic and this is an advanced one.

Here's the connection string for Access 2007. So if this is what the
user has already coded...then my guess is a corrupt DB. Try repairing
or copying to a new DB. Although ya might first want to make a mini
bogus one in 2007 to see if the connection works at all!

http://www.connectionstrings.com/?carrier=access2007

Good luck!

Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified Instructor, Editor/TechTrax Ezine
https://mvp.support.microsoft.com/profile/Dian.Chapman

Free PC Tutorials: http://www.mousetrax.com/techtrax
Free Word Tricks eBook: http://www.mousetrax.com/books.html 
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
n6trf - 27 Sep 2007 23:30 GMT
> >Don't think so. Its a vba program in word 2007.
>
> True, the VBA code is running in Word, but the error, 3343 is an
> Access (or at least a DB) Runtime error that means: "Unrecognized
> database format."

Ok thanks. i did find a 3343 error in access 2000 working with word 2000 &
2002. So some of your comments may be apprpiate. Access 2007 seems to be
running ok so doubt if its corrupted. I will try & repair to see if thats
the problem. i really think that ADO DB connectivity has not been checked
fully. Will try the access people. Thanks

> It could mean that the DB is corrupt. In which case he might have to
> try to copy to a new, blank DB....or use a backup.
[quoted text clipped - 15 lines]
> or copying to a new DB. Although ya might first want to make a mini
> bogus one in 2007 to see if the connection works at all!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.