Home > Archive > MS Access data conversion > June 2005 > Lock up om compact repair









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Lock up om compact repair
DavidAtCaspian

2005-06-28, 9:24 am

Can't find a better newsgroup name for this.
Trying to move some schedules at a clients site. They are moving to Active
Directory.
On the new active directory machine, if the database is on the local
machine, it goes through compact on close with no problem at all.
If the data is on a server, it creates the new db (DB1 etc), but then just
hangs and I have to end the 'not responding' ACCESS 2000 SP3.
When I then try to open the db1 I get the message no read permission on
MSysAcessObjects.
Does anyone know if this is likely to be an active directory issue, and if
so how to fix it?
Everything works exactly as it should on the old machine that isn't
connected via active directory.

As far as I can tell, the application itself is running just fine, but it
looks as though part of the compact process is either creating, or trying to
read the copied (DB1) database with a different user ID, and this user is
locked out of the servers (but not the local PC)
Thanks

david epsom dot com dot au

2005-06-29, 3:24 am

Check that you have modify permission (as well as read
and write) on new files in the folder.

(david)

"DavidAtCaspian" < DavidAtCaspian@discu
ssions.microsoft.com> wrote in message
news:F45D8003-764B-4C3F-BC45- C988956FFF0E@microso
ft.com...
> Can't find a better newsgroup name for this.
> Trying to move some schedules at a clients site. They are moving to Active
> Directory.
> On the new active directory machine, if the database is on the local
> machine, it goes through compact on close with no problem at all.
> If the data is on a server, it creates the new db (DB1 etc), but then just
> hangs and I have to end the 'not responding' ACCESS 2000 SP3.
> When I then try to open the db1 I get the message no read permission on
> MSysAcessObjects.
> Does anyone know if this is likely to be an active directory issue, and if
> so how to fix it?
> Everything works exactly as it should on the old machine that isn't
> connected via active directory.
>
> As far as I can tell, the application itself is running just fine, but it
> looks as though part of the compact process is either creating, or trying
> to
> read the copied (DB1) database with a different user ID, and this user is
> locked out of the servers (but not the local PC)
> Thanks
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com