Home Button  Buy Button 

Topic:   Link to Access 2016

By: GrahamPosted on: Oct 31 2019 at 04:52:04 AM
I would like to link our MiniMRP to some tables in an Access2016 database. I do not seem to be able to do this. I can open the MiniMRP tables and query them but can not link the tables from one db to another. Is there a MiniMRP version running on a newer file format?

By: GuestPosted on: Nov 1 2019 at 12:32:33 PM
Are you sayng you want to create linked tabled inside the MiniMRP data file that pull data from some external Access file?
Or are you saying that you want to create an external access file with linked tables that pulls data FROM the MiniMRP file?

I don't think MiniMRP cares too much about the data file format so if you converted the MiniMRP data file to MS Access 2003 format would that work? I think any "MDB" file format will work. But the ACCDB format won't.

if you do try to convert the minimrp data file to a higher version then obviously make a backup.

but, in the long term I think they're trying to move away from MS Access completely. So maybe you should be looking at migrating your Minimrp up to SQL Server and point your linked tables at that.

By: GuestPosted on: Nov 2 2019 at 05:51:58 AM
Yeah. Any "MDB" format is fine. MiniMRP isn't based off of MSACCESS it just happens to use the Microsoft "JET" format which, coincidentally, is what's used by the Access 2000 MDB format. But you can convert the data file to newer MDB formats and MiniMRP doesn't care.

So open the data file with MSAccess and select the option to either 'convert' or SaveAs.

But DO NOT save as ACCDB. Only MDB formats are supported.

By: GuestPosted on: Nov 4 2019 at 02:21:03 AM
Thanks for the input. I was planning to link the minimrp files to our existing access db. So for instance we can join up our supplier data (in an Access db) to the minimrp data to get a full picture.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Link to Access 2016

Enter the numbers.

Your name here is optional