Microsoft Access...need help - GoFuckYourself.com

RightHandMan · 05-31-2004, 04:26 PM

I have 2 Seperate Databases, with Identical columns...
The data they have in common is the CustomerID #. One DB Has just customer Names and ID# the other has ID# and Order# / Date. I want to combine the two databases and all info so i end up with 1 database With ID#, NAME, ORDER#, and DATE. I dont want duplicate entries. How can i accomplish this???

EscortBiz · 05-31-2004, 04:27 PM

just do a query

RightHandMan · 05-31-2004, 04:29 PM

on two seperate databases?

King Porn · 05-31-2004, 04:33 PM

relational database

King Porn · 05-31-2004, 04:35 PM

Or if you really, really don't want two tables, create a script to read in both tables sorted by CustomerID and write all fields to a new table.

Overscore · 05-31-2004, 04:45 PM

There isn't any built-in way to setup constraints between two separate Access databases. Why do you have two, if they're both storing the same data?

RightHandMan · 05-31-2004, 04:47 PM

they both arent storing the same data...they are storing relative data. one has id# and name....the other has id# and invoice#

Overscore · 05-31-2004, 05:04 PM

Quote:

Originally posted by RightHandMan
they both arent storing the same data...they are storing relative data. one has id# and name....the other has id# and invoice#

You'll want to keep all the data in one database then, to keep it relational.

RightHandMan · 05-31-2004, 05:17 PM

Quote:

Originally posted by Overscore
You'll want to keep all the data in one database then, to keep it relational.

thats what im trying to do...but i dont want a relational database, i want one DB

Overscore · 05-31-2004, 05:36 PM

Quote:

Originally posted by RightHandMan
thats what im trying to do...but i dont want a relational database, i want one DB

You do want a relational database. A non-relational database serves little purpose if any... Don't worry about the "relational" terminology for now - just get your data into one database and you can worry about semantics afterwords.

Overscore · 05-31-2004, 05:40 PM

BTW, where is this Access database? Are you using it on a site? Is your site hosted on a Windows box? Or are you using Chilisoft or something?

05-31-2004, 04:26 PM	#1
RightHandMan Confirmed User Join Date: Jul 2003 Location: Ohio Posts: 1,694	Microsoft Access...need help I have 2 Seperate Databases, with Identical columns... The data they have in common is the CustomerID #. One DB Has just customer Names and ID# the other has ID# and Order# / Date. I want to combine the two databases and all info so i end up with 1 database With ID#, NAME, ORDER#, and DATE. I dont want duplicate entries. How can i accomplish this??? __________________

05-31-2004, 04:27 PM	#2
EscortBiz Fuck Checks, CASH only! Join Date: May 2002 Location: New York City Posts: 19,422	just do a query __________________ Spanking, Medical Fetish, Sleeping, Strap-on Anal Lesbians, Girls Fucking Guys, Handjob site REAL HOT, Shemales, Anal and Ass Licking sites 100% Real EXCLUSIVE with amazing retention, ccbill payouts, lots of content FREE FTP HOSTING Promote the largest and oldest member paid escort site, Converts 10 times better then any dating site, CCBill payouts ICQ# 158802076

05-31-2004, 04:29 PM	#3
RightHandMan Confirmed User Join Date: Jul 2003 Location: Ohio Posts: 1,694	on two seperate databases? __________________

05-31-2004, 04:33 PM	#4
King Porn Confirmed User Join Date: Apr 2004 Posts: 245	relational database __________________ Hot Porn Sites --> Submit your website now for free targeted traffic! Topbucks --> Earn $40 per signup or 80% revshare! Sign up now & promote over 60 niches with 300+ quality tours that convert big!

05-31-2004, 04:35 PM	#5
King Porn Confirmed User Join Date: Apr 2004 Posts: 245	Or if you really, really don't want two tables, create a script to read in both tables sorted by CustomerID and write all fields to a new table. __________________ Hot Porn Sites --> Submit your website now for free targeted traffic! Topbucks --> Earn $40 per signup or 80% revshare! Sign up now & promote over 60 niches with 300+ quality tours that convert big!

05-31-2004, 04:45 PM	#6
Overscore Confirmed User Join Date: Aug 2002 Location: Keystone State Posts: 316	There isn't any built-in way to setup constraints between two separate Access databases. Why do you have two, if they're both storing the same data? __________________ ¯Overscore¯

05-31-2004, 04:47 PM	#7
RightHandMan Confirmed User Join Date: Jul 2003 Location: Ohio Posts: 1,694	they both arent storing the same data...they are storing relative data. one has id# and name....the other has id# and invoice# __________________

05-31-2004, 05:40 PM	#11
Overscore Confirmed User Join Date: Aug 2002 Location: Keystone State Posts: 316	BTW, where is this Access database? Are you using it on a site? Is your site hosted on a Windows box? Or are you using Chilisoft or something? __________________ ¯Overscore¯