Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

ADO/Access problems

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
vmorales
Asked:
vmorales
  • 6
  • 3
1 Solution
 
MasseyMCommented:
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
 
vmoralesAuthor Commented:
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
 
MasseyMCommented:
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
vmoralesAuthor Commented:
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
 
MasseyMCommented:
No worries :) I will take a look and let you know...
0
 
MasseyMCommented:
Files were sent to Derek Liddy.

Basically, the use of the proper Cursor Type was needed when opening the connection.
0
 
MasseyMCommented:
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
 
MasseyMCommented:
I have still found no way to update multiple tables with one query.  It must be done table by table.
0
 
vmoralesAuthor Commented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now