Questions tagged [ms-access-365]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
32 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
2answers
108 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 ...
1
vote
0answers
353 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 ...
0
votes
1answer
863 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?
0
votes
0answers
5k views

Removing Replication from MS Access mdb file using External Data->Access, is anything lost?

The new version of MS-Access 365 does not support replication as evidenced by the following error message: "The current version of Microsoft Access does not support replicated databases. To use ...