Results 1 to 2 of 2
  1. #1
    Exadd is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2012
    Posts
    12

    File interface from diffrent source to acess database

    We having this Human resource system that the company will be using however, the current payroll application will still be used as normal but the update will not be done on the same application.At the moment the current set up is that there a three database linked together that makes up the payroll application but for now one of this database will not be pupolated with data as it will now come from another source all together via extraction or file interface which is the new HR software.

    The only problem I'm facing is some of those fields that i will need to transfer over to suit the current set up of the payroll application is not included on that new software file extract and i dont know where to start or what to do because abviously the file interface should consists of this mandatory field.Without seeing the relationship of what I'm talking about do you think its worth continuing this project as those wanted field are not included?And how can we go without these mandatory field?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    What are the mandatory fields. If you have some common field that identifies individual people (for instance social security number) you should be able to link it as long as the SSN is available in both systems.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database interface
    By asidicman in forum Access
    Replies: 7
    Last Post: 12-12-2012, 02:35 AM
  2. Unable to open the database in Acess 2007
    By Bhat59 in forum Access
    Replies: 1
    Last Post: 08-09-2012, 07:38 PM
  3. Sending emails from Acess Database
    By Lirizarry in forum Access
    Replies: 3
    Last Post: 01-26-2012, 10:04 PM
  4. Linking an Access database to a web interface
    By Yesideez in forum Import/Export Data
    Replies: 1
    Last Post: 06-27-2011, 10:17 AM
  5. Replies: 0
    Last Post: 07-07-2010, 12:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums