6.1 MS Access updating

Yahoo Archive
1
Norm,

I would create a macro that links the tables, extract what you need into
another table and delete the linked table. This way, the database is
small, and has only the information needed. This is what I find very
useful from MS-Access. You can associate that macro to a button, your
user clicks the button, and when done, ms access opens a table, form, or
report with information needed without any links to Vantage.

You can contact me off-line if you need more help on linking-importing
Vantage tables using a macro.

Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norm Watkins
Sent: Thursday, March 15, 2007 10:37 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage]6.1 MS Access updating



The thread that ran last week about using MS Access for reports, etc.
intrigued me so I'm trying to use it for some reports. But I'm missing
something. I've successfully linked to the Vantage tables, built some
queries, but my information in Access is not updating as the Vantage Db
changes - so what am I missing?

Thanks,

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307






[Non-text portions of this message have been removed]
2
The thread that ran last week about using MS Access for reports, etc.
intrigued me so I'm trying to use it for some reports. But I'm missing
something. I've successfully linked to the Vantage tables, built some
queries, but my information in Access is not updating as the Vantage Db
changes - so what am I missing?

Thanks,

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307
3
Did you import the tables or link the tables? If you imported the
tables, you would need to re-import to get updates. With linking, it
should be real time direct access to the db.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norm Watkins
Sent: Thursday, March 15, 2007 11:37 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage]6.1 MS Access updating



The thread that ran last week about using MS Access for reports, etc.
intrigued me so I'm trying to use it for some reports. But I'm missing
something. I've successfully linked to the Vantage tables, built some
queries, but my information in Access is not updating as the Vantage Db
changes - so what am I missing?

Thanks,

Norm Watkins
Engineering Manager
ELECPAC
Phone: 847-639-2307




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]