Questions tagged [ms-access-365]
The ms-access-365 tag has no usage guidance.
7 questions
0
votes
0
answers
47
views
"A potentially dangerous macro has been blocked"
There's an .ACCDB that's been used for years by a bunch of people. It's been inspected for macros, it has no macros in it.
When the file is opened MS ACCESS flashes this ominous warning:
After ...
0
votes
1
answer
95
views
How can I import multiple .xlsx and .xls files into multiple tables in Access?
I have 100 .xslx and .xls files with different formats and I need to import them all separately into Access keeping their original file names intact.
Folder example:
C:\Users\username\Desktop\...
0
votes
1
answer
142
views
See direct (instead of indirect) info about rented book in my "actors_directors" talbe dropdown list - Access365
I'm building a database of "actors_directors" who are renting "books" from my library - a kind of exercise to learn database basics :-)
This is how my "actors_directors" table looks like. They are ...
- 125
0
votes
0
answers
854
views
SSMA cannot read meta data (missing runtime components)
What I want to do should be rather easy: Use SSMA to transfer internal Access tables and queries to SQL-Server.
On my Notebook I'm running SQL-Server 2017 and Office 365 (32 bit)
As I have 32 bit ...
1
vote
2
answers
451
views
Enforce 1 or many relationship
In the er diagram below (not mine),
A Class can have many instructors via a standard junction table.
Is there a way of designing the Instructors/Classes tables using constraints to ensure that a ...
- 13
1
vote
0
answers
505
views
Can I use a Composite Key as criteria for selection in a query?
I have created a meeting minutes table and would like to use two fields as a unique ID for each meeting (field one is a meeting code (lookup from another table) for each type of meeting and field two ...
- 11
0
votes
1
answer
2k
views
How does one create a data base for a survey/questionnaire? [duplicate]
I need to create a database for a wordy questionnaire. At the end I want to be able to graph my information. Where can I do this?
