×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
I have a database in Access 95 w/a table called "inventory". I have created a new database in Acess 97 and want to bring over the "inventory" table & information. Also, anytime the data changes in the Access 95 "inventory" table, I want it to change in the Access 97 database. How can I do this? I have tried linking the 95 "inventory" table, but the data does not update in the 97 database. Is there a replication feature I can utilize? Specific help would be appreciated. You can also respond to Phendrix@hwins.com. Thanks!

RE: 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?
Kimi

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

(OP)
Yes because I am not the only person using the file and the
other people do not have Office 97.

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

What's your Refresh Interval (Tools/Options) I looked that the default is 60 sec. Have you changed the value or waited long enough?

Another solution might be using Timer-method to refresh the data periodically but this can eat up the performance.

Good luck,
Al

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

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.

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

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

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

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.

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

(OP)
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!].

Thanks!

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

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 www.executrain.com - 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!
Kimi

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

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close