[CTS] Re: microsoft access

  • From: John Durham <john.modec@xxxxxxxxxx>
  • To: computertalkshop@xxxxxxxxxxxxx
  • Date: Fri, 20 Sep 2002 14:36:45 +1200

Possibly access has the data but needs to know how to index it. I mean
it needs a primary key. To set one up, open Access and select the
database you imported. Under the Tables tab, highlight it and click the
Design button. You should see a list of the fields in the database table
you selected. Give them names if required, then choose one to be the
index field for your table (everything will be ordered according to
this  field value). Right click it and click on Primary Key.

That may make it more acceptable to Access and will help display it in
the desired order.

brandy galloway wrote:
> 
> Hey everyone look I am taking a class with Microsoft Access and in the
> assignment that said take a file and use the imoport wizard to load
> the file
> into the database well when I did that it said index not found what
> could be
> the problem and what can I do
> 
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
> 
> ---------------------------------------------------------------------------
> -----
> Computer Talk Shop http://www.computertalkshop.com
> Un-subscribe/Vacation, http://szaroconsulting.com/cts/list_options.htm
> 
> List HowTo: http://szaroconsulting.com/cts/faq
> 
> To join Computer Talk Shop's off topic list, please goto:
> http://szaroconsulting.com/cts/other_cts_lists.htm
> 
> ---------------------------------------------------------------------------
> ------

-- 
Regards, John Durham <mailto:modec@xxxxxxxxxxxxxx >
ICQ number 112663246
Fax/Phone 64 4 5286786
Award winning web site at http://modecideas.com?sig
Order my latest e-book at http://modecideas.com/dmaxhits.htm?sig
PC-HELPERS list subscribe/unsub at http://pchelpers.5er.com?sig
Good advice is like good paint- it only works if applied.
---------------------------------------------------------------------------
-----
Computer Talk Shop http://www.computertalkshop.com
Un-subscribe/Vacation, http://szaroconsulting.com/cts/list_options.htm

List HowTo: http://szaroconsulting.com/cts/faq

To join Computer Talk Shop's off topic list, please goto:
http://szaroconsulting.com/cts/other_cts_lists.htm
---------------------------------------------------------------------------
------

Other related posts: