John Viescas' Membership database

[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

 

[Albert D. Kallal]

I explain how linked tables work here, and how you modify the tables:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[James Ivey]

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

 

[Rob Parker]

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

 

[James Ivey]

Thanks for replying Rob.

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

??

 

[James Ivey]

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
))

I'm so happy <g>

Thanks guys for your help.

James

 

[obicauka]

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.