Make Table is not updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used this Statement in Access 97 to make table and now after upgrading to
Access 2003 this statement is not working. If I use this as Select query it
works fine but not with Make table... What am I doing wrong? Thanks in
advance.

SELECT DISTINCT dbo_bondfile.adp, dbo_bondfile.desc1 INTO Description
FROM dbo_bondfile;
 
I used this Statement in Access 97 to make table and now after upgrading to
Access 2003 this statement is not working. If I use this as Select query it
works fine but not with Make table... What am I doing wrong? Thanks in
advance.

SELECT DISTINCT dbo_bondfile.adp, dbo_bondfile.desc1 INTO Description
FROM dbo_bondfile;
Click to expand...

It is very likely that Access is balking because Description is a
reserved word (any database object has a Description property). Try
putting it in brackets [Description], or change the target table name,
say to Descriptions.

John W. Vinson[MVP]
 
John Thanks for quick reply,

I have changed the make table name to TEST and it will not end the query. I
had it running for more 15mins and ended up aborting the query. Any other
ideas?

John Vinson said:
I used this Statement in Access 97 to make table and now after upgrading to
Access 2003 this statement is not working. If I use this as Select query it
works fine but not with Make table... What am I doing wrong? Thanks in
advance.

SELECT DISTINCT dbo_bondfile.adp, dbo_bondfile.desc1 INTO Description
FROM dbo_bondfile;
Click to expand...

It is very likely that Access is balking because Description is a
reserved word (any database object has a Description property). Try
putting it in brackets [Description], or change the target table name,
say to Descriptions.

John W. Vinson[MVP]
Click to expand...
 
John Thanks for quick reply,

I have changed the make table name to TEST and it will not end the query. I
had it running for more 15mins and ended up aborting the query. Any other
ideas?
Click to expand...

How big is dbo_bondfile? If you open this as a Select query (rather
than a make-table) and navigate to the last record, does it respond
instantly, promptly, or slowly?

Any MakeTable query will be slow, but fifteen minutes is a bit
unreasonable! You might try creating your local table empty, and
running an Append query instead. Compact your database before and
after doing so!

John W. Vinson[MVP]
 
Back
Top