mde file in Access 2007

[Bob H]

I have just converted a mdb database in Access 2007 to a mde file, but
now the said database does not work correctly. When I opened up the mde
database, I got a message from Access 2007 saying there was a potential
security concern, and I clicked the ok button to open up the database.
Now the combo box to find records does not function, as when I select a
record from the list, it is not shown on the form.

Thanks

 

[Tom van Stiphout]

Did you put the database in a Trusted Location (see help file)?

-Tom.
Microsoft Access MVP

 

[Bob H]

I added a Trusted Location, then re did? the mde conversion. I don't get
the error message now, but neither does the combo box work as it should
either.

Thanks anyway

 

[Bob H]

I have also just converted the mdb database back to an accdb database,
then converted to an accde database. The combo box still does not work
as it should.

Why is this.

Thanks

 

[Tom van Stiphout]

OK, back to the original problem. You wrote: "when I select a record
from the list, it is not shown on the form".
What do you mean by that? I'm thinking you have a combobox, you drop
down the list, select an item, and the dropdown closes and the item is
shown in the combobox. Correct so far? If not, tell us the rowsource,
columncount, columnwidths, and boundcolumn properties.

Do you have the same problem with a sample database downloaded from
Microsoft?

-Tom.
Microsoft Access MVP

 

[Bob H]

I created/inserted a combo box on my form to select records from the
form. So the combo box has a list of records from the querry, and when I
select a record from the combo box, all the rest of the data/information
about that said record is then shown on the form.

Which sample Microsoft database are you referring to, because I have
looked at the Northwind database and it looks like it is an mdb file.

Thanks

 

[Tom van Stiphout]

Your combobox should be unbound (the ControlSource should be empty).
Then check out this article:
http://www.mvps.org/access/forms/frm0005.htm

MDB or ACCDB, the techniques are the same. I was just checking if you
have problems with ANY combobox.

-Tom.
Microsoft Access MVP

 

[Bob H]

The combobox is unbound, and I have a button which brings up a subform,
that also doesn't work in the mde file.

I think I'll leave it as an mdb file for the moment.

Thanks