Modify and update a form

[ocm]

Greetings,



I’m tasked to support an access 2016 db that was created by someone else. The DB is split:
the BE is housed on department shared drive and users have copies of the FE that is linked to the BE.


Couple of questions:
1. I made a copy of an existing form (frmLogin) named it (frmLogin_new) and made some modifications: added a logo, align labels etc. how do I replace the old form with the new one and distribute the FE to end users?


2. There is a report that managers attempted to run (status report: open/closed etc. when they click on open cases button, it will prompt for a name they enter the requested question nothing happens. However, when I tried the same report I could view the report without any problem. Can this be a permission issue?

TIA,

[ranman256]

1 rename the frmLogin to frmLogin-old.
then rename -new to frmLogin.

2. Maybe not permission, try running the query on that PC. The raw query, not thru the buttons.

[ocm]

Thanks for the response. 1. Okay. since it is just a logon screen all I need is to distribute the modified FE, no linking to the BE required, correct? 2. When you say ‘try running the query on that PC…’ do you mean user’s PC? because end-users do not have access to queries (only access to reports via a switchboard button)

Regards,

[ranman256]

if the logon uses no backend, then yes, FE changes only.
reports are connected to queries.

[ocm]

Thanks for the reply.

The query is ok as I’m able to run the report & get correct result. Also, another manager can run the same report without any problems.

However, there is a new manager on board that is unable to run the report. That is why I suspected a ‘permission issue”.

How is access 2016 permission differ from the older version? e.g. Access 2000 etc.?

Regards,

[ssanfu]

1. Okay. since it is just a logon screen all I need is to distribute the modified FE, no linking to the BE required, correct?

The BE has only tables. The FE has everything else. The login screen limits (or should limit) who can open the dB. The FE still must be linked to the BE for the reports/queries/forms to be able to have access to the data.

2. When you say ‘try running the query on that PC…’ do you mean user’s PC? because end-users do not have access to queries (only access to reports via a switchboard button)

End users *could* have access to everything in the FE, unless you have locked down everything; maybe using permissions, by converting the dB to an accde, etc.

However, there is a new manager on board that is unable to run the report. That is why I suspected a ‘permission issue”.

I would also suspect permissions as the issue. But iI would look at network permissions first.
The BE is on a computer/server somewhere on the LAN??

[ocm]

Steve, thank you for the reply.

The way it was setup is as such regular users have access to forms and managers forms and the ability to run reports. I also checked & noticed both the BE/FE have .accde extension.
Regarding permissions, the manager is able to click the ‘open case report’ button, the manager then prompted to enter a ‘case worker name’ after answering to the prompt nothing happens. I’m not sure if this is a network permission or, ms access permission.


TIA

Regards,

[ssanfu]

Hard to say without being able to put hands on the dB. Can anyone print a report? Not, do they have permissions, but does the report print for anyone?

Since you said you made a copy of the login form, you must have the accdb, because you cannot edit an accde file.
Have you stepped through the code to see what is happening?

[ocm]

Thank you Steve.

For some reasons the report was designed w/o the print option. When I took over the position, the person who designed the db wasn’t around. I’ve yet to figure out how everything is set up etc.

In terms of permissions, I’ve couple of managers log into my PC using their own credentials and run the same report that they were unable to run from their PC.
I was surprise to see they could run the report without any problem.

Can this be a network permission issue somehow attached to computer name?
How/where do I check this?

TIA,

[AccessPower]

You can set permissions groups like ComputerName\Users. Right click your database and goto the Security tab.

[ocm]

Thanks for the reply.

Where can I obtain additional info. to set up permission for users/groups etc. via computerName. Also, verify if everybody is using the same ODBC connection etc.?

TIA,

Regards,

[ocm]

Greetings,

I’m not sure if the following test I performed give us any lead the cause(s) of this issue:

1. I can run the report fine.

2. Few managers are unable to run the report: But, when I’ve them come to my desk, have them login using their credentials (ms access credentials) on my PC, the report runs fine for them.

3. I used my ms access credentials to log into one of the manager’s PC, I was unable to run the report.

Though not sure, one of the manager thinks the issue started after ms office was upgraded to office 2016.

TIA

Regards