New answers tagged

0

The way I am understanding your db, it looks like your Ownership table is acting as an associate between the other two. I would put a one-to-many relationship from parcel no. in the County table to parcel no. in Ownership and then a many-to-one relationship from Ownership name (or ID) to the primary key in the Contacts table. Essentially acting as a ...


0

Your design seems almost correct. I can pinpoint the following problems though: You're using the table Owners for two purposes: Have a list of owners (as entities/companies/societies) Have a list of people with stakes in each entity You need to break Owners in two, for example: CREATE TABLE Owners ( OwnerID int autoinc primar key, [Entity name] ...


0

You can store the data in Excel as the amount of time from the default date. If you just enter the time in the format you wish, it will automatically add the default date. Enter "4:30:00" as in [FinishTime] and it will save the data like in [Unformated Date], but will be visible format you wish and retain the proper time value. When you create the table ...


0

1. Set your SystemDB File in the Registry Note that you can only specify ONE of these damn things. On 32-bit Windows If your Windows installation on which your SQL Server instance installed is 32-bit which is doubtful...use the following key to set the path to your MS-Access Workgroup file (*.mdw): ...


0

I am running Access 2010 with linked MySQL tables. I discovered that the destination table had a field formatted as "Decimal" and a length of 3,0. I changed this to 4,0 in MySQL, refreshed linked tables, and the append to the table worked. So it appears the destination field was not wide enough for the resulting data.


1

Yes, by using linked tables. Here's the MySQL documentation https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html Add a User DSN from the ODBC Data Source Administrator, testing the link to your MySQL database to ensure you have the server, user name and password correct. In Access on the External Data tab ...


1

If you link Student-->Course-->Module, you would avoiding having Module Z causing both Course A & B to show up for that student. Alternatively, you could slightly modify the current to have Student-->(Module & Course). If your Enrollment table includes all three identifiers, it would be trivial to determine if the student is enrolled in Module Z ...


2

MS Access does not support CASE expressions. The most generic equivalent would be the Switch function. Using that function, a SQL CASE expression like this CASE WHEN condition1 THEN value1 WHEN condition2 THEN value2 ... END can be rewritten like this: Switch( condition1, value1, condition2, value2, ... ) A more specific, and probably more ...


0

the solution that I thought involves creating a calculated column on table2 called the_level which will give you the exact level depending on the ActivityCode. the second step is on your query, where you join table1 and table2, there you need to identify whether or not the item is entered within the timeframe set by the query, and change the the_level ...


2

You can either run the following as many times as it takes to get zero rows updated: UPDATE IncentiveAssignments SET PersonID = (SELECT MIN(PersonID) FROM UnassignedPeople up WHERE NOT EXISTS (SELECT 1 FROM IncentiveAssignments WHERE PersonID = up.PersonID) WHERE AutoNum = ( SELECT MIN(AutoNum) FROM IncentiveAssignments WHERE PersonID IS NULL); ...



Top 50 recent answers are included