Hi All,,, :)
Do we have to set "Allow AutoCorrect" text box property to "No" if we
don't need it..? can it increase the performance ?(If it be setted to
"No")
Regards
Hendra
you're welcome, Hendra ;) happy to help
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: Agestha Hendra
Thanx Crystal ... really usefully tools and very good article link...
Best Regards
Hendra
________________________________
Dari: Crystal
hi Hendra,
1. when a relationship has RI, Access automatically creates hidden index(es). IMO, it is not advisable to create another one since it is redundant. To see all Indexes, even Hidden ones, run my Analyzer and look at the reports
Crystal's Analyzer
http://www.accessmvp.com/strive4peace/Analyzer.htm
2. No
3. Allen Browne has great examples here:
http://allenbrowne.com/func-DAO.html
Warm Regards,
Crystal
Microsoft MVP, Access
remote training and programming
www.AccessMVP.com/strive4peace
www.YouTube.com/LearnAccessByCrystal
www.YouTube.com/LearnByCrystal
* (: have an awesome day :) *
________________________________
From: "agesthahendra
Hi Everyone...
I have several questions about indexing...
* Is there any effects if we indexed manually the foreign key
fields..?(the RI is implemented)... i just want to make sure the
fields are indexed because i want to transfer the MDB to Mysql.
* Does Access create index to the field automaticly if we build join in
query design (not in tables relationships window)..?
(the tables are not joined in tables relationships window)
* To make the process faster, do we have to drop the index of an
indexed field before we run Append / Delete query...?
If so, how the syntax to drop and create index (create index with
the type of index ... Duplicate OK or No Duplicate)
Any explanation would be appreciated..thank you
Regards
Hendra
[Non-text portions of this message have been removed]
Hendra-
I don't know. It depends on whether the "converter" recognizes the hidden RI indexes or not. They're visible in the DAO TableDef.Indexes collection.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
----------------------
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Agestha Hendra
Sent: Sunday, April 01, 2012 5:20 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Bls: [MS_AccessPros] Indexing Fields
Thanx John..
I want to transfer my BE to Mysql using DB Convert to Mysql, do i still to not index the foreign keys..?
but yes i implement the RI in my Access FE, but do Access still can make auto index on foreign keys in Mysql DB..?
Regards
Hendra
________________________________
Dari: John Viescas <JohnV@msn.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Sabtu, 31 Maret 2012 15:24
Judul: RE: [MS_AccessPros] Indexing Fields
Hendra-
1) Access builds a hidden index on the Foreign Key when you define RI. You can
define another index, and it becomes an "alias" of the hidden one - there's only
one physical index. But the hidden index does subtract from the limit of 15
indexes per table, so defining one you can see in the UI reduces the number of
available indexes further.
2) No.
3) Dropping an index will positively affect performance only when your Append or
Delete operation encompasses tens of thousands of rows. Access does support
primitive forms of DROP INDEX and CREATE INDEX. You can also do these
operations in DAO. See also:
http://office.microsoft.com/en-us/access-help/CH001041016.aspx
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
----------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Saturday, March 31, 2012 8:55 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Indexing Fields
Hi Everyone...
I have several questions about indexing...
* Is there any effects if we indexed manually the foreign key
fields..?(the RI is implemented)... i just want to make sure the
fields are indexed because i want to transfer the MDB to Mysql.
* Does Access create index to the field automaticly if we build join in
query design (not in tables relationships window)..?
(the tables are not joined in tables relationships window)
* To make the process faster, do we have to drop the index of an
indexed field before we run Append / Delete query...?
If so, how the syntax to drop and create index (create index with
the type of index ... Duplicate OK or No Duplicate)
Any explanation would be appreciated..thank you
Regards
Hendra
[Non-text portions of this message have been removed]
Thanx Crystal ... really usefully tools and very good article link...
Best Regards
Hendra
________________________________
Dari: Crystal <strive4peace2008@yahoo.com>
Kepada: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Dikirim: Sabtu, 31 Maret 2012 15:25
Judul: Re: [MS_AccessPros] Indexing Fields
hi Hendra,
1. when a relationship has RI, Access automatically creates hidden index(es). IMO, it is not advisable to create another one since it is redundant. To see all Indexes, even Hidden ones, run my Analyzer and look at the reports
Crystal's Analyzer
http://www.accessmvp.com/strive4peace/Analyzer.htm
2. No
3. Allen Browne has great examples here:
http://allenbrowne.com/func-DAO.html
Warm Regards,
Crystal
Microsoft MVP, Access
remote training and programming
www.AccessMVP.com/strive4peace
www.YouTube.com/LearnAccessByCrystal
www.YouTube.com/LearnByCrystal
* (: have an awesome day :) *
________________________________
From: "agesthahendra
Hi Everyone...
I have several questions about indexing...
* Is there any effects if we indexed manually the foreign key
fields..?(the RI is implemented)... i just want to make sure the
fields are indexed because i want to transfer the MDB to Mysql.
* Does Access create index to the field automaticly if we build join in
query design (not in tables relationships window)..?
(the tables are not joined in tables relationships window)
* To make the process faster, do we have to drop the index of an
indexed field before we run Append / Delete query...?
If so, how the syntax to drop and create index (create index with
the type of index ... Duplicate OK or No Duplicate)
Any explanation would be appreciated..thank you
Regards
Hendra
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Thanx John..
I want to transfer my BE to Mysql using DB Convert to Mysql, do i still to not index the foreign keys..?
but yes i implement the RI in my Access FE, but do Access still can make auto index on foreign keys in Mysql DB..?
Regards
Hendra
________________________________
Dari: John Viescas <JohnV@msn.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Sabtu, 31 Maret 2012 15:24
Judul: RE: [MS_AccessPros] Indexing Fields
Hendra-
1) Access builds a hidden index on the Foreign Key when you define RI. You can
define another index, and it becomes an "alias" of the hidden one - there's only
one physical index. But the hidden index does subtract from the limit of 15
indexes per table, so defining one you can see in the UI reduces the number of
available indexes further.
2) No.
3) Dropping an index will positively affect performance only when your Append or
Delete operation encompasses tens of thousands of rows. Access does support
primitive forms of DROP INDEX and CREATE INDEX. You can also do these
operations in DAO. See also:
http://office.microsoft.com/en-us/access-help/CH001041016.aspx
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
----------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Saturday, March 31, 2012 8:55 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Indexing Fields
Hi Everyone...
I have several questions about indexing...
* Is there any effects if we indexed manually the foreign key
fields..?(the RI is implemented)... i just want to make sure the
fields are indexed because i want to transfer the MDB to Mysql.
* Does Access create index to the field automaticly if we build join in
query design (not in tables relationships window)..?
(the tables are not joined in tables relationships window)
* To make the process faster, do we have to drop the index of an
indexed field before we run Append / Delete query...?
If so, how the syntax to drop and create index (create index with
the type of index ... Duplicate OK or No Duplicate)
Any explanation would be appreciated..thank you
Regards
Hendra
[Non-text portions of this message have been removed]
Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com
1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.
Moderator
Dear Para master Access,
Bagimana caranya membuat query yang fieldnya ngambil langsung dari User name di form login, sehingga saya tidak perlu membuat banyak query dan form. Terlampir saya kirimkan capture querynya. Terimakasih
Salam
Widodo
Attachment(s) from Widodo
1 of 1 Photo(s)
