How to preserve linked Lawson tables in Access when copying to different machines
Need an Access Lawson database to reside on the desktop of select users without having to relink all the tables each time?
If so, see the below query for the DSN-less connection with a function to relink all the tables and pass-through queries. This also just works for databases in general. Good luck!
If this process seems too complex or time-consuming, Nogalis offers expert managed services to help you manage and optimize your Lawson databases, including handling table linking and other database configurations. Whether you’re looking to simplify data management across multiple machines or improve overall system performance, our team can provide the support you need—without the overhead of a full-time, in-house staff. Contact us to learn more about how we can assist with your Lawson environment.
Retiring Lawson, PeopleSoft, or Oracle? APIX archives the entire application — every table, every year, attachments and security included — into your own AWS account in about 30 days, so you can decommission the legacy system and keep full access to the history.
