After much effort and trialling, we got to the bottom of this problem. When
creating a multi-user system, it requires that all user profiles on all
client PCs are the same. This sounds simple but there is a problem. There is
a fault in windows such that when you amend/delete user profiles, it doesn't
maintain the data accurately. As such, when you have multiple user profiles
on a client PC, you can actually have the effect of a user signing on using
(say) profile "X" when infact behind the scenes profile "Y" is being used.
This is potentially a very dangerous bug. As a consequence, when using
Microsoft Accounting, you might be trying to access the central system using
profile "X" which you feel should work, but infact windows may be using the
"guest" profile. As such Microsoft Accounting says "You do not currently have
access to this company". To get around this problem, you need to "clean-up"
the user profiles on the client machines. To do this, you need to use the
following utility - see
http://www.microsoft.com/downloads/d...displaylang=en This worked for us.
"David" wrote:
> Hello,
>
> Recently I tried to open an existing company. I received an error "You do
> not currently have access to this company. Do you want to get permanent
> access with the Owner role?"
>
> I choose "Yes" and receive an error "The company could not be opened or
> access was denied. Please ensure that access has been granted and that the
> company database exists."
>
> I have verified that the mssqlserver is running. I verified that the .sbc
> file contains the correct computer name.
>
> I tried to re-attach the data file using the Data Tools-->Advanced Tools,
> but I get an error "The selected file is being used by another application.
> Close all other applications that might be using the file and try again."
>
> At this point, I'm out of ideas. Any help would be appreciated.
Similar Threads
