Search results

Well, that was simple. Thanks!

Good morning, I am trying to add an amount criteria of >= $1000 to this report. What's wrong? Private Sub cmdFYTDBUEndowmentCommitments_Click() If Not IsDate(Forms![Development Report Manager]!ReportDate.Value) Then MsgBox "Please pick a Report Date!", vbOKOnly, Me.Caption: Exit Sub...

Well, we AREN'T doing that, this was just to explain the connection. Changes are only made to the data through the export and replace.

Gotcha. No. This is not split. The .MDBs are just the exported files that get fed into the .accdb. You can modify in both file types.

Can you define FE and BE? Does this mean you are out of ideas/stumped?

Not sure I know what FE and BE means. There is not an integration between the CRM and Microsoft. This is why manual export and replace processes are occurring.

User is replacing tables when "updating". We don't care what was there before, we only care about the new data replacing the .MDB. I've narrowed it down some. The issue is occurring when the user replaces my .MDB. In testing, the user can manually update data in the .MDB and all is well within...

Here goes: This is a specific example, but if the user updates any of the linked .MDB files, it is the same occurence. 1. .MDB is updated via export from CRM. .MDB file has three tables. All are updated successfully. 2.Within the .accdb (file that uses the .MDB files as data sources and...

All data is entered into our CRM. Weekly, I export this data to .MDBs. There are multiple because they contain different data that gets connected within the queries in the .accdb. No need to relink each time. Process is fine. This is a user specific issue.

There are a total of 6 .MDB files connected as external data to the .accdb file. They are not imported.

Thanks for your inquiry. To be clear. All queries and reports work for me as they should. This is occurring ONLY when another user attempts to update the source data. Source data comes from .MBD that files are exported from an external CRM. The .MDB files are fed into the .accdb file as tables...

Thanks for your help. That did not change anything. I'll ask my IT team to compare our profiles.

This has been updated for the user. Now that we've established the create permissions are on, what's next?

I'm answering all of your questions the best I can. I've posted because I cannot figure it out. The lock file does get created but it's different from how it is occurring on my screen. My screenshot has the Access icon with a lock. The other user has an adobe? icon Mine: Other User...

The report is fine when I run it. The other user cannot update the table. It is closed when attempted.

When I remove the third box named DOD Meeting Goal (this is a query), the other user still doesn't have access to update the tables. Works fine for me. I don't get it! Somewhere, I have permissions that others do not.

I'm not able to post the database. It contains secure information. It is not split as this user is to take over the role of maintaining the reports. They need the same access as myself. Can you explain why we should not share the same copy? We are both accessing it from a shared folder. Copies...

Not only dos the user still not have access, it doesn't work for me with that change.

There were not the same list. I have added to the criteria of the Solicitor Meeting Union to only included the names in Solicitor Goals

Other user has the same 4 when logged in: