Access 2003: Duplicate Data into Different Table

[lawson]

In access 2003, how do I repeat the same data in different tables without typing it out again. That in another table with different name.

[NeoPa]

There are various ways, but the most common is probably using a SQL string starting with INSERT INTO.

Welcome to Bytes!

[lawson]

I have designed a website using ASP.NET and also a database using Access 2003 but the problem now is that how do link them so that when somebody fill form on the website and press submit button the data will be added to the database

[lawson]

what are the syntaxes of coding any submit button on the web form using ASP.NET

[NeoPa]

I'm afraid that question takes you a little beyond our scope here in the Access forum. This is an ASP.NET question. We have a forum for that though, so I will move this across there and wish you luck with a resolution :)

[Frinavale]

I haven't actually tried to do this myself (even though I intended to try it a while ago), but you need to use an OleDbConnection to connect to the MS Access database.

Please review the following articles that outline how to use a database:
Database tutorial Part 1
Database tutorial Part 2

Also, keep in mind that the database has to exist in a place where the ASP.NET user account has permissions that are required to use the database (the ASP.NET user account runs under very limited permissions)

-Frinny