A03: Unable to create ADE-File

[Bodo v. Ulmenstein]

Hi,

I've updated my Office2000 to Office2003.

When I attempt to create an ade-Datebase from an Access 2002-2003 format
database
I get this error:

Microsoft Office Access was unable to create a ADE-Database

Compress/Repair doesnot help

With Access2000 I was able to create an ade-Database from the same
adp-Database.

Any ideas how to troubleshoot?

Thanks
Bodo

 

[M.L. Sco Scofield]

The most common problem is having some code that won't compile or a missing reference.

Take a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;283788.

A less common problem is described in http://support.microsoft.com/default.aspx?scid=kb;en-us;202304.

Although these articles were written for Access 2000, the information will apply to Access 2003.

Please let us know if this helps.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Bodo v. Ulmenstein]

The most common problem is having some code that won't compile or a

missing reference.


Hi,
thanks for your reply.

I found that the reference "Microsoft ActiveX Data Object 2.1 Library"
seems to prevent Access from creating an ADE Database.
When I uncheck the reference above and check "Microsoft ActiveX Data Object
2.7 Library" instead
Access will create an ADE Database without any errors.

Thanks
Bodo

 

[M.L. Sco Scofield]

Sure. Makes as much sense as some of the other things that happen.

Glad you got it working.

And thanks for posting back so we know what happened.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com