Merging Two Different Access Databases

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 Replies


ADVERTISEMENT

Merging Databases

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

Merging Databases

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

Merging Multiple Databases

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

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 4 Replies View Related

Merging Two Identical Databases?

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

Queries :: Merging Two Separate Databases With Duplicate As Well As Unique Information

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

General :: Merging Databases - Importing Saved Imports And Exports

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

Tables :: Merging Two Like Tables From Two Databases

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

Merging Access Records

Nov 2, 2004

I have 3 Dell laptops with data that was used in registrating participants for a conference (names, address, position title, email, and amount paid). Is there a way to combine the data from each computer to make one database? Please provide step by step instructions?

Mona

View 2 Replies View Related

Merging Access With Word

Mar 8, 2006

I have an Access spreadsheet that I can't get to merge with a word document. It freezes up every time I try and the only message I get is overflow. Does anyone know how to fix this problem?

View 3 Replies View Related

Merging Images From Access To Word

May 26, 2006

I am building a database for my job. I am trying to find a way that I can mail merge an Image that store in Access to a Word document. I tried doing it by creating a field in Access for the picture and its field type was set to OLE Object and I placed the merge field in its appropriate area in Word. When I go to merge it, its comes up with a message that says "Long Integer or Binary Number". If anyone has an idea as to how I can make this happen....please let me know, your help would be greatly appreciated.

Thank you

View 1 Replies View Related

Merging Columns In Access 2000

Jun 23, 2004

I really never use Access but a client gave me a database with a couple thousand records in it. Two columns were "Area Code" and "Home Number". What I have to do is merge those two so that the area code and number appear in a single column. How do I do this?

View 6 Replies View Related

Problem With Access Merging Into Word

Jun 20, 2007

Hello All,
I need some assistance.
First a little background on the database:
The back end is in AQL the front end is in Access.
The main form is called the "Register", here they enter claim information and if they need to create a printed loss they click on a button called "Loss Notice" This brings up another form which is filtered based on the claim number in the Register. Here they fill in additional information. On this form they have the option to print the Loss Notices by clicking on a button that Opens up Microsoft Word and all the fields are mapped to the Word Template where they need to be.

On my computer when I set this up it works great. I test it all the time and works perfectly.
However when the users try to do this from their computer they are getting a pop up box asking for the claim number. The Loss form is filtered and should only pull that claim number.

Why are they getting this pop up box and I am not?

If you need any additional information I will try and give that to you.
Thanks for trying to help!

View 2 Replies View Related

Merging Word Document With Access Query

Feb 7, 2006

Apologies ... but I am quite new to Access. My database contains about 1000 peoples' addresses.

The problem I have is that I need to merge, say, 20 of these addresses into a word document. In the word document I can select records using the "Surname" field but it will not give me the option to select more than 6.
I am sure there must be a way that I can select more than 6: I have tried separating the surnames with a "," or "or" but nothing seems to work!

Help, please!

Thank you,

Emma

View 3 Replies View Related

Merging Access Data Into Word 2003

Aug 29, 2007

Hi,
how do i get the current record form access 2003 to merge the data into word 2003 template that I created.

The code I'm using is :-

Private Sub Command313_Click()
Dim oApp As Object
Dim doc As Object
Dim strDocName As String

Set oApp = CreateObject("Word.Application")
oApp.Visible = True

strDocName = "K:Supported Living ServicesdatabaseDB-Personnel.dot"
Set doc = oApp.Documents.Open(strDocName)


doc.FormFields("Title").Result = Forms!Personal!Title
doc.FormFields("fristname").Result = Forms!Personal!firstname

Set doc = oApp.Documents.Add(strDocName)

End Sub


I'm using 2 fields here but will be adding a lot more once I got it working.


Thanks inadvance

ps (only a novice at access)

View 4 Replies View Related

Modules & VBA :: Merging PDF Docs Using Access 2007

Apr 1, 2015

Any simple code that merges multiple pdf documents that they are willing to share. I don't seem to be able to find anything that works so far.

View 2 Replies View Related

Using Access Databases With Web Sites

Oct 20, 2006

Hi,

I curently have a website that has a registration page on it that uses a simple access database that contains a single table with the same fields on as that of the reg. form. What I want to do, in one way or another, is to make some sort of macro that starts once some datails have been submitted to the database using an SQL statement I made within Frontpage, send an email to the registrant telling them what there customer number etc (autonumber in database) and various other welcoming messages etc.
The SQL statement is along the line of INSERT INTO...

Am I thinking along the right lines with a macro or some code or is the access database literally rendered to a table/number of table and thats it?

Cheers folks

View 5 Replies View Related

Problem With Access Databases

May 5, 2007

Hi,

Recently, i had upgraded my computer with some new hardware, therefore i did a fresh install of win xp sp2.

Now I noticed that after i installed all the usual software including microsoft office 2003, when i am opening a ms access database and i open the first form, most of the fields on the particular form (no matter which form in the database as long as it is the first one) display just a value on most field (i am noticing those fields with text datatype), and i am noticing that the number shown is the same as the autonumber i have for that record. Eventually, closing and re-openining the form will fix the problem. this is happening with all of my access databases, some of which i have been using for ages.

Actually, i have tried running the detect and repair tool from the microsoft access help menu to no avail. I have even tried importing the database objects to a new database but still to no avail. Finally i also tried uninstalling and re-installing microsoft office, and the problem is still persisting.

