Database Saved Location フォローする

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 コメント

0
Avatar
Shotaro Ito
コメントアクション 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
コメントアクション 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
コメントアクション 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.

サインインしてコメントを残してください。