Will Accdb files transferred over the network automatically consolidate?RSS

• • Reply
  slkim

  Member

  22 Points

  143 Posts

  Will Accdb files transferred over the network automatically consolidate?

  Dec 24, 2018 02:28 AM|slkim|LINK

  There are two Access files on two computers.

  The first encrypted Access file is transferred over the network to the second Access file on the second computer and integrated.

  Is it possible?

• • Reply
  Ackerly Xu

  Contributor

  2640 Points

  1052 Posts

  Re: Will Accdb files transferred over the network automatically consolidate?

  Dec 25, 2018 01:45 AM|Ackerly Xu|LINK

  Hi slkim,

  It is more like a problem with access database, you could use the build-in wizard to help you import data from another access database.

  Please refer to https://support.office.com/en-us/article/import-or-link-to-data-in-another-access-database-095ab408-89c7-45b3-aac2-58036e45fcf6

  Or you could try to use ado.net to insert all the data from one access file to another.

  https://social.msdn.microsoft.com/Forums/vstudio/en-US/a5cd6037-2f3e-436d-a102-13b98ffaa788/merge-multiple-access-database-into-one-big-database-with-c-code?forum=csharpgeneral

  Best regards,

  Ackerly Xu

  MSDN Community Support 
  Please remember to "Mark as Answer" the responses that resolved your issue.