no ldb file

J

Jase

Hi All

I have a database that is in a read only directory, and when you open the
database it does not create a ldb file for the database. The only ldb file
that is created is the local one in your application data. Which means that
it can be stored in a read only directory.

Unfortunately I have added some forms to this database and this
functionality no longer works, even though the only changes I made to this
database was to modify the content of some forms in it. It is a database
that isn't used by many people and it is stored in a read only directory for
most of the organisation. I was wondering if anyone knows what I need to do
to the database to get it to work from the read only directory again.

Thanks heaps
Jase
 
W

Wayne Morgan

Depending on what you did to it, Access may need to write temporary items to
the file. It is possible to open the file in Read Only mode (from the help
file, "Startup Command-line options": /ro Opens the specified Access
database or Access project for read-only access). It is also possible to use
Access security to give some users read only access to the data.

For sharing a database across a network, it is preferable to split the
database and give each user a front-end with the back-end on the server. The
back-end would be just the tables with the data, everything else would be in
the front-end. For more information on doing this, see these links.

http://www.granite.ab.ca/access/splitapp/index.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;299373

It may be possible, that if you split the database that you could continue
to give some users read-only access to the share, but that isn't the
recommended way to handle it.
 
Top