John Viescas' Membership database

  • Thread starter Thread starter James Ivey
  • Start date Start date
J

James Ivey

Total Access Newbie here.

Holy Guacamole, I just received "Building Access Applications" in the mail
today, and I'm playing with the Membership database for my club/association.

First roadblock: How do you add fields to a "linked" table?

I want to add a couple of fields to tblMembers, but its giving me grief.
When I try to open it in Design view, it says "Table 'tblMembers' is a
linked table with some properties that can't be modified. Do you want to
open it anyway?"

So I say, sure. I open it and add my fields.

Then when I try to save it, it says "Membership Tracking can't save property
changes for linked tables. Do you want to continue anyway?"

I say, sure... save it, open it back up, and rats, my fields aren't there.

What do I need to do?

James
 
Thanks Albert.

I believe I get the concept, but still don't see how to add a field to an
existing table.

I'm a really green Access guy so please bear with me...

Looks to me like the BE is MembershipData.mdb

I opened up MembershipData.mdb, added my Notes field to the tblMembers. But
now how do I get it into my form in the Front end?

I'm opening the Membership.mdb, selecting frmMembers in Design view, but my
new field is not available to add.

Thanks for helping,

James
 
Hi James,

After you change the table structure in the back-end, you need to refresh
the linked table in your front-end to make the changes available to your
queries/forms/reports. Look under Tools - Database Utilities - Linked Table
Manager.

HTH,

Rob
 
Thanks for replying Rob.

I tried that already.... my new Notes field is still not available.

??
 
ahhhhh.... sweet success. The field list is coming from a query.

So I added my new Notes field to the qryMembers and voila! there's my field
:o))

I'm so happy <g>

Thanks guys for your help.

James
 
Hello guys,

i dont know if you guys are around, but i just need help with John viescas membership.mdb sample application.
i will appreciate if a link is sent or the sample application inboxed to (e-mail address removed).

thanks.
 
Back
Top