|
Home > Archive > MS Access Multiuser > January 2006 > Access 2.0 db on Windows 2003 server and Access 2003
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 |
Access 2.0 db on Windows 2003 server and Access 2003
|
|
|
|
Hi!
Till now i have Access 2.0 db xxx.mdb on Novell server and Access 2.0
clients on XP workstations. Also I have Access 2003 client with db
yyy.mdb on local workstation, where are the linked tables from xxx.mdb,
reports and queries whoes take the date from linked tables. Everything
works fine until migrate from Novell server to Windows 2003 server (all
permitions are taken from Novell - and now for all users are set "full
access" to db and all directory). All users with Access 2.0 client can
open and work with xxx.mdb, but if i try to open db yyy.mdb - i can't
run queries or reports - the result is: "Can't open xxx.mdb, db are in
use". And file xxx.ldb on server, with notepad, i can't open too - the
result is: "Access denied". And then users with access 2.0 can't open
xxx.mdb too. After that, all users must close the Access and open one
more time the db. But i can't say, that Access 2003 users can not open
the db yyy.mdb with linked tables - if this user opening db first - all
working fine, untill access 2.0 user opening db xxx.mdb. I think- the
problem is with xxx.ldb file. I monitoring the files with "File system
monitor" and saw - when Access 2003 users run report, macros or queries
on db yyy.mdb, the status of file xxx.ldb is "delete pending". What is
my problem?
Immaa
P.s. Sorry for my english :(
--
Immaa
------------------------------------------------------------------------
Immaa's Profile: http://www.hightechtalks.com/m764
View this thread: http://www.hightechtalks.com/t2336148
| |
| david epsom dot com dot au 2006-01-19, 3:25 am |
| Access 2003 does not work well with Access 2.0
Remove DELETE permission from xxx.ldb
In Access 2003, turn off Record Level Locking option.
(david)
"Immaa" <Immaa.21um1y@no-mx.forums.yourdomain.com.au> wrote in message
news:Immaa.21um1y@no-mx.forums.yourdomain.com.au...
>
> Hi!
>
> Till now i have Access 2.0 db xxx.mdb on Novell server and Access 2.0
> clients on XP workstations. Also I have Access 2003 client with db
> yyy.mdb on local workstation, where are the linked tables from xxx.mdb,
> reports and queries whoes take the date from linked tables. Everything
> works fine until migrate from Novell server to Windows 2003 server (all
> permitions are taken from Novell - and now for all users are set "full
> access" to db and all directory). All users with Access 2.0 client can
> open and work with xxx.mdb, but if i try to open db yyy.mdb - i can't
> run queries or reports - the result is: "Can't open xxx.mdb, db are in
> use". And file xxx.ldb on server, with notepad, i can't open too - the
> result is: "Access denied". And then users with access 2.0 can't open
> xxx.mdb too. After that, all users must close the Access and open one
> more time the db. But i can't say, that Access 2003 users can not open
> the db yyy.mdb with linked tables - if this user opening db first - all
> working fine, untill access 2.0 user opening db xxx.mdb. I think- the
> problem is with xxx.ldb file. I monitoring the files with "File system
> monitor" and saw - when Access 2003 users run report, macros or queries
> on db yyy.mdb, the status of file xxx.ldb is "delete pending". What is
> my problem?
>
> Immaa
> P.s. Sorry for my english :(
>
>
> --
> Immaa
> ------------------------------------------------------------------------
> Immaa's Profile: http://www.hightechtalks.com/m764
> View this thread: http://www.hightechtalks.com/t2336148
>
| |
|
|
david epsom dot com dot au Wrote:
> Access 2003 does not work well with Access 2.0
>
> Remove DELETE permission from xxx.ldb
>
> In Access 2003, turn off Record Level Locking option.
>
> (david)
>
>
>
> Hi!
> Thanks fopr answer, but Record Level Locking option is already turned
> off and with removed DELETE permission don't work too.
> Any ideas?
>
> Immaa
--
Immaa
------------------------------------------------------------------------
Immaa's Profile: http://www.hightechtalks.com/m764
View this thread: http://www.hightechtalks.com/t2336148
| |
| david epsom dot com dot au 2006-01-19, 8:25 pm |
| Sorry, I don't know anyone who got this to work.
(david)
I did not know it would work with Novell
"Immaa" <Immaa.21vm5z@no-mx.forums.yourdomain.com.au> wrote in message
news:Immaa.21vm5z@no-mx.forums.yourdomain.com.au...
>
> david epsom dot com dot au Wrote:
>
>
> --
> Immaa
> ------------------------------------------------------------------------
> Immaa's Profile: http://www.hightechtalks.com/m764
> View this thread: http://www.hightechtalks.com/t2336148
>
|
|
|
|
|