Search results

I work on any PC I try. The other user does not work on any. What do you think this indicates regarding permissions? I'll add that this specific .accdb is the only issue. We have other .accdb files where the user is able to update as expected.

You're on target. It does not relate. It is being used in the final report to calculate percentage to team goal for each DOD. How would you suggest I write the union? Below is what I currently have (don't hate me for my naming conventions): SELECT [Solicitor Meeting Union].Act_Category...

Please explain where the temporary relationship would go. Additionally, this query works fine for me when I update the table/.MDB. It does not work for anyone else if they update the table/.MDB. This issue is why I've posted.

I don't create the tables. These are exported from another database. Please advise.

This ties back to the screenshot above.

No Filters. I also don't see how it would work fine for me if there were any.

Column headers from the .MDB are there but no data

I posted similarly a while back and haven't been able to figure this out so I'm rewording in hopes to clarify. Functionality is perfect when I update the source data .MDB file that connects to my .accdb reporting. When any other user updates the .MDB, they can successfully view the new data...

Good morning, wanted to follow up to see if you had any other insights. @Pat Hartman

Good morning, wanted to follow up to see if you had other testing ideas. thanks

Thanks for the reply. These are not switchboards. The other user and I would not be in the space at the same time. The other user is being trained as backup to generate and modify the reports built.

How do I confirm if the form is a switchboard? I do not believe it is user specific. You mention a front-end file. I do not believe front/backend files/ split databases were created. I am only aware of the one I build in. User does have exact same securities

No change when moving it to the folder that they can update. They can modify other .accdb files. So I'm not sure I follow how this would be a Windows permissions issue. How do I confirm if the file is using old Access security? Finally, I export .mdb files from a managed database and use them...

Somewhat but the final folder, no. As an example, here are the file paths: User unable to run queries here: Reporting Folder\Access Reports\Progress Report\.accdb file User able to run queries here: Reporting Folder\Access Reports\Development Report\.accdb file

User can update other Access databases, but not this one.

Thanks, like I said, each of the tables used in the query are operable. So what exactly am I looking for in the query set up that would indicate the issue?

I inherited but also have modified since. The original developer is not accessible.

Good morning, I'm looking for guidance on why user access would be different from mine. Other user is able to update the linked .MDB file and sees the updated data in the tables within .accdb file but then the built query shows up blank. Why would this be occurring? When I run them, everything...