Access 95 and Access 97 linking of table....

I guess I would have to ask why you want to do this. Since the '95 version of the database is still being used, and snce '97 can open the '95 without saving it as a converted file, do you really need to bother with this?<br>
Kimi

Yes because I am not the only person using the file and the<br>
other people do not have Office 97.

What's your Refresh Interval (Tools/Options) I looked that the default is 60 sec. Have you changed the value or waited long enough?<br>
<br>
Another solution might be using Timer-method to refresh the data periodically but this can eat up the performance.<br>
<br>
Good luck,<br>
Al

Okay, if you have '97 and other users have '95, you can still use the '95 version through your '97, and maintain the '95 formatting so other users can still use it with '95.

Okay then, how can I do this between tables and forms and qry's in 95?

You need to open the database and select Relationships. You will want to then Add Tables to the view. Let's say you have 2 tables: table AB, and table XY. You "connect" the tables by selecting a field in one table and dragging it on top of the corresponding field in the other table, for example, you may click the field 'LastName' in AB and drag it on to 'LastName' in XY. You have now established a relationship between the two tables and info in one will update corresponding fields in the second table.

Thanks for the help. The fields have to be different (i.e. one has to be primary and the other has to be just a regular entry), right? I am in the Kansas City area [Northland]. Do you know of any one-on-one training programs where I can learn some of the "how to's" in Access? I have already tried calling training centers and had someone come out that didn't know as much as I needed [they could only answer one question in a 4 hour time frame!].<br>
<br>
Thanks!

What part of KC? (MO I assume - around Liberty? I used to work for Clay County-small world!) No, the fields do NOT have to be different - you can select the primary key for each table (i.e. social security #). MapleWoods has an okay one day class, I think it's about $100, and Executrain downtown is really good. Don't know what's still offered - been in Florida for 2 years. Check out - I think you can find out there. If you need a consultant, let me know. I may have a couple of contacts still. Good Luck!<br>
Kimi

If you've got the consultant contacts, I'll take them. I'm always interested in learning more about Access [and Notes and Visual Basic, etc....]. This is a small world as I used to work in Liberty and live in Clay County! I now work in Shawnee Mission, KS. It's about 45 minutes away [depending on how fast I drive...lol]. I envy you the opportunity to live in Florida. I absolutely love the weather -- I'm NOT a winter person unless I'm just visiting. Thanks again for the help and let me know if you find those contacts. You can email me at phendrix@hwins.com or Jimihndrks@aol.com.