Any idea what might be going on, and hopefully a resolution to sort out this nightmare?

Thank you very much all for your attention.

View 7 Replies View Related

Queries :: Merging Changing Excel Forecasts Into One Access Table?

Oct 22, 2014

Say you have multiple excel sheets where forecasting is done daily.

For example, sheet one headings: Depot, department, location, 01/09/10, 02/09,10, 03/09/10

and then second sheet is similar but: Depot, department, location, 02/09/10, 03/09/10, 04,09, 10 - as you can see each day the forecast starts a day after and ends one date late (14 days each in the real one)...

How to I join all these forecasts into one table; vertically with each forecast identified by the day it start for analysis later.. rather than doing cross-tabulate which would take ages, I just need to keep adding more excel sheets but the headings change as they are dates...

View 7 Replies View Related

Running Access Against Multiple Databases - DEV/UAT/PRD

Feb 21, 2007

Access 2003

I've inherited an Access Application which has
(1) a number of linked tables that are used to seed the underlying SQL Server database.

This system has been set up and is working in Development. My task is to move it to UAT but with regards to point (1) above I can't see any alternative but to copy the Access Database, create a new System DSN and re-import the External Data from the new DSN. What I'd like to do is use the same Access Database to point towards DEV or UAT or PRD. Is this possible to do this or am I stuck with maintaining 3 different Access Databases ?

I am a developer with many years of experience but my Access knowledge is limited so any pointers would be helpful.

View 5 Replies View Related

Access Databases Won't Open On A Workstation

Feb 22, 2008

I'm having a problem on a workstation that I've always used to create databases in Access. When I open any of my saved .mdb's I get a the error "end query expression" with the table name. The message gives me the option to click OK or Help and Help refers to "<Message> in query expression <expression>. (Error 3075)".

I've copied the .mdb's to another PC with Access installed and they open with no problem and I've removed and reinstalled Access on the problematic PC but still the same problem.


Also, I have a UPS Worldship shipping application that uses an Access database and when it opens it gives me a Micrsoft Visual C++ runtime error then closes, which may or may not be related.

I get the sense that something is corrupted in either Access or Windows XP but I'm not sure where else to look.

Any ideas?

Thanks,

Stuart

View 2 Replies View Related

Publishing Access Databases In Dreamweaver

Aug 26, 2004

I want to publish my access database on my local pc and was thinking of using something like Dreamweaver to do this. Is this possible? I don't want to put this on the webserver but on my local machine (only a few people will be connecting), and I've read something about a Personal Web Server so this could be done. Does anyone have any ideas / thoughts on the best way to do this? Oh, I want the database / web to be "live" so the tables get updated as they are changed over the web.

View 3 Replies View Related

General :: Communicating Between Different Access Databases

Jul 31, 2014

I have an access db as the backend with the tables. Then multiple front end access dbs that link to the tables (as external sources). The front end dbs are setup with different forms on a per user basis, depending on their role. From my user db I want to be able to request information from another user. I want something in their db to pop-up and request the information.

I was thinking about approaching it using the datamacros. I thought maybe each front end db could have a messages table that the main db and other front ends link to. Then whenever they add data to your specific table it would respond and ask the user for the information. The info would then populate back into the message table where it could be retrieved by the requester.

Example: User A opens A.accdb and has a table called A_tbl. User B opens B.accdb and has a link to A.accdb.A_tbl. User B adds a record to A.accdb.A_tbl with Field1 = "what is your name". User A receives a pop-up with the info from Field1 and responds in a textbox for Field2. User B can then look at A.accdb.A_tbl and see the response as Field2.

Another option I thought of was simply trying to get one db to run a form/macro on another db remotely.

Example: User A opens A.accdb and User B opens B.accdb. User A clicks a button on one of his forms and it opens B.accdb.FORM in the session of User B. User B fills out the form and submits. User A retrieves data from shared tables as normal.

View 2 Replies View Related

Need To Merge Changing Databases Into One On Access

Sep 27, 2012

I have to coordinate a dbase in the US, one in the UK, and one in the KSA. I have multiple documents that may, or may not, be in each of the three dbases. I need to merge all three, and maintain them so that the document additions, as well as any changes associated with that document, (i.e. "revisions"), are updated. Having looked at access and having read through some of the Access forum questions, I understand that it can do that, but after having identified the information from the dbases that will go into access, I'm trying to establish a consistant process for maintaining and updating it. Can I export my information from each of the dbases, into an excel spreasheet, (1 for US, 1 for UK, and 1 for SA), and have the access dbase search for the document number, compare the data following the document number, and if it's the same ignore it, and if it's different, update it?

I'm trying to muddle through this and get access and excel to do as much of this as possible, as it's a very tedious and time consuming process to manually check each one, one or two times a week.

View 8 Replies View Related

Linking Two Access Databases In Sharepoint

Aug 22, 2012

I currently have two Access Databases (one with the raw 'data' and the other with the queries and reports that turn it into 'information' - the data database links into the other).

For contingency purposes, I now want to move both Databases onto sharepoint in case I have a system failure on my laptop (I don't have a server I can put these on). When I upload these onto Sharepoint the second database still seems to link to the file on my computer..

Is there a way I can get a Database to link into another database that's held on sharepoint?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved