Buttons not working

[Bob Quintal]

When the DB resides on the network share, the buttons for
create forms and create reports are grey'd out. i can not
create new one at all. Once I move it back to my D:\ drive
though the buttons are no longer grey'd out and I can create
new forms and reports with ease.

verify that you have full rights to the directory on the network
drive, and that the unc of the drive is listed in the trusted
sites list of MSIE.

As far as splitting the DB, I am the only user that access
this DB.

 

[Guest]

I have a DB that currently sits on my computer's D:\ drive. Because of new
business requirements I am being forced to move the DB to a shared network
drive I:\. After I move the file to the I:\ Drive and open the DB, I lost
the ability to create new forms and reports. I moved the file back to my D:\
drive and opened it to see if the file had gotten corrupted. It had not, and
i was able to create new forms and reports.

As long as the file sits on my Hard drive locally I can create new forms and
reports. If i move it to a network drive I lose the ability. I am always
opening the DB from the same computer whether the file sits locally or out on
the network. If anyone has any thoughts as to what might be causing this I
would greatly appreciate the assistance...

 

[Douglas J. Steele]

When you say that you "lost the ability to create new forms and reports", do
you mean that you cannot create new ones, or that you can create them, but
Access won't let you save them once you've created them?

You must have exclusive access to the database in order to save changes.

The proper way to share an Access application is to split it into a
front-end (containing the queries, forms, reports, macros and modules),
linked to a back-end (containing the tables and relationships). Only the
back-end should be stored on the server: each user should have his/her own
copy of the front-end, ideally on his/her hard drive. With this setup,
you'll be able to make changes to your heart's content, and simply give each
user a new copy of the front-end once you're done.

 

[Guest]

When the DB resides on the network share, the buttons for create forms and
create reports are grey'd out. i can not create new one at all. Once I move
it back to my D:\ drive though the buttons are no longer grey'd out and I can
create new forms and reports with ease.

As far as splitting the DB, I am the only user that access this DB.

 

[Guest]

Nelson, Check and see if you can open the database in exclusive mode? Doug
mentioned that and I think he is correct. Since no one else uses the database
you should be able to open it in exclusive mode all the time. I moved a
database from my computer to a network drive and it works for me. But I am
always in Exclusive mode.

 

[Pat Hartman \(MVP\)]

Access is very sensitive to disk space. Make sure that the network drive
has free space equal to at least twice the size of the .mdb. You also need
sufficient network permissions to allow Access to create the .ldb file on
your behalf.

You can easily identify if the issue is the .ldb file.
1. Open the database on the network share
2. Open a Windows Explorer window and scroll to the directory that contains
your .mdb file. If there is no .ldb file in that folder, that is your
problem. Access requires the .ldb file to keep track of database changes.