Linking Access to Visual

We have an Access Database that holds years and years of proprietary information and I am looking for a way to get this information either into Visual or at least linked to Visual. If we can do this it will save us time and money on duplicating information.

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

unknown

Help us out a little.
If you have master tables such a customers, vendors and parts in access it should be relatively easy to move this to Visual from Access.
If you are talking about transactions such as orders(CO,PO,WO) or Inventory and GL transactions and distributions this could be more problematic depending on what information is available in Access, the data structures, and data types used. But its doable.
Do you have a question about this process?

unknown

The information or columns that I have in access does have the customer name but the other fields are specific to our product. The process right now is that we create a customer order in Visual and tie a work order to it. There is a bunch of data that is collected and manually written down on a form. Then the form is transferred from the document into the Access Database. They go back and update the work order in Visual with their findings. That information is then sent back to the customer. So, we basically have three manual steps to complete for one process. I would love to be able to just have a computer in the work area and add all of this into Visual but I really do not see a way of doing that. I was hoping that maybe someone out there has created something in SQL or Access that I would eliminate all the manual entries. I have a blank database that I could send so that you can see what information we gather.

kelly-degobbi

There are several way around this, but I know of one guy who knows this stuff better than anyone else I know. He is a guru when it comes to access and visual. Please email me at kchristie@accufabnc.com and I will give you his contact information. I dont want to post it publicly.

unknown

Celine,
This mystical bunch of data written down ; Is it something that requires updating the work order requirements or operations? Does it change the customers order?
is it just specifications that need to be noted but do not change work order requirements or operations?

unknown

Sorry... I didn't see the previous post. that should do it for you

unknown

If this doesn't workout I will let you know. But to answer your question, the mystical information that needs to be in the work order is data that we need to be able to search on so I can't put it in the specification area.

Copyright © 2025 Infor. All rights reserved.