Database Saved Location

Legacy Poster

• January 25, 2016 22:37

Hi there, 

I have a bartender label file, and a Microsoft Access Database saved in a folder called "Shipping carton label". The "Shipping Carton Label" folder is saved on my desktop. Everything works fine while i'm linking the database to the bartender file and creating the label file. 

 

However, when I move the "Shipping Carton Label" folder to a different drive, the database link breaks. It is still looking for the Access Database that's saved on my desktop. How do I stop it from doing this? I'd like it to look in the same folder as the label file, no matter where the two files are, as long as they're together in the same folder.

 

Thanks!

 

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 26, 2016 05:13

  You can use relative path for Access DB, Excel DB, Text DB etc - such as just ".\shipping.accdb" instead of "C:\Users\<username>\Desktop\Temp\shipping.accdb".

   

  .\ means current folder - the same folder as BarTender document (*.btw) file.

  ..\ means parent folder

  .\db\ means db folder within the same folder as the BarTender document.

   

  You must save the BarTender document file before using relative path.

  Relative path is applicable to linked pictures too.

   

  Deep explanation is shown in here.

  https://msdn.microsoft.com/ja-jp/library/windows/desktop/aa365247(v=vs.85).aspx#fully_qualified_vs._relative_paths

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 26, 2016 05:16

  You can use relative path for Access DB, Excel DB, Text DB etc - such as just ".\shipping.accdb" instead of "C:\Users\<username>\Desktop\Temp\shipping.accdb".
   
  .\ means current folder - the same folder as BarTender document (*.btw) file.
  ..\ means parent folder
  .\db\ means db folder within the same folder as the BarTender document.
   
  You must save the BarTender document file before using relative path.
  Relative path is applicable to linked pictures too.
   
  Deep explanation is shown in here.
  https://msdn.microsoft.com/ja-jp/library/windows/desktop/aa365247(v=vs.85).aspx#fully_qualified_vs._relative_paths

  
  Thank you! That really helps! But I can't figure out where I would type in this path.

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 26, 2016 05:21

  Depends on your version -

  In 2016, File > Database Connection Setup > [Configure Connection] button.

  10.1 or Before, File > Database Connection Setup > Options > Setup > Data source.

  0

Please sign in to leave a comment.