Merging Two Sample Databases
Mar 15, 2008
Sorry if this is in the wrong place - I am very new to this site
I have asked this on another forum but have had no replies - hoping someone here can help
I am using Acess 2000 and I am not that good at it
Is there any way to merge two of the sample databases which comes with
Access together - I would like to have the Inventory Control and the Order
Entry databases as one database - can this be done? There is no data in the databases yet
Hope someone can help and thanks for looking
View Replies
ADVERTISEMENT
Jun 20, 2007
.
Alexei White (http://www.linkedin.com/in/alexeiwhite) Has a very kindly posted some excellent sample data which you can use in your development. The sample data is downloadable from his blog here: (http://blogs.nitobi.com/alexei/?m=200706)
The data is available in the following formats:
CSV
MS Access 2000
SQL Syntax file
XML (http://blogs.nitobi.com/alexei/?m=200706)
Alexei White is also on LinkedIn--- Profile Here. (http://www.linkedin.com/in/alexeiwhite)
Thank you Alexei for making this resource available!
Cheers Tony...
MS Access Hints and Tips Club (http://www.ecademy.com/module.php?mod=club&op=join&c=3970)
View 1 Replies
View Related
Jun 24, 2006
Dear Friends,
I am a naive in access and really looking for some mentor to help me learn quickly
I am presently going through a book Call "Microsoft Access 2003 InsideOut" I dont have the cd so thus missing the sample databses discussedin the book.
If anyone can provide me with this data base then it would be a great help
Thanks
Sunny
View 2 Replies
View Related
Aug 24, 2005
I am new to Acess, I am trying to merge 2 Access DBs and am not sure of the steps to accomplish this, if it can be accomplished and/or are there any tools to reach the same goal.
View 5 Replies
View Related
Oct 25, 2007
Hello-
We are using an Access database for off-site data entry. We therefore have one master database we keep in the office and then a "template" version -which is identical to the master version except no records - we bring to each site, do the data entry and then merge that data back into the Master database.
Can anyone help suggest ways to make the data merging process more efficient. The database has approx 12 tables, so I dont' want to create an append query for each one every time. Is there a way to just "merge" two identical databases??
THANKS
View 7 Replies
View Related
Oct 12, 2006
Ok, this is only a very general question, but I'm hoping somebody here can give me some general advice.
Basically, I have three separate database which I've written for my company. They were all written at different times, hence the fact there are three and not one that does three things. The first is used to raise, edit, delete, and track RMA records for returned merchandise. The second is used to raise, edit, and track Training data for people who have undergone my training course. The third is my main database that contains all of my clients' details, plus a log of all calls taken from them. This is the largest and most complex of the databases and has some fairly advanced relationships setup to enabled hundreds of call logs to be linked to a single record of necessary.
Now all three databases have been written using the same kind of structure. They all use popup modal forms to prevent malicious/accidental damage to the database by the staff who use them. They are all locked down and Access cannot be broken into whilst they are running. they all also have their own primary keys.
All these databases work just fine, but I'm now a little tired of each staff member having three shortcuts on their desktops, depending on which database they need to use. what I'd really like to do is somehow merge all three of these databases into one single database, and alter the switchboard accordingly to allow users to access any of the three parts of it.
The problems - as I see them - are: (a) that my main database uses a lot of relationship links to maintain certain records, whilst the other two use none, and, (b) that each database, having been written separately, has records with their own ID keys and autonumbers.
I did toy with the idea of having some kind of function on my main switchboard that would allow me to close the current database being used and open another, all without closing Access, but I haven't been too successful in my tests...
...so, my question is, does anybody have any bright ideas as to how I can go about merging these three, or, at very least, centralising access to all three?
View 3 Replies
View Related
Jul 22, 2006
Hi,
I've asked this on a few other websites with limited or no success.
this is from one db. this table originally had about 20-30 different fields,
WarehouseNum ItemNum load_date Shipped
101 31 6/26/2006 200
101 31 6/27/2006 180
101 338 6/26/2006 162
101 338 6/27/2006 357
this table is from another db. Notice how WarehouseNum is '9' instead of '1' and itemNum is '000'. This is just one of many impediments I face. As well, none of the table fields are the same, I changed them here to make it easier to work with.
SupplierNum ItemNum WarehouseNum PlannedDelDate DeliveredQty
869747 00031 901 6/26/2006 250
869747 00031 901 6/27/2006 300
869747 00338 901 6/26/2006 490
869747 00338 901 6/27/2006 490
The goal here is to query the two simultaneously, perhaps with linked tables, type in an ItemNum using a parameter and know for instance that on the 26th, we received 250 item31 and shipped 200 for a remaining balance of 50. The 50 is what I'm after. Basically, my company uses one program for sales and another for purchasing and absolutely nothing for inventory management. I started with this company about 3 weeks ago and unless i can implement some kind of temporary solution, it will drive me insane.
Advice? Best approach? As well, this db will use data on two different servers
Thanks for the help.
As well, my access experience is limited and our company I.T. is seriously backlogged, besides which, I would like to learn how to do this myself.
Thanks again
View 1 Replies
View Related
Sep 6, 2012
Friends own a book shoppe. They have closed up both their retail stores and are working on line only. A long time ago they bought a PC based program to keep their inventory and manage their on line sales. The program is called BookTrakker and still on sale today.
I called them to ask for assistance merging the access databases for but stores with their Master database. The owner sads they dont offer any assistance in combining databases.
I have had no trouble using the append command to combine the 40 odd tables in the database except for one small table called Keywords. This table only has 5 fields but the sallest has over 7,000 rows. This is one of the more important tables because Keywords are used by the search engines on-line for potential buyers find their interests.
The error message I get from Access is "Microsoft Outlook Access set 0 field(s) to nulll due to a type conversation failure, and it didn't add (number of rows in table) to the table due to key violations, 0 records due to lock violations, and 0 records due to validation rule violations"
The table structure is identical. The only difference is the data in the rows.
I tried removing both Primary Keys for both the tables (in and out). Nothing, same error message.
Next I tried appending the tables without the entire Keyword_id (Primary Key) field. Nothing same error message.
View 1 Replies
View Related
Jun 12, 2013
Currently am trying to get together two separate Access Databases into one, which is the way it was always supposed to be.
Basically, this person accidentally created a duplicate of the database in question, and has been updating both independently at different times, meaning that whilst a lot of the database information is duplicate, there are some instances where each separate database copy has unique information on both existing contacts, and new unique contacts.
The database itself is about schools, and has tables concerning information such as calls made, contact details, school details, etc etc. Obviously all of this needs putting back together into one set of tables in one file.
I've been messing around with append and import functions, but am having issues with duplicate ID fields with append queries, and a general lack of direction on the best way to go about fixing this problem, if its even possible.
Here's an example of what i've been trying to do:
INSERT INTO Contacts ( ContactID, ContactTitle, Name, Surname, JobTitle, TelephoneSTD, Telephone, FaxSTD, Fax, Locale, SubjectKeyword, SchoolID, Reply received] )
SELECT [1Contacts].*, [1Contacts].ContactID, [1Contacts].ContactTitle, [1Contacts].Name, [1Contacts].Surname, [1Contacts].JobTitle, [1Contacts].TelephoneSTD, [1Contacts].Telephone, [1Contacts].FaxSTD, [1Contacts].Fax, [1Contacts].Locale, [1Contacts].SubjectKeyword, [1Contacts].SchoolID, [1Contacts].[Reply received]
FROM 1Contacts;
View 9 Replies
View Related
Aug 22, 2013
I'm merging a few databases together. They're fairly simple on their own but I'd like them as one big database. I read that I should import each access database into a new, blank one.
It all works fine, but none of the saved imports and exports come with them. Unfortunately, these imports and exports are relied upon quite heavily.
Is there a way to bring saved imports over from other databases, or will I have to rebuild each one?
View 3 Replies
View Related
Nov 4, 2013
I've currently come across the issue where an end user copied the database locally to their computer and has been using it for months and months. After fixing an issue in the database on the server and then finding that someone still had a database bug is how I figured this out. Anyway, what would be the best way for me to merge the table 1 from the database she was using to table 1 in the database on the server? Is there a way to export a table so I can then import the data? Like I said, the databases are identical other then the data.
View 3 Replies
View Related
Sep 19, 2005
hi,
do you know where can I get a file sample of ms access database with the following features:
- entry of persons,
- entry of projects,
- calender of projects,
- payement for their work,
- print-out of vouchers,
- on-line access for persons to DB (with password).
i've looked around the internet and couldn't find anything. I would love to have this just as an example, to build my own on-this-sample-driven database.
i've done something in PHP but since VB and PHP are not similar, i really would love to have an example.
thank you for your help
View 3 Replies
View Related
Oct 27, 2005
Hi all,
I am on my way to building my first relational DB. Is anyone able to look at the attached sample and tell me if I am on the right track?
The DB is being desined to record Repair information carried out on a machine. (TblRepair)
The DB will also eventually record refurbished machines (TblRefurb) and also many other situations like stock control, etc.(yet to be designed). Before I go on I just want to check:
> Is this roughly correct so far?
> If I create a new record in the existing form, why can I not enter both UnitID and EmployeeID? Relationship conflict?
> Should I be building forms on a query? (I think the answer is Yes, just need confirmation).
> Is it because of a problem with the query I cannot enter details correctly? (as per the above question).
Any pointers would be very welcome. PS Sorry its v.old A97!
View 2 Replies
View Related
Oct 26, 2006
Hi,
Does anyone know where I can get a sample database that shows me a order form that rmoves items from stock as they are being brought?
Kind Regards
David
View 2 Replies
View Related
Jun 27, 2007
How do I link the progress as shown on screen - with that actual progress that its is supposed to represent?
Ta
View 5 Replies
View Related
Nov 15, 2007
I've read-up on getting random records, but I need a little help.
I have a table with 200,000 SSN records. Fields: SSN, Plan Number
There are about 100 distinct plans.
How can I select a sample (random) SSN for each plan?:confused:
View 6 Replies
View Related
Jun 6, 2005
Can someone post a copy of a sample mdw file so that I may observe the design of the database? I am very new to the concept of db security and would like to take a look at how the design is constructed. Thanks!
View 11 Replies
View Related
Jul 15, 2005
I checked the sample DB section, but could not find what I am looking for: a anonymous customer satisfaction database. Just a shell I can build upon. Does anyone here have anything similar I might be able to use?
View 1 Replies
View Related
Jan 18, 2006
I'm looking for a way to generate a random list of 25 case numbers from a table which contains 500case numbers. Can someone tell me how to do this.
View 1 Replies
View Related
Feb 1, 2006
hi
i want to develop application in access like inventroy control.But i have no knowlege how to do it.Please guide me.I want some sample or frame to develop
application in acess.Thanks in advance.
View 3 Replies
View Related
Feb 1, 2006
hi
i want to develop application in access like inventroy control.But i have no knowlege how to do it.Please guide me.I want some sample or frame to develop
application in acess.Thanks in advance.
View 4 Replies
View Related
Sep 7, 2006
I am trying to create an attendance application for my group of 6people, does anyone have or know where i can find any to look at. I don't even know where to begin.
Daily in and out. Keeping tabs of our vacation days/sick days.
I just need to know where to begin, or need a sample for ideas in creating this. I have looked high and low. Please show me/tell me if you have any or how you did it, if you have done it before. Thanks friends!
I posted this here but didn't get any response.
http://access-programmers.co.uk/forums/showthread.php?t=114099
View 6 Replies
View Related
Nov 6, 2006
Hello,
Does anyone know where i can get a copy of the check writer sample database for ms access 2000? thank you.
View 6 Replies
View Related
Aug 10, 2007
In the Northwind DB, there is a query of the "Ten Most Expensive Products"
After looking at it, I can't figure out where or how it knows to only pull the 10 highest price products. It's probably right in front of my nose...but it's making me crazy!
Thanks for any replies...
View 4 Replies
View Related
Sep 7, 2006
I am trying to create an attendance application for my group of 6people, does anyone have or know where i can find any to look at. I don't even know where to begin.
Daily in and out. Keeping tabs of our vacation days/sick days.
I just need to know where to begin, or need a sample for ideas in creating this. I have looked high and low. Please show me/tell me if you have any or how you did it, if you have done it before. Thanks friends!
View 1 Replies
View Related
Jan 5, 2007
Hi folks,
I've got a questionnaire which has about 80 fields in 5 sections. all sections are linked to a person Id - which is the unique identifier.
I'm thinking that a tab form is the way to go in putting this form in Access in order to facilitate data entry. Is this the best way or is there another way to accomplish this task?
Does anyone have a sample form that I can modify to meet my needs?
Thanks
Will.
View 11 Replies
View Related
