Splitting a Database

[MatMac]

Hi. I would like to split my database which is used by various people on a shared drive.

Is it possible to specify a relative path to the linked tables in the back end?

Otherwise, if people access the shared drive via different drive letters, it fails.

Also, I like to keep a copy of the database myself. With absolute paths to the back end tables, I can't simply copy both sections from one place to another - as the links fail.

Thanks.

 

[gemma-the-husky]

you can probably specify an absolute path, instead of a mapped drive

\\server1\mydrive etc


alternatively can't you use a standard drive mapping?

 

[MatMac]

Hi - thanks for the reply.

Different people map to different drives, and the order in which they do so dictates the drive letter for the drive on which my database sits.

What I really want to do is specify a relative path, e.g.

.\Data\Mydatabase_backend.MDB

That way, the back end can always be found in relation to the mapped drive on which each user opens the front end. Plus I can take a copy of both back and front ends to my local machine, and it will still work.

If is isn't possible to specify a relative path, there must be a good reason. Perhaps someone knows why?

Mat.

 

[jkl0]

In Explorer or My Computer if you look at the properties for the mapped drive, it will show you the server name. Then you can use it in your path instead of the drive letter (as noted above by Gemma-the-Husky).

 

[MatMac]

OK - thanks - got that.

I would still like to specify a relative path as above, so I can copy both parts to a local machine for testing, without having to changed table links.

So... my original question remains...

Can I? If not - why not?

M.

 

[jkl0]

A relative path will not work because access does not see the starting folder of your path the same way that you see it.

For example if you pull up the linked table manager, the browser will start in "My Documents" or maybe "Desktop", and that is where it will want to start at in its relative path. That is way when you are refering to a location in code (or in the linked table manager) you use absolute paths.

I hope this explains it better?

 

[MatMac]

Sure does - thanks.