General :: Merge All Data To Identical Central Database

Jan 20, 2015

I have started working on an existing MS access application (Front-end & Back-end) built with VBA. The frontend linked to a back-end access database which contains only tables. Because of the nature of the work involving vehicles. Each user has their own copy of identical databases with their individual data stored in backend.

Right now we just copy each back-end database via ftp and store it as usr_backenddb_date.accdb Back end databases contain around 16 tables with most of them containing a autonumber field as a primary key. Further tables are connected with each other referencing the primary key as a foreign key .

I would like ideally create a function in vba that lets me select the database and merge all the data from that database to a identical central database. For the initial part, I am thinking of combining each individual table in each database and changing the autonumber field with SQL with possibly trying to cascade the change so the refrences remain intact.

Constant Access to one back end db via internet (or server) is not really possible as the users are able to connect to internet (network) only few times a day. There are over 100 backends (for each vehicle) with over 1000 records in each.

View Replies


ADVERTISEMENT

Modules & VBA :: Merge Identical Tables From Different Databases Into One Master Database

Mar 4, 2014

I have database for each location. Every location will update some information in the databases and send it back to me. In those location based databases, information will be stored in one table called "consolidate_input". I will store these databases in one specific directory and then I want to accommodate the data of "consolidate_input" into one master database having the same identical table in the database.

View 1 Replies View Related

General :: Updating From Local Database To Central Database

Sep 12, 2012

Database: Access 2007

I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.

Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.

What is the best way to do this?

View 1 Replies View Related

General :: Merge Two Database Having Same Field Name But Different Data

Sep 27, 2013

I have two db's that I want to merge. they both have the same field names, but different data and some of the have same ID's, How do I merge them?

View 1 Replies View Related

General :: Storing 2 Identical Fields On Same Table In Database?

Nov 5, 2013

I want to be able to store 2 identical fields on the same table in the database. The copy will start off being the same as that input in the original field. 90% of the time the 2 fields will always be identical but the copy may be changed at a later stage. I looked into using the copy as a calculated field but found out these can not be updated. Is there another control I can use or do I have to code the population of the 2nd field specifically (in AFTER UPDATE EVENT?) myself. The added complication is that the original and copy must be selected from a combo box as all values are held in a separate table.

Also trying to make the second field = to the first field in the design stage of the table using default value

SO if I put default value = [table].[fieldname] I get an error stating could not find field 'table].[fieldname', and yes the opening and closing square brackets are missing from the error.

View 5 Replies View Related

Uploading Forms To Central Database

Jun 14, 2006

Hi there,

I have a problem and wander if anyone knows a solution?

I have a central database that runs on a stand alone machine (soon to run on a server with VPN connection), it has a form that enables us to report faults this works fine however i would like to be able to send the form out to our operators (all over the world) for them to fill in when needed. then what we would like is for them to send it back to usand then for us to upload it to the central database.

is this possible or is there any other option?


Thanx tom

View 1 Replies View Related

Tables :: Two Identical Database - Importing Tables By Linking To Data Source

Dec 3, 2012

I have 2 identical database in terms of structure but it differs in data.

Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.

I have used the "link to datasource method" through importing the tables to have the "updating" function.

However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.

Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)

View 1 Replies View Related

General :: Large Data Entry - Access Mail Merge

Sep 10, 2013

I have created a rather large data entry form for one of our departments which will be used to run a mail merge document. The merge is run off of a query of the form, rather than the tables themselves...I think that is what I've read is the right thing to do?

Anyways, most of it is working great so far but I've run into an issue where a few of the form fields are combo boxes. In access and in the query the data looks correct, but when you look at it in word (in edit recipient list) and after the merge, it will have a file path name instead.

So a combo box that has "Medical Plans and Visual Plans" in that field in the query, comes over saying "c:Users
ameAppData

Ex: New Hires are provided information about Medical Plans and Visual Plans.
Ex: New Hires are provided information about MeC:UsersbrooksAppData

It always shows the first two letters before putting the filepath name in there.

I have tried doing it multiple ways...a lookup to another table, lookup right in the field itself....get the same results.

View 3 Replies View Related

General :: Merge Two Fields From Two Databases That Have Matching Two Data Ranges

Mar 25, 2014

I have two databases (files). Each file has a format like the one below.

File 1:
chr start end
chr1 1000 2000
chr2 3000 4000

