Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Mapping Data Drives

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Mapping Data Drives

Resolved · High Priority · Version 2003

Reply Fri 24 Apr 2009, 16:14Delegate Alex said...

Alex has attended:
Excel Advanced course
Access Advanced course

Mapping Data Drives

In access you can link tables from different databases. However assume that the folder containing the database is a public folder and different users may have it mapped to different drives on their computer. Therefore if I link a table it's path could be L:publicfolder/database/table1 but if someone else goes into the database and has the public drive mapped to a different drive on their computer, then microsoft access won't find it at the above address because their public drive is on the M: drive for example. Therefore the question is whether there is a way to link tables (and generally map things) without referencing to a specific drive?

For upcoming training course dates see: Pricing & availability

Reply Mon 27 Apr 2009, 17:03Trainer Andrew said...

RE: Mapping Data Drives

Hi Alex,

Thank you for your question. Mapped drive letters are convenient for shortening long directory paths but as you have pointed out the letter used may vary depending on the machine being used to connect to the shared resource.

An alternative to a drive letter is to enter the full network path. These often look like:

\\servername\directory\subdirectory\myfile.xls

Check with whoever looks after your network. They should be able to give you the full path to the folder location. Since this path describes the location in full it is independent of any drive mappings the user may have and should work on any machine for a user that has permission to connect to the public drive.

I hope this helps.

Kind regards,
Andrew

Access articles

· Why go on a Microsoft Access Training Course?
· How To Create Navigation Forms In Microsoft Access
· When To Use Access, When To Use Excel
· Insert A Real-Time Clock In An Access Form
· Express Yourself With Microsoft Access

Please browse our web site to find out more about
microsoft.access.courses and other Microsoft training courses.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips