Oct 19 2021 04:16 PM
Oct 19 2021 09:01 PM
The short answer is that it should be a very straightforward thing. Most of the time, such migrations can be handled with little or no modifications needed. The biggest problem would be if you installed a 64-bit version of Office instead of a 32-bit version in 2010. If so, there may be some changes needed to handle that difference. On the other hand, if you install the 32-bit version of Office, it's quite likely you'll just be able to open the accdb and use it.
The only way to be sure is to try it.
Oct 20 2021 01:02 AM
Oct 20 2021 01:30 AM
Oct 20 2021 04:36 AM
1. Just to be clear, you want the form to open at the first record not the last. Normally, that would happen anyway unless your code is preventing it. However you could add this line to the Form_Load event: DoCmd.GoToRecord , , acFirst
2. It is certainly possible to password protect a form (or report) though I've only ever done this to make users enter a password before opening a form with confidential data. I'm not sure why you would add a password to prevent the form being closed. Why not just remove the close button in the title bar or prevent the form being closed until certain actions have been performed? At some point the form will have to be closed anyway.
Do bear in mind that keyboard shortcuts such as Ctr+F4 can be used to forcibly close forms & indeed Alt+F4 closes the database itself. See https://support.microsoft.com/en-us/office/keyboard-shortcuts-for-access-70a673e4-4f7b-4300-b8e5-332...
Suggest you explain your purpose more clearly.
Oct 20 2021 04:52 AM
Oct 20 2021 08:01 AM
@Yvonnebatfink406 "... It's always opening up at the bottom of the new blank form instead of at the top, "
That is by design the way forms work. It's theoretically possible, I believe, to force a different behavior, but it's probably the path of least resistance to train your users to work with the default behavior.
The analogy I like to share is that using Access is somewhat like rowing a canoe. If you are trying to go upstream, against the basic design patterns of the software, you'll have to work a lot harder, i.e. paddle your canoe ferociously, to make any progress. If you go downstream, with the basic design patterns of the software, you only need to use the paddle to steer.
To paraphrase the old saying, "go with the flow or paddle like crazy to get anywhere."