Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 207
Search took 0.03 seconds.
Search: Posts Made By: jaryszek
Forum: General 03-15-2019, 03:30 AM
Replies: 14
Views: 258
Posted By MajP
Re: Tables restriction

How to create a composite index that is not the PK
http://www.geeksengine.com/article/composite-unique-index-access.html
Forum: General 03-13-2019, 03:55 AM
Replies: 14
Views: 258
Posted By MajP
Re: Tables restriction

Take tblAvailableVersions and put in the middle. Add two copies of tblTopology one on the left side and one on the right side. Add two copies of tblSystem versions one on the left and one on the...
Forum: General 03-12-2019, 11:24 AM
Replies: 14
Views: 258
Posted By MajP
Re: Tables restriction

Sorry I made a mistake in the table posted. Where it lists topologyTwo_FK it shows 1 where it should show 3 (NW). Using your two restriction tables I would get the following.
...
Forum: General 03-11-2019, 09:20 AM
Replies: 14
Views: 258
Posted By MajP
Re: Tables restriction

i deleted Topology Field from tblSystemVersions

I posted before seeing this. So you cannot pull the Topology in a query. Your tblAvailableVersions should then contain the topology
...
Forum: General 03-11-2019, 05:57 AM
Replies: 14
Views: 258
Posted By MajP
Re: Tables restriction

Those restrictions tables do not look normalized. You have version names as columns. Why can you not simply have a single table?

TblAvailableVersions
SystemVersionOne_FK
SystemVersionTwo_Fk...
Forum: General 03-03-2019, 08:56 AM
Replies: 19
Views: 355
Posted By MajP
Re: Hierarchy in Access tables

There is a very long discussion on this topic in this thread:

https://www.access-programmers.co.uk/forums/showthread.php?t=303433&highlight=Horse

But yes you can create a relationship. I...
Forum: General 03-02-2019, 06:41 AM
Replies: 19
Views: 355
Posted By isladogs
Re: Hierarchy in Access tables

Congratulations. And you've helped to create your very own hierarchy :)
Forum: General 02-28-2019, 06:23 AM
Replies: 19
Views: 355
Posted By MajP
Re: Hierarchy in Access tables

One more thing. The standard MSCOMCTL Treeview is not supported in 64 bit applications, so the life of your treeview is short. A lot of users will not be able to use it. I have been using the...
Forum: General 02-28-2019, 06:15 AM
Replies: 19
Views: 355
Posted By MajP
Re: Hierarchy in Access tables

The issue with reflexive data is that you do not know how many levels deep to make the query. In access sql there is no capability for recursive queries. Your query has 5 levels, but if the data...
Forum: General 02-28-2019, 05:44 AM
Replies: 19
Views: 355
Posted By MajP
Re: Hierarchy in Access tables

Need to union 6 queries
Return only ParentMother
union
Return only recornds with Parent no other
Union
Return only records with Parent and GrandParent
Untion
Return only records with parent,...
Forum: General 02-28-2019, 05:07 AM
Replies: 19
Views: 355
Posted By isladogs
Re: Hierarchy in Access tables

Can you please provide the link to the thread where you obtained the example you've uploaded

Also in case you've not seen them before have a look at these interesting examples involving...
Forum: General 02-24-2019, 08:21 AM
Replies: 4
Views: 131
Posted By The_Doc_Man
Re: Linking table from external database vs internal database performence

Having provided the explanation, here is the actual answer:

To avoid bloating, do things in a way that avoids deletion and updating in the database file that you want to keep.

Mapping through...
Forum: General 02-24-2019, 06:43 AM
Replies: 4
Views: 131
Posted By theDBguy
Re: Linking table from external database vs internal database performence

Hi. The file size shouldn’t change much when you link because the data is stored elsewhere.
Forum: Tables 02-23-2019, 06:58 AM
Replies: 11
Views: 245
Posted By The_Doc_Man
Re: Import queries and UPEND operation

This topic moved so quickly I didn't notice it earlier. Here is my take: The question of deletion falls into two parts.

Part A: Defining what you want to delete - will greatly benefit from the...
Forum: Tables 02-23-2019, 04:56 AM
Replies: 11
Views: 245
Posted By CJ_London
Re: Import queries and UPEND operation

there are three methods of searching

find - where a searchvalue is found in an existing recordset - but still displays all records
filter - where a recordset is reduced to display just the...
Forum: Tables 02-22-2019, 06:17 AM
Replies: 11
Views: 245
Posted By isladogs
Re: Import queries and UPEND operation

I thought I had covered the pros and cons of indexing in my various articles.

Indexing speeds up searching. The improvements can be dramatic on large datasets e.g. 250x faster on fields with a...
Forum: Tables 02-22-2019, 05:43 AM
Replies: 11
Views: 245
Posted By CJ_London
Re: Import queries and UPEND operation

it really depends on how many records are in the temp table and how complex the query is to update the destination tables.

Appending data to an indexed temp table will be noticeably slower for a...
Forum: Tables 02-22-2019, 05:07 AM
Replies: 11
Views: 245
Posted By Frothingslosh
Re: Import queries and UPEND operation

The word you want is 'hasten'. 'Fasten' means something completely different. :)

Indexes covering your WHERE clause *MIGHT* speed things up - it depends on whether the search speed enhancement...
Forum: Tables 02-22-2019, 04:32 AM
Replies: 11
Views: 245
Posted By Gasman
Re: Import queries and UPEND operation

Well at the bottom of that link Colin states :

NOTE:

Indexing the fields will make the process slower as the indexes will also need to be updated
Forum: General 02-21-2019, 10:11 AM
Replies: 7
Views: 193
Posted By The_Doc_Man
Re: Cannot delete a field taht is a part of an index or is needed by the system

The comments I made have to do with how often you need to do this operation. If it is a one-time thing, manually import the spreadsheet to a staging table (or temporary table if you prefer that...
Forum: Queries 02-21-2019, 04:08 AM
Replies: 3
Views: 96
Posted By isladogs
Re: Full outer join in Access

Use an unmatched left outer join and union it with an unmatched right outer join....or use sql server which supports full outer joins
Forum: Queries 02-21-2019, 04:05 AM
Replies: 3
Views: 96
Posted By Minty
Re: Full outer join in Access

As far as I'm aware there is no such thing as a Full Outer Join in access.

I use them occasionally in SQL Server to produce exception lists when comparing multiple data tables with the same...
Forum: General 02-20-2019, 02:23 PM
Replies: 17
Views: 325
Posted By pbaldy
Re: Using Access as FE and external database BE - queries performance

I should have reread it to make sure it was still relevant, but I remembered it being a big help. It is older though. Like me.
Forum: General 02-20-2019, 10:41 AM
Replies: 17
Views: 325
Posted By pbaldy
Re: Using Access as FE and external database BE - queries performance

No problemo! The info was worth what you paid for it. :p
Forum: General 02-20-2019, 09:21 AM
Replies: 17
Views: 325
Posted By pbaldy
Re: Using Access as FE and external database BE - queries performance

By the way, I recall Leigh's FAQ here being very informative:

http://www.utteraccess.com/forum/t1732935.html
Showing results 1 to 25 of 207

 
Forum Jump



All times are GMT -8. The time now is 02:52 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World