Location of backend database

[klar]

Dear Access experts,

I want to split my database into backend and frontend databases. I understand that the backend database needs to be placed in a shared location. I would like to know whether there are any restriction on the type of storage location for the backend database. Must it be on a shared network location in a Windows environment? Can it be placed on some FTP server?

Thank you very much for your help.

 

[Mr. B]

The backend file must be in a location where each user has read/write capability. This is normally in a Windows enviornment and a shared network drive. The network can be on a server or in a peer-to-peer network environment.

 

[Simon_MT]

You should try and get the database as high up the directory share as possbile S:\Data.mdb or accdb rather than in any subdirectory. The size of volume of the share is on should be small rather than large. I can't remember why the later is important.

Simon

 

[Lightwave]

Simon I hadn't heard of that before - why is it important to get it as high up the directory share as possible?

 

[Simon_MT]

This may go back years but it was a good idea to have the database at top of any structure and of course persistency was also important - having a table always open at the backend from the front end.

Simon

 

[Pat Hartman]

The position in the directory tree seems to impact speed. The lower it is, the slower it is.