Database Import Issues-Lose DATABASE Type

R

RobertoM

MS Access 2002 (10.6501.6714) SP3
When I try importing ALL my objects into a new database, even if I choose
detailed OPTIONS (Menubar etc) one of my main declarations (Dim MyDB as
Database) gets corrupted and I get an error "User Defined Type not Enabled".
In the source .MDB this works fine, but I cannot find where this is being
declared or why ACCESS should corrupt this on IMPORT. The main reason for
impoting my Objects is because when I try copying the souxce .MDB to one of
my 8 PC's on the network running XP-PRO the DATE() function dissapears ? on
ALL other pc's the .MDB works fine.

I have tried importing on several PC's, the result is the same.

Any Ideas ?

Roberto
 
B

Brendan Reynolds

You need to add a reference (Tools, References in the VBA editor) to the
Microsoft DAO 3.6 Object Library. Unlike earlier versions, Access 2000 and
Access 2002 do not include that reference by default in new MDBs. (In Access
2003, Microsoft saw the light, and put the default reference back again).
 
R

RobertoM

Hi Brendan,
Thanks that did the tric.

For the record, I also had had to add the UTILITY.MDA plug in because some
of the other functions such as Find.First etc. was crashing as well.

ALL OK now.Thanx

Roberto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top