Solved

ADO/Access problems

Posted on 1999-01-25
9
141 Views
Last Modified: 2013-12-25
Here we go again. I am now about to add info from a form into a single table, but now I need to add info into multiple tables from a form into access. I have defined one-to-many relationship within access, but do not know how to define my sql statement and other variables.
Help, again..
0
Comment
Question by:vmorales
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 10

Expert Comment

by:MasseyM
ID: 1859176
Can you send the info to us?  We need the table "lay-out" and the form fields.  But, here are some ideas:  Usually the easiest way is to update the tables individually.  It takes more code, but to me is easier to follow.  you can also send the database and script files to me and I wil take a look.  masseym@mrqcorp.com
0
 

Author Comment

by:vmorales
ID: 1859177
MasseyM,

I have tried to update individually and I can do that, but because i have relationship setup in access to enforce referential integrity (did i spell that right?) it seems impossible to update individual tables. However, if I can do away with relationships and enforce integrity through scripting I suppose that would work. I am on a huge learning curve, trying to learn HTML/ASP/ADO/VBScript/JavaScript/etc., you get the point, so I am interested in doing it the right way, the efficient way. Thanks
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1859178
I know what you mean :)  As far as I have been able to tell, you cannot update the database and use the referential integrity.  I have also been unsuccessful when trying to update databases that use "lookup forms".  Why, I am not sure and am still looking in to this.  Now, I don;t update my database with a direct SQL statement, but rather through the record set object.  Maybe there is a way to directly post the info via the SQL and maintain the integrity... I will look into it.
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:vmorales
ID: 1859179
MasseyM,
I will still send you the files, may take a day.

P.S.
Remember I am new to this stuff, so don't sent my version of scripting to america's funniest.

thanks
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1859180
No worries :) I will take a look and let you know...
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1859181
Files were sent to Derek Liddy.

Basically, the use of the proper Cursor Type was needed when opening the connection.
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1859182
Please disreagrd the previous answer... (Answer was for a different question).  I am still trying to find info about referential integrity via ASP.  Still no luck.
0
 
LVL 10

Accepted Solution

by:
MasseyM earned 100 total points
ID: 1859183
I have still found no way to update multiple tables with one query.  It must be done table by table.
0
 

Author Comment

by:vmorales
ID: 1859184
Here is your points, I do wish there were better ways to insure the integrity of the data. I guess the Web is still a baby in these matters, although I am very suprised that with the information boom, no way exist to build tables "THE RIGHT WAY" and insure integrity.

Thanks,
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Technology Resume 7 89
Creating a record in a database with static data from MVC to SQL (Entity) 2 50
How to build a web site 17 105
change site header 8 32
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question