Hi,

I have connected my workbook to an Access database which is on a shared drive at work. When i go to the Data>Connections>Properties>Definition i can see the Connection file and Connection String details.

The Connection File shows as:

I:\Shared Master Folder\Shared Sub Folder\Database Folder\DatabaseFile.mdb

The Connection String Shows as:

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=I:\Shared Master Folder\Shared Sub Folder\Database Folder\DatabaseFile.mdb;Mode=Share Deny Write;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False

I want to put this report on the shared drive so others can use it, however, i cannot guarantee that every user will have this specific drive mapped to I:\\

I would prefer to use the full network address so people don't get errors which is:

\\uk.mycompany.com\data\Group\Division\Department\Shared Master Folder\Shared Sub Folder\Database Folder\DatabaseFile.mdb

How do i go about this?

Thanks

J