File 2:
chr start end
chr1 1500 3000
chr2 3750 4000

I want to be able to merge the two records together if the field chr matches between the two files plus if there is an overlap between the start number and end number from each file. For instance the first record from each file would match because the range from 1000 to 2000 of file 1 has numbers consisting of 500 numbers (1500-2000) that are also present and overlap in file 2 (1500-3000). I possibly cannot use < or > since the ranges from each file will vary to different degrees. Perhaps there is a between function that might work...

View 7 Replies View Related

Queries :: Only Identical Data Listed From Tables And Not All Data

Sep 7, 2013

Attached you will find an example with the problem.

The query is only searching identical data between both tables.

I want it to show results from all users, with all the devices each user has.

What am I doing wrong with the query?

View 4 Replies View Related

Queries :: Joining Data That Is Not Identical

Nov 25, 2014

I have a question regarding making a query with joint data that are not identical, as I'm not sure whether it's possible.

I have to look at certain serum levels at te start of a new medication regimen, and serum levels after 5 years.

I have one database with:

Patient number
Start date medication
Start date medication + 5 years
And one database with:Patient number
Date of blood test
Serum level molecule A
Serum level molecule B

What I want to do is make a query where the patient numbers are joined. The problem is that the "start date of the medication" and the "start date + 5 years" are not identical to the dates of the blood tests. E.g.: I have a patient that started medication on 01/March/2006, but he has had blood tests done every 3 months from 28/November/2003 till now, and not on 01/March/2006.

I would need the results of the blood tests (of molecule A and B) at the start of the medication and after 5 years, but if the test date differs by a day, Access already sees they're not identical.

I would like to have access select a blood test date that is as close to the medication start date as possible, within a time frame of e.g. +3 and -3 months. Is this at all possible?

View 4 Replies View Related

General :: Mail Merge Word File (using Data From Access File)

Mar 11, 2014

I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.

Please download the attached file !

If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.

Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.

Secondly, I click 'Insert Word Field' -> select 'Next Record'.

In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.

View 3 Replies View Related

Bring Data From 3 Identical Backend Strctures Together

Jul 20, 2007

Hello,

I have searched the forum and have found a lot of information however I am not sure just exactly what I am looking for.

Here is my situation.

It is a spilt DB.

I have a database with a form and a subform. The Primary Key in the form is unique to company A ie ID=CompanyA-1, CompanyA-2, and so on. There is a one to many relationship to the subform.

I have three of these databases in use, all identical execpt the Primary Keys. one is CompanyA, the others are CompanyB and CompanyC.

At the end of the month I want all companies, A,B,&C to send me their Backends so I can bring them all together into one database. The master database I want to bring all three backends into has the same Front End as the other three databases.

My question is what is the best way to bring all of the data together in one database so I can use the common front end to view it.

I am assuming that since the PK for each database is different they should all cometogether without much of a problem? If I can figure out how to merge them.

Thanks!

Fen How

View 6 Replies View Related

Modules & VBA :: Archiving Data - Table Structures Are Identical

Jul 26, 2013

I'm trying to create an archiving routine as my database is becoming very large. For about 10 tables I want to shift certain records to an external database which would have the required 10 tables with the same table names and structure.

So far so good. I now want to automate everything using vba. I can see how to use the INSERT INTO statement but I don't want to have to name every field as there are hundreds. I just can't see how to do this.

If the table structures are identical how do I neatly shift a bunch of records from one to the other using code.

View 1 Replies View Related

Queries :: Comparing Data Differences Between Two Identical Access Tables?

Dec 10, 2013

I have two identical Access tables, for example tblDataYesterday and tblDataToday. The data from tblDataToday has updated data changes in it that are different from tblDataYesterday. I have a maximum of 100 fields to review. I want to compare the two tables and display in a query the differences between the data from both tables.

View 1 Replies View Related

Tables :: Merging Table Data Fields If Names Are Identical

Sep 24, 2012

Have 2 tables:

...TableA: 1 indexed field "Name" and many data fields in ~ 1000 records
...TableB: 1 indexed field "Name" and 2 data fields (DataB1 and DataB2) in about
~ 50 records

Tables currently have NO relationship set.

Want to add TableB data fields to TableA if Name are identical.

DataB1 and DataB2 fields are Not currently in TableA but could be added very easily.

