Share via

Editing Queries in Split Access Database

Anonymous
2022-07-14T13:47:59+00:00

My company has a fully built access database that was split by my predecessor. It works great.

My question is this, I need to edit a query to include one more column from the table the query already pulls its data from. I am not updating the tables at all. I have checked to make sure everything is linked properly. Do I just redistribute the front end to the database users?

Further context, I made a copy, edited the query so that it pulls the extra column I want. Would I do the same steps in the original file then save the database and redistribute to my end users?

Microsoft 365 and Office | Access | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2022-07-14T17:02:21+00:00

    The purpose of a split database is to split the data tables from everything else. So yes, you make changes in a copy of the front end, test the changes. then redeploy the new front end.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-07-14T14:19:28+00:00

    Hello Alexis,

    Thanks for reaching out here regarding this query.

    If you might still need further assistance, don't hesitate to revert.

    Warm regards,
    Albert

    Was this answer helpful?

    0 comments
  3. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2022-07-14T14:10:33+00:00

    The query should be in the front-end which can be distributed to other users.

    Was this answer helpful?

    0 comments