|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
June 2nd, 2009, 07:21 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
make table query corrupts hyperlink field
has anyone had this problem? i have a make table query that selects
several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. tia, mcnewsxp 
|
|
#2
June 5th, 2009, 01:29 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
On Tue, 2 Jun 2009 11:21:57 -0700 (PDT), mcnews
wrote: has anyone had this problem? i have a make table query that selects several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. I don't know why this problem is happening, but I recommend not using MakeTable anyway. It's actually more reliable to have a permanent table, then delete all the records and reload it with an Append query instead. Then you get a consistent structure with less opportunity for Access to misinterpret the field types needed. If you try it with an Append query into an existing table, does the problem still occur? Armen Stein Microsoft Access MVP www.JStreetTech.com
|
|
#3
June 5th, 2009, 01:40 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
mcnews,
You never stated how big your database is or what version. I would also make sure Name AutoCorrect is off, just because... I also wonder why you don't create a query and use those results? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mcnews" wrote in message ... has anyone had this problem? i have a make table query that selects several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. tia, mcnewsxp
|
|
#4
June 5th, 2009, 02:57 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
i use 2007, but users are using 2003. i use 2003 at home.
i will try the append query idea. You never stated how big your database is or what version. I would also make sure Name AutoCorrect is off, just because... I also wonder why you don't create a query and use those results? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mcnews" wrote in message ... has anyone had this problem? i have a make table query that selects several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. tia, mcnewsxp
|
|
#5
June 5th, 2009, 03:00 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
i can't see why name autocorrect would be a bad thing ...?
"Gina Whipp" wrote in message ... mcnews, You never stated how big your database is or what version. I would also make sure Name AutoCorrect is off, just because... I also wonder why you don't create a query and use those results? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mcnews" wrote in message ... has anyone had this problem? i have a make table query that selects several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. tia, mcnewsxp
|
|
#6
June 5th, 2009, 03:04 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
append query does exactly the same thing
googling tells me that you can't group by hyperlinks. wonder why it worked before and still works on older versions of the MDB? "Armen Stein" wrote in message ... On Tue, 2 Jun 2009 11:21:57 -0700 (PDT), mcnews wrote: has anyone had this problem? i have a make table query that selects several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. I don't know why this problem is happening, but I recommend not using MakeTable anyway. It's actually more reliable to have a permanent table, then delete all the records and reload it with an Append query instead. Then you get a consistent structure with less opportunity for Access to misinterpret the field types needed. If you try it with an Append query into an existing table, does the problem still occur? Armen Stein Microsoft Access MVP www.JStreetTech.com
|
|
#7
June 5th, 2009, 03:35 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
Allen Browne lists some of the problems with Name AutoCorrect at
http://www.allenbrowne.com/bug-03.html -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Michael Courter" wrote in message ... i can't see why name autocorrect would be a bad thing ...? "Gina Whipp" wrote in message ... mcnews, You never stated how big your database is or what version. I would also make sure Name AutoCorrect is off, just because... I also wonder why you don't create a query and use those results? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mcnews" wrote in message ... has anyone had this problem? i have a make table query that selects several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. tia, mcnewsxp
|
|
#8
June 5th, 2009, 04:01 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
thanks.
i unchecked, but no joy on this round. "Douglas J. Steele" wrote in message ... Allen Browne lists some of the problems with Name AutoCorrect at http://www.allenbrowne.com/bug-03.html -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Michael Courter" wrote in message ... i can't see why name autocorrect would be a bad thing ...? "Gina Whipp" wrote in message ... mcnews, You never stated how big your database is or what version. I would also make sure Name AutoCorrect is off, just because... I also wonder why you don't create a query and use those results? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mcnews" wrote in message ... has anyone had this problem? i have a make table query that selects several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. tia, mcnewsxp
|
|
#9
June 5th, 2009, 09:23 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
Still curious... how big is your database and when was the last time you
ran Compact and Repair? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Michael Courter" wrote in message ... thanks. i unchecked, but no joy on this round. "Douglas J. Steele" wrote in message ... Allen Browne lists some of the problems with Name AutoCorrect at http://www.allenbrowne.com/bug-03.html -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Michael Courter" wrote in message ... i can't see why name autocorrect would be a bad thing ...? "Gina Whipp" wrote in message ... mcnews, You never stated how big your database is or what version. I would also make sure Name AutoCorrect is off, just because... I also wonder why you don't create a query and use those results? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mcnews" wrote in message ... has anyone had this problem? i have a make table query that selects several fields including a hyperlink field into a new table. this has been working for a couple of years. recently the new table's hyperlink fields all contain junk characters. even the ones that should be empty. tia, mcnewsxp
|
|
#10
June 8th, 2009, 01:21 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
make table query corrupts hyperlink field
On Jun 5, 4:23*pm, "Gina Whipp" wrote:
Still curious... *how big is your database and when was the last time you ran Compact and Repair? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Michael Courter" wrote in message ... thanks. i unchecked, but no joy on this round. "Douglas J. Steele" wrote in message ... Allen Browne lists some of the problems with Name AutoCorrect at http://www.allenbrowne.com/bug-03.html -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Michael Courter" wrote in message ... i can't see why name autocorrect would be a bad thing ...? "Gina Whipp" wrote in message .. . mcnews, You never stated how big your database is or what version. *I would also make sure Name AutoCorrect is off, just because... I also wonder why you don't create a query and use those results? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "mcnews" wrote in message .... has anyone had this problem? *i have a make table query that selects several fields including a hyperlink field into a new table. *this has been working for a couple of years. *recently the new table's hyperlink fields all contain junk characters. *even the ones that should be empty. tia, mcnewsxp we compact and repair regularly. the make table query involves one table with around 8100 rows and another with around 11000. i created a test mdb that contains the 2 tables and the make table query. i also imported the two tables from a previous version in which the make table query was working properly. i discovered that the corruption only occurs when one of the new tables is involved. and if i delete rows from that table and make it contain the same number of rows as the older one no corruption occurs. so there's some bad data somewhere or something. i am going to experiment with removing fewer and fewer rows to see where the breaking point is.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
