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

the new table has 8513 rows and the old has 8380. when i remove 133
records from the new table (first 133 or last 133) no corruption
occurs.

Do you get and Paster Errors table that might help you pin point what in
those rows of data is causing the problem?

--
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
...
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

the new table has 8513 rows and the old has 8380. when i remove 133
records from the new table (first 133 or last 133) no corruption
occurs.

On Jun 8, 3:07*pm, "Gina Whipp" wrote:
Do you get and Paster Errors table that might help you pin point what in
those rows of data is causing the problem?

--
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

...
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

the new table has 8513 rows and the old has 8380. *when i remove 133
records from the new table (first 133 or last 133) no corruption
occurs.

no error message. again, i get no corruption when i remove 133 rows
from the top of the table or bottom of the table so i think i can
assume it's not something in the data that is causing the problem.
the reason for removing 133 rows is i get no corruption when using an
older version of the table that has 8380 rows.

McNews,

I realize the table that you remove the rows from gets no corruption once
you remove the rows HOWEVER since the additional rows are not a problem for
Access (I have brought in over 300,000 rows of data) I must assume that it
is the data. And for that reason I would want to either review the
PasteErrors table OR review the data itself, line by line, to figure out
what is the issue. Of course, you did say that it doesn't matter where you
remove the 133 rows of data from... very odd.

Also, looking back over your postings, I did not notice that you state the
overall size of your database. Using Make Table Queries does cause bloating
which COULD cause the symptoms your seeing.

--
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
...
On Jun 8, 3:07 pm, "Gina Whipp" wrote:
Do you get and Paster Errors table that might help you pin point what in
those rows of data is causing the problem?

--
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

...
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

the new table has 8513 rows and the old has 8380. when i remove 133
records from the new table (first 133 or last 133) no corruption
occurs.

no error message. again, i get no corruption when i remove 133 rows
from the top of the table or bottom of the table so i think i can
assume it's not something in the data that is causing the problem.
the reason for removing 133 rows is i get no corruption when using an
older version of the table that has 8380 rows.

On Jun 9, 10:54*am, "Gina Whipp" wrote:
McNews,

I realize the table that you remove the rows from gets no corruption once
you remove the rows HOWEVER since the additional rows are not a problem for
Access (I have brought in over 300,000 rows of data) I must assume that it
is the data. *And for that reason I would want to either review the
PasteErrors table OR review the data itself, line by line, to figure out
what is the issue. *Of course, you did say that it doesn't matter where you
remove the 133 rows of data from... *very odd.

Also, looking back over your postings, I did not notice that you state the
overall size of your database. *Using Make Table Queries does cause bloating
which COULD cause the symptoms your seeing.

--
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

...
On Jun 8, 3:07 pm, "Gina Whipp" wrote:



Do you get and Paster Errors table that might help you pin point what in
those rows of data is causing the problem?

--
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

....
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

the new table has 8513 rows and the old has 8380. when i remove 133
records from the new table (first 133 or last 133) no corruption
occurs.

no error message. *again, i get no corruption when i remove 133 rows
from the top of the table or bottom of the table so i think i can
assume it's not something in the data that is causing the problem.
the reason for removing 133 rows is i get no corruption when using an
older version of the table that has 8380 rows.

my test mdb that only has the 4 tables i need and a couple of version
of the make table query is 13,220 kb.

Okay I am getting stumped. I just ran a Make Table Query on a table with
13,000+ records and they all went thru just fine. Can you copy/paste the
SQL of your query?

--
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
...
On Jun 9, 10:54 am, "Gina Whipp" wrote:
McNews,

I realize the table that you remove the rows from gets no corruption once
you remove the rows HOWEVER since the additional rows are not a problem
for
Access (I have brought in over 300,000 rows of data) I must assume that it
is the data. And for that reason I would want to either review the
PasteErrors table OR review the data itself, line by line, to figure out
what is the issue. Of course, you did say that it doesn't matter where you
remove the 133 rows of data from... very odd.

Also, looking back over your postings, I did not notice that you state the
overall size of your database. Using Make Table Queries does cause
bloating
which COULD cause the symptoms your seeing.

--
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

...
On Jun 8, 3:07 pm, "Gina Whipp" wrote:



Do you get and Paster Errors table that might help you pin point what in
those rows of data is causing the problem?

--
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

...
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

the new table has 8513 rows and the old has 8380. when i remove 133
records from the new table (first 133 or last 133) no corruption
occurs.

no error message. again, i get no corruption when i remove 133 rows
from the top of the table or bottom of the table so i think i can
assume it's not something in the data that is causing the problem.
the reason for removing 133 rows is i get no corruption when using an
older version of the table that has 8380 rows.

my test mdb that only has the 4 tables i need and a couple of version
of the make table query is 13,220 kb.

Hold on...

'the new table has 8513 rows and the old has 8380. when i remove 133
'records from the new table (first 133 or last 133) no corruption
'occurs.

You said about these two tables, did somehow or something create a
relationship with these to tables?

It' a good idea to check if had any and if it's possible, please show the SQL
string of the make table query here for us to see.

mcnews wrote:
the reason for removing 133 rows is i get no corruption when using an
older version of the table that has 8380 rows.

my test mdb that only has the 4 tables i need and a couple of version
of the make table query is 13,220 kb.

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200906/1