Just A Clarification Please
Apr 7, 2007
When I made my Database, my Access Objects window displayed only the tables I created apart from the default Create table in design view, Create table using wizard and Create table by entering data. After finalising the database, I transferrred it to another PC and made some changes. The changed database was copied in pendrive and put in my harddrive. When I opened the DB, I find the following additional things in the Objects window :
MySysAccessObjects
MySysAccessXML
MySysACEs
MySysObjects
MySysQueriesMySysRelationships
How did this happen? It cannot be deleted. What is this? Can anyone explain?
Thanks in advance.
View Replies
Sep 19, 2007
Hi,
I have a bit of a big query and dont really know what some aspects of it are doing. Can someone tell me why there are so many group by functions? Does there need to be one for every FIRST in the query? If so, what does this accomplish? Also tmp_recdata_trades has around 20,000 records in it. And the query returns one record? Why just one? And its a record in the middle of the table somewhere so there must be something special about it?
SELECT DISTINCT tmp_recdata_trades.[Client SPN Number] AS spn_id, First(tmp_recdata_trades.[Client SPN Name]) AS spn_name, First(tmp_recdata_trades.[Revenue Event Day]) AS trade_date, First(tmp_recdata_trades.[Product Name - Level 4]) AS product_name, First(tmp_recdata_trades.[Client Domicile Name - Level 0]) AS client_domicile_name, First(tmp_recdata_trades.[Team Name - Level 1]) AS team_name, First(tmp_recdata_trades.[Person Name]) AS person_name, First(tmp_recdata_trades.[Source System Name]) AS source_system_name, First(tmp_recdata_trades.[Business Hierarchy Name - Level 1]) AS business_hierarchy_name, First(tmp_recdata_trades.[Client Role]) AS client_role, First(tmp_recdata_trades.[Client Sector Name - Level 3]) AS client_sector_name, tmp_recdata_trades.dox_fsa, tmp_recdata_trades.dox_aml, tmp_recdata_trades.dox_aof, tmp_recdata_trades.dox_sub_acct, tmp_recdata_trades.notes_aof_live, tmp_recdata_trades.notes_aof_archive, tmp_recdata_trades.remediation_project, tmp_recdata_trades.remediation, tmp_recdata_trades.custody, tmp_recdata_trades.pb, tmp_recdata_trades.xbus_signoff, tmp_recdata_trades.wss_signoff, tmp_recdata_trades.man_approved, tmp_recdata_trades.fsa_class, tmp_recdata_trades.opted_up
FROM tmp_recdata_trades
GROUP BY tmp_recdata_trades.[Client SPN Number], tmp_recdata_trades.dox_fsa, tmp_recdata_trades.dox_aml, tmp_recdata_trades.dox_aof, tmp_recdata_trades.dox_sub_acct, tmp_recdata_trades.notes_aof_live, tmp_recdata_trades.notes_aof_archive, tmp_recdata_trades.remediation_project, tmp_recdata_trades.remediation, tmp_recdata_trades.custody, tmp_recdata_trades.pb, tmp_recdata_trades.xbus_signoff, tmp_recdata_trades.wss_signoff, tmp_recdata_trades.man_approved, tmp_recdata_trades.fsa_class, tmp_recdata_trades.opted_up;
View 1 Replies
View Related
Nov 12, 2014
I would like to clarify the concept of record-level locking Say I have a TBLA which consists of two fields TBLA_FLD1 & TBLA_FLD2...TBLB which consists of three fields TBLB_FLD1 & TBLB_FLD2 & TBLB_FLD3
Now two users have declared the usage of the database as shared and pessimistic...I have generated a query in addition to TBLA & TBLB which is QryCombined which basically just a join of the two and consists of all five fields...If user1 has brought in a record query from QryCombined and edits on TBLA_FLD1 & TBLB_FLD3...At the same time user2 is trying to bring in as well QryCombined but with TBLA_FLD2 & TBLB_FLD1 and trying to edit both, will user2 be blocked by user1 who's editing the other fields
For all I know, the locking is based on record-level locking so I would suppose one record of QryCombined will comprise of all five fields so editing in any of them should actually block another user from editing. However I am not sure whether it is just a subset of the record that is the contesting area because user1 recordset has only two fields out of five, which do not happen to intercept the other fields that user2 is working on.
View 3 Replies
View Related
Jan 12, 2007
Firstly hello, I'm new! :)
Sorry for creating yet another thread on table design/relationships for surveys, I did search just needed a bit of clarification.
From what I understand from my search the best way to create a basic db for surveys would be a question table, response options table, and response table, this is similar to a database I have implemented for a simple online surveying system. Now this works with Y/N, or even limited response questions.
However I can't get it to fit with my current project, and I don't think it will, but I thought I'd check to see if I'm being stupid.
I have a survey, 20ish questions expecting 200-250 responses.
The questions consist of a mixture of:
Yes/No answers
Select all that apply answers
Select one from list
Select one from list or select Other and enter it yourself
Text/Comments
Because of the wide range of values, some completely unique and the possible number of answers per question per survey it seems the above method (and that implemented in At Your Survey which i've had a look at) would not work.
I only need to store responses (not questions), so I'm proposing a main table with related tables for those questions that require it.
So in essence a flat file response table with each field being a different question, each record being a separate survey response.
For those questions with multiple answers a separate table, related to the main response response table.
Data entry will be twofold, a web version of the survey automatically recording responses and manual entry into custom form within access for those paper returns.
Reporting will be faily widespread with a lot of cross referencing.
I know this is not a reusable format, and it is pretty much a one time only project anyway, relatively short lived. But I'd still like to create the most efficient product I can, within the time constraints.
Any views or help would be much appreciated :)
View 1 Replies
View Related
