ISTech Support Forum - Inventory Data

Welcome, Guest. Please Login.

	05/29/25 at 07:50:12 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›

Pages: 1

Inventory Data (Read 1382 times)

mreaves53 Browser Engage Posts: 10 Gender:	Inventory Data 03/08/05 at 08:52:28 I am creating a database of our inventory numbers, the description, and the product that it is connected with. Can I import the inventory data into Access 2003. I can then easily tie each item to it's proper product. Thanks
Back to top	IS Tech Support paid subscriber IP Logged

aricon

Active Member

Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male

Re: Inventory Data
Reply #1 - 03/08/05 at 10:44:37

You need to create an ODBC link 1st and then either link the tables in your Access DB or import them (depending if you need "live" refreshed data or just static data). Do not create an Access 03 "project". Just a blank database. Also, if you want it accesible from each workstation you need to put it on the server and make sure that each workstation that will access it has a client ODBC set-up to match the Server ODBC and then create a shortcut to the Access app on the server.

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net

IP Logged

mreaves53 Browser Engage Posts: 10 Gender:	Re: Inventory Data Reply #2 - 03/08/05 at 13:26:03 I have only been working at this company about a month and am still learning about DBA. Which table would I import?
Back to top	IS Tech Support paid subscriber IP Logged

Tim Keating Senior Member DBA CLASSIC WIN 2000 C/S Posts: 298	Re: Inventory Data Reply #3 - 03/08/05 at 13:49:04 There are two Inventory master data files; BKICMSTR.Bxx and MTICMSTR.Bxx. Both contain Code and Description and different fields beyond that. You can browse them using the Maintain Database utility.
Back to top	Tim Keating Motor Guard Corporation IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Inventory Data Reply #4 - 03/08/05 at 16:51:37 You may also want to look at BKICLOC, BKICLOCM and Serial and LOT tables depending what info you are looking to capture.
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›