Update (or whatever) will be done weekly where all previous data for DataB1 and DataB2 will be cleared from TableA before job is run.

View 1 Replies View Related

Save Attachements To A Central Folder

Dec 26, 2007

Hello,

I have searched and searched for this but I dont seem to find a solution that suits me.

This is the situation. I have a a database wich is used by multiple users through a front-end. The back-end resides on a server.

Is it possible to select an attachement (word, excel, picture, etc) with the front-end and automatically save it to a folder on the back-end?

This way all the attachements are in a central place and NOT in the database.

I know I can easely solve this problem by saving the attachtments to the database itselve but I dont think that attachements belong in a database.

i hope that you guys can help me.

Thanks in advance

View 2 Replies View Related

Offline Database Merge

Sep 11, 2005

Hi i have database which is on a network and gets run of the network is there away of autosaving on the clients machine so it update the one on the network when the network comes back online. Is there a install program as its used by 15 people to work at same time but no database server is on the network

View 1 Replies View Related

Mail Merge Database

Sep 24, 2004

Can some on explain to me what I need to install and how to send a personalized mail merge from Access. I would like to use the names and email addresses from my database to send individual emails to everyone in it. Where do I find the proper add on? Thanks alot. Alex

View 3 Replies View Related

General :: Merging Data From One Database Into Another

Jun 20, 2014

I need to merge data from one DB into another.I have a split database with front end DBcompanyFE and back end DBcompanyBE. BE is on the server so users at company (3 users) can access it with their own FEs.I also have 2 users that are working at some other location (geographically) and they have identical BE of database (DBcompanyBE) and their own FEs.Now, my problem is, that at each location there is different data entered, but on both locations all the data is needed. What would be the easiest and mybe most automated way to merge/combain those data.

View 2 Replies View Related

General :: How To Transfer Data From One Database To Another

Oct 30, 2013

I recently designed a new database according an old database in order to replace it. I found that I have trouble transferring the data from old to new database.

Only transferring data from one table to another

Database A: [table]![customer]
to
Database B: [table]![Client]

Field name on both are different

DatabaseA:
Table Customer:
Name,
PhoneNumber,
e-mail.

DatabaseB:
Table Client:
FullName,
HomePhone,
CellPhone,
E-mail.

How can I transfer from "Database A/table customer" to "Database B/table Client"?

View 3 Replies View Related

General :: Need To Add Data To Read Only Database

May 7, 2015

I have read only access to a database maintained by a vendor. I am using an append query to search for new records in that database every time my database opens through a macro. This adds any new records to my table. I then add additional information to each record in my table. This is newly acquired information, not calculated, and it is different for each record.

My question is can I keep my table up to date with the vendor table without running the append query macro at open every time as my database may remain open for extended periods of time during updating of records.

View 2 Replies View Related

General :: Designing Database Using Existing Data

Oct 25, 2014

I have to design 2 databases base on some data that was given by my instructor but I feel like I'm missing something on both specially the 2nd database. I have attached my work so far as well as the instructions and the existing data..

View 2 Replies View Related

General :: Website To Get Data From MS Access Database?

Jan 10, 2013

Is it possible for a website to pull data from an Access database?

We have all our department's policies in a MS Access database on our server. Some of these policies need to be made available to the public on our website. I'm wondering if there's a way for the website to pull directly from the database rather than having to manually upload the policies to the site every time they change (annually, semi-annually).

View 1 Replies View Related

General :: Achieve Data From One To Many Relationship Database

Mar 10, 2015

I am using Access 2007, I need to achieve some data from my database, what is the best way to do this.

I have a one to many relationship database, so 1 customer could have many orders, how would you achieve this data?

View 1 Replies View Related

General :: Access Based Database / How To Use Data

Apr 26, 2015

I've used MS Access a fair bit in the past but am somewhat lost since moving to 2013Pro.Some years back I was using software to document radio intercepts, this was based on Access but used a program to display and enter the data.That program was lost after upgrading to a new computer (tied to the CPU) .And the company has long since gone out of business.So I am left with the MS Access elements.In the form of a 3mb database that has nothing but a long list of tables to show for itself.Each table opens and has some ID columns with text like this in them 'L096e0dd24757c 1533a7cc1 53e 6ba44 bd' and after has usable data. What I want to do is set up Access so I can use as much of the data as possible.

View 8 Replies View Related







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