473,473 Members | 2,145 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Access 2003: Duplicate Data into Different Table

3 New Member
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.
Jul 5 '10 #1
5 1961
NeoPa
32,556 Recognized Expert Moderator MVP
There are various ways, but the most common is probably using a SQL string starting with INSERT INTO.

Welcome to Bytes!
Jul 5 '10 #2
lawson
3 New Member
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
Jul 8 '10 #3
lawson
3 New Member
what are the syntaxes of coding any submit button on the web form using ASP.NET
Jul 8 '10 #4
NeoPa
32,556 Recognized Expert Moderator MVP
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 :)
Jul 8 '10 #5
Frinavale
9,735 Recognized Expert Moderator Expert
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
Jul 12 '10 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: narasingarao | last post by:
Hi to group, I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project period here i have to migrate the MS-Access database table to Oracle data base tables...so, please help me in getting...
0
by: hpi | last post by:
Hi, I have 2 listboxes (and some other stuff) on a form The first listbox has an onclick event which, when fired, adds an item to the second list box and sets the selected item to the last item...
26
by: Dragon | last post by:
I have an Access 2003 .mde sitting on an SQL Server. The tables for the application also sit on the Server. I'm having a problem with ODBC on only one of about 10 machines. All the other machines...
0
by: Wayne | last post by:
Can anyone cast any light on the following. I have a database that I have written in Access 2003 using 2000 file format. Everything was working OK when running it under Access 2003 but when I...
17
by: Jana | last post by:
Howdy! I have an Access 2003 SP1 where data tables reside on a server & each workstation runs the front end locally. All 5 users are on the same version of Access. We've been having problems on...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
3
by: amanda27 | last post by:
Hi there I have an Access 2003 report that has different information for different projects my department is working on. It gives the status of the projects weekly. For each project they have a...
3
by: drkknightbatman | last post by:
Hi, I am pretty new to Access 2003 and SQL. I am trying to have a count show up in a query to show specific barcode prefix data between the first and the last day of the previous month. I want to do...
9
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd...
7
by: Airtech | last post by:
I am building a media management tool and starting it in Access 2003. I have various linked tables, and have sufficient code to loop through my list of linked tables to verify that the data file...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.