Re: Office 12 Access Database Engine conflicts with DAO 3.6 librar

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi thanks for the replies, I now know at least I have to get it compiled with
the latest library if I intend to use accb.
1. The problem does not relate to a defective install of 2007. I have tested
that on my own systems.
2. I have a good reason for not wanting to go straight into a full
conversion to SQL - one of the reasons Access has worked for us for ten years
is being able to make fast changes as our systems develop with no reference
to outside agencies. Its part used as a security tool that checks other
departments full size server databases for data errors and part used to
retain our own in house data. Hoping to use SQL server in future to secure
small video files we now open in Access from the file system and securing a
few but not all Access tables but still retain Access as a fully functional
front end.
3. From the replies it points me at the fact that the database may not have
converted correctly from 2003 to 2007 using the convert option, possibly due
to the fact it was a secured database with a lot of customization. I did
wonder because I expected to lose the Add In ribbon with my old menus when I
converted and I can still open them in the accb. I will try opening a new
blank accb database and import the converted objects to see what happens next.
It is maybe overkill because the original mdb after a bit of work on filters
operates OK in 2007. I am just trying to think ahead so they dont get caught
out with an obscelescent file system they cannnot upgrade if I ever retire.
Again thanks for the replies and has anybody else come accross this problem.

"David W. Fenton" wrote:

=?Utf-8?B?bWVyd2NhdA==?= <merwcat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in news:1FCDEC7B-365B-4946-9DD7-48532C664233@xxxxxxxxxxxxx:

By default the MS DAO 3.6 library did not install and when I try
to install it it refuses to install because it conflicts with the
MS Office 12 Access Database Engine Library. Without DAO 3.6
large parts of my code fail to compile as I have always used DAO
in preference to ADO.

The MS Office 12 ADE library is really DAO [next version], and it is
fully backwardly compatible with DAO 3.6. You can't have both, and
you can't use 3.6. You should use only the ADE reference. If it
doesn't compile, then perhaps you have a problematic installation of
A2K7, where the ADO library is not properly registered.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

.

Relevant Pages

  • Re: Me.ControlName = Something
    ... Steve, I think you will discover that my original diagnosis was probably correct, and that whatever is actually triggering the Form_BeforeUpdate event's firing is actually where the problem lies, not the Form_BeforeUpdate even itself. ... Compact the database to get rid of this junk: ... Still in the code window, choose Compile from the Debug menu. ... > Private Sub Form_BeforeUpdate ...
    (microsoft.public.access.formscoding)
  • Re: Error on any code in Subform
    ... Could be any of several things that has gone wrong, so here's a sequence that will address many possible problems and should get you going again. ... Compact the database: ... Open Access, and compact again. ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.formscoding)
  • Re: Forms not saving
    ... I must have had some VBA code attached to these forms somewhere along the way ... Make sure the folder where your database reside is added to the trusted ... Office Button | Access Options | Trust Center | Trust Center Settings ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • Re: Forms not saving
    ... I must have had some VBA code attached to these forms somewhere along the way ... Make sure the folder where your database reside is added to the trusted ... Office Button | Access Options | Trust Center | Trust Center Settings ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • RE: Erratic results from query criteria
    ... I don't know whether you click Notify Me Of Replies in all your ... posts or not so you may not have seen my very belated reply to a November ... and the amalgamation was messy and time-consuming. ... Once I have the database skeleton complete and I am sure that it is working ...
    (microsoft.public.access.queries)