Database Saved Location Follow

0
Avatar
Legacy Poster

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!

 

3 comments

0
Avatar
Shotaro Ito
Comment actions Permalink

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
Avatar
Legacy Poster
Comment actions Permalink

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
Avatar
Shotaro Ito
Comment actions Permalink

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.

Please sign in to leave a comment.