Access (office 2003) will not let me save any designs to reports / forms

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi, is there a quick fix around this.

I have a database which I have on a Windows 2003 server
I created an admin user / workgroup in it by what I feel is now the
wrong thing to do.
As server user's permissions will control who gets access to what on
the database.

Now even if I log into server as administrator, I cannot design or
change any reports / forms, I can change them, just that Acess tells
me off saying I do not have exclusive access. (database is not open by
anyone else while I'm doing this)
Same thing happens if I put database on my xp system.

What should I be looking for or what should I do to fix this?

Thanks in advance

Phil

phillip(nospam)@pmassociates.com.au
remove (nospam)
 
Hi, Phil.
I cannot design or
change any reports / forms, I can change them, just that Acess tells
me off saying I do not have exclusive access. (database is not open by
anyone else while I'm doing this)
Click to expand...

Did you name the workgroup information file with the same base name as the
database file and place it in the same directory? (For example,
Employees.MDB and Employees.MDW.) Both files will open their own locking
database (*.LDB) files if they are located in different directories. If
located in the same directory, there will be two users listed in the same
*.LDB file, indicating that the database is shared, not exclusive.

If this is the case, either rename the workgroup information file (perhaps
Secured.MDW) or place it in a different directory.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
HI, thanks for reply and info.
No I didn't name them the same, now this gives me something to work
on.

Cheers
Phil
 
Hi, Phil.

Do you have VBA code that opens another database file in the default
workspace? This will cause your database to migrate to shared mode (even if
you opened it exclusively), preventing the temporary promotion to exclusive
mode necessary for saving major changes.

You may want to use Microsoft's LDB Viewer to examine at what point the
database becomes shared (i.e., at open, after a certain form is opened,
after a certain command button is clicked, et cetera). Most likely the
"other user" is you, so this tool will confirm the current user name and the
computer name of all users connected to the database file. Please see the
following Web page for links to the LDB Viewer and other free diagnostic
tools in the "Free Microsoft Access Troubleshooting Tools" section:

http://www.Access.QBuilt.com/html/links.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Thanks

As I can not see any MDW file for my database.
Unless windows puts it into another directory by itself.
I'll have a read up on the page you suggest and let you know how I go.
Thanks again
Phil
 
From running the LBV viewing I think I can see what has happened, late
last year I had to do a fresh installation of my xp system and I name
the HD or computer name different to what it was, preior to this I
could edit and saved reports etc on database.

We also installed a new HD and did a fresh installation of Windows
2003 sbs on our server and called that a new name.

LBV says clientone, which is me on XP system is the only user

Is there a work around this or would I be better to export all objects
into a new database, although it is not letting me do this either.

thanks
Phil
 
Hi, Phil.
As I can not see any MDW file for my database.
Unless windows puts it into another directory by itself.
Click to expand...

If you have not secured the database, then you need not worry about it. You
would be joined to the default workgroup file, which by default in Windows
XP is located in the "C:\Documents and Settings\<WindowsUserID>\Application
Data\Microsoft\Access" directory.

If you have secured the database, then it would be a good idea to know the
name of the secured workgroup information file and its location. If you
open the database via a shortcut, then the target should contain the
location and name of the secured workgroup. Otherwise, you could use the
Workgroup Administrator to find the location and name of the secured
workgroup, because you would be joined to it (unless you rejoined another
workgroup manually). If you still couldn't find it, then you'd have to
search the computer for all *.MDW files and then experiment to see which one
allowed you to open the secured database file. If you couldn't find a
secured *.MDW on your computer, then it might be located on the network.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Hi, Phil.
From running the LBV viewing I think I can see what has happened, late
last year I had to do a fresh installation of my xp system and I name
the HD or computer name different to what it was, preior to this I
could edit and saved reports etc on database.
Click to expand...

The name of the computer doesn't matter if your computer can connect to the
server and the directory where the database is located. That means it's on
the same domain or on a connected domain. Look at the Windows security
permissions for the directory where the database is located. Do you have
"Full Control" permissions? You should. Do you also have "Full Control"
permissions on the database file itself? You should.
Is there a work around this or would I be better to export all objects
into a new database, although it is not letting me do this either.
Click to expand...

If it's a secured database, then you would need to log into Access as a user
that is a member of the Admins group in order to export objects. If it's
not a secured database, then what is the error message?

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Hi, Phil.


The name of the computer doesn't matter if your computer can connect to the
server and the directory where the database is located. That means it's on
the same domain or on a connected domain. Look at the Windows security
permissions for the directory where the database is located. Do you have
"Full Control" permissions? You should. Do you also have "Full Control"
permissions on the database file itself? You should.


If it's a secured database, then you would need to log into Access as a user
that is a member of the Admins group in order to export objects. If it's
not a secured database, then what is the error message?

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Click to expand...
I did not think to look under win xp user local settings to see what
it says there.
I did do a print off in a image file of the admin and user groups of
the DB, would it help if I sent it to you?

Let me know and in the meantime I'll check under winxp users local etc

Cheers
Phil
 
Back
Top