Opening a Database from inside Access and go to a specific record.
- Thread starter Thales750
- Start date
- Local time
- Today, 10:13
- Joined
- Oct 29, 2018
- Messages
- 22,567
If you can't link to the table because of corruption, I doubt you will be able to go to that record at all (using any method). Just a thought...
Yes. The reason I'm doing this is for expedience. I have several Databases with entirely different order processing. These databases contain orders, estimating, purchase orders, draw schedules, customer statements etc.
But the core of these databases are all the same customer management, and overlapping project management.
Next many of my systems allow multiple tenants. For example, I use the system for both hourly database design billing and Contract Home Designs. The billing process is entirely different. But the core information is the same for both systems, so they are combined into one system. This keeps all tasks management in one location.
Currently, I open whichever orders system separately and navigate to the proper records when I need to invoice. Eventually all of the extraneous objects will be deprecated and the rest migrated to the core database. The big problem is that these two "Orders" modules share hundreds of the same named objects. EEK.
Last edited:
Sorry, I thought I was answering a different thread. The real answer is above. Please delete your previous answer if you don't mint.
- Local time
- Today, 10:13
- Joined
- Oct 29, 2018
- Messages
- 22,567
No worries and thanks for the additional information.
- Local time
- Today, 13:13
- Joined
- Feb 19, 2002
- Messages
- 47,179
The best way of accessing a specific record in a database is with a query that has criteria. You can link to the table or you can embed the db reference in the query itself.
That was my first thought, as well. In a multi-user interface you can specify the computer name or the user ID to limit it to a single user.
Thanks Pat.
