Wikipedia:Reference desk/Archives/Computing/2021 December 9

= December 9 =

Help in Access Is Turned Off
I am working in an Access (version 2110, Office 365) database on my Windows 10 computer, and I tried to request Help, which should query Microsoft's on-line library. I get the message, "This command isn't available. Your organization's administrator turned off the service required to use this feature." I am the administrator. I have Access and other Office products on a desktop computer and a laptop computer and have set up networking between them. I am getting this message on the desktop computer, when the database that I am editing is on the C: drive of the desktop computer (in case it matters). What do I need to tweak in order to be able to use Help again? Robert McClenon (talk) 20:11, 9 December 2021 (UTC)
 * This seems to directly address your issue. -- Jayron 32 20:22, 9 December 2021 (UTC)
 * User:Jayron32 - That gave me enough information to address the issue. It was about the Privacy Options in Outlook, so I had to find them in Access, but I found them.  Some of the Microsoft terminology is stupid.  Thank you.  Robert McClenon (talk) 07:39, 10 December 2021 (UTC)

Loading Data from Spreadsheet into Two Joined Tables
Okay. Here is what I was trying to figure out how to do that I wanted Help for. I have a spreadsheet that I am trying to import into Access. So far, that would be easy if I wanted to import each row from Excel into one record in one Access table. However, in Access, I have defined table A and table B, with a one-to-many relationship. What I want to do is to create one record in table A and one record in table B. I have a query that views them as one virtual record. However, if I knew a way to import data into a query, rather than into a table, I have forgotten it. So what I want to do is to import the data so that it splits across the two records. Is this possible, and how? I am sure it is possible, but I just want a quick clue as to how to do it most easily. I know that I could load the data into a single temporary Access table and then play some sort of game with Append queries. Robert McClenon (talk) 20:24, 9 December 2021 (UTC)
 * When you run the Data Import wizard, there is an option at the point where you specify the data type for each column "Do not import field (Skip)". Just run the wizard twice, once for each table, skipping the fields you don't want in the particualr table.  Don't think this is very good database design, but that's a way you could do what you want.--Phil Holmes (talk) 10:01, 10 December 2021 (UTC)
 * Thank you, User:Phil Holmes. I didn't use the Data Import Wizard, and wasn't aware of it. and don't particularly trust things that Microsoft calls wizards.  In particular, I want to stay clear of anything that tries to automate the process of applying first through third normal forms, because, having been an Oracle database designer, I know normalization better than a tool does.  However, I used two Append queries, to populate the two tables, and a sequence number to join them, which is close enough to what you said.  Robert McClenon (talk) 16:56, 10 December 2021 (UTC)