mde database problem

  • Thread starter Thread starter hugh welford
  • Start date Start date
H

hugh welford

Hi - using ACCESS 2000 under XP

I have successfully created an upgrade to my exixting ACCESS.mdb database,
and as usual, want to make it into an mde before release. It will not do
this, although I have been successfully doing it for the past 8 years with
no problem. I get a very helpful alert telling me that ACCESS cannot create
an mde. This alert has on it one button which says OK. Well, it certainly
isnt OK, but no alternative is provided, and no indication is given why
ACCESS cannot do this, or where I can get help.

Can anyone throw any light on this, and point me in the right direction to a
possible solution?

Thanks in advance

Hugh
(Frustrated of London)
 
Hit Ctrl-G and then go to the Debug menu and choose Compile.

That will highlight any errors found. Fix these, Compile, and Save the
project.

Then attempt the mde creation.
 
Thanks Joan

The compilation stopped on set theset = me.recordsetclone

Why should this method not be recognised all of a sudden?

I was actually able to delete the routine as it was redundant, and the mde
worked fine, but it would be good to know about the unrecognised method

Thanks again
Hugh
 
It could be that Access was confused as to the type of recordsetclone - DAO
or ADO

I can't recall details, but I have had problems in 2000 using Recordsetclone
vs. Recordset.clone.
 
Thanks Joan

Hugh


Joan Wild said:
It could be that Access was confused as to the type of recordsetclone -
DAO or ADO

I can't recall details, but I have had problems in 2000 using
Recordsetclone vs. Recordset.clone.
Click to expand...
 
Back
Top