TRansfer rows from one table to another?

[jhowley58]

Hi,

Problem is that I can create a data access page from a certain table but the Data access page remains read only.
It's a table of 30 fields, a lot of which are foreign keys pointing to fields in other tables. The primary key is autonumber. There are in excess of 10,000 rows in the table.

I can create a table with the same field definitions etc, and then that table is editable when linked to a data access page. So there must be some flaw in the original table - which I cannot find. So what I want to do is to transfer the rows from the original table to the new table. What is the best way of doing this? (Am I missing something vital here?)

Thanks,

JohnH

 

[KenReay]

Hi

Is the DAP based directly on the table, or on a query containing the table?, it may be something in the query which makes it not updateable

To transfer the data from the table an isnert query should do it, using an INSERT INTO .. SELECT : somthnga along the lines of

INSERT INTO NewTable SELECT ... FROM OldTable

see help for syntax



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[jhowley58]

Thanks Ken,

Yes, I can do that. I just wondered if there was a cut and paste way of doing it. Yes, the DAP is based directly on the table. I select the table and then >Insert >data access page. Seems too simple to go wrong - very famous last words. )

This was supposed to be a simple 'test the water' stage before I got stuck into ASP and stuff.

Cheers mate,

John