|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
secured database doesn't open on new serverWe have a secured database that worked fine until moved to a new server. It
even worked on the new server until they shut off the old one yesterday. The shortcut target is changed to the new paths. It opens Access but not the database. No error message. Any ideas where we should look, what we are missing? Thanks very much for any ideas. On Tue, 17 Mar 2009 10:41:01 -0700, denise
<den***@discussions.microsoft.com> wrote: Give us more details. I presume that per best practices the database is split between FE on each machine and BE on the server? Where is the MDW file? Show us the full shortcut. -Tom. Microsoft Access MVP Show quoteHide quote >We have a secured database that worked fine until moved to a new server. It >even worked on the new server until they shut off the old one yesterday. >The shortcut target is changed to the new paths. It opens Access but not the >database. No error message. Any ideas where we should look, what we are >missing? Thanks very much for any ideas. Target path in shortcut is "C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "X:\Telehealth\Telehealth\UPTN.mdb" /wrkgrp "X:\Telehealth\Telehealth\Secured.mdw" For Start in I tried both "C:\Program Files\Microfoft Office\Office" and also tried using "X:\Telehealth\Telehealth" with the same results. Access opens but not the database. Yes for the back end being on the server. Thanks very much for any ideas. Show quoteHide quote "Tom van Stiphout" wrote: > On Tue, 17 Mar 2009 10:41:01 -0700, denise > <den***@discussions.microsoft.com> wrote: > > Give us more details. I presume that per best practices the database > is split between FE on each machine and BE on the server? Where is the > MDW file? Show us the full shortcut. > > -Tom. > Microsoft Access MVP > > > >We have a secured database that worked fine until moved to a new server. It > >even worked on the new server until they shut off the old one yesterday. > >The shortcut target is changed to the new paths. It opens Access but not the > >database. No error message. Any ideas where we should look, what we are > >missing? Thanks very much for any ideas. > On Wed, 18 Mar 2009 05:29:13 -0700, denise
<den***@discussions.microsoft.com> wrote: The "Start In" does not matter for this issue. You can first verify that indeed the X-drive now points to the new server. Let's assume it is. Next we can surmise that UPTN.mdb is what we call a "monolithic" application, i.e. the tables, queries, forms, reports etc are all in one file. That is VERY BAD but probably not the cause of your problems. You didn't say what version of Access you are using. If A2007 you may need to re-set the Trust Center settings. Also ensure user has read/write/create permission on the share, the folder, and the files. Still wondering about my "VERY BAD" statement? See http://allenbrowne.com/ser-01.html and many other resources on this topic. If your app is already split, then the FE should be on each workstation and the shortcut to the MDB should most likely point to the C-drive, not the X-drive. The MDW is OK to be on a shared drive. -Tom. Microsoft Access MVP Show quoteHide quote >Target path in shortcut is "C:\Program Files\Microsoft >Office\Office\MSACCESS.EXE" "X:\Telehealth\Telehealth\UPTN.mdb" /wrkgrp >"X:\Telehealth\Telehealth\Secured.mdw" >For Start in I tried both "C:\Program Files\Microfoft Office\Office" and >also tried using "X:\Telehealth\Telehealth" with the same results. Access >opens but not the database. >Yes for the back end being on the server. >Thanks very much for any ideas. > >"Tom van Stiphout" wrote: > >> On Tue, 17 Mar 2009 10:41:01 -0700, denise >> <den***@discussions.microsoft.com> wrote: >> >> Give us more details. I presume that per best practices the database >> is split between FE on each machine and BE on the server? Where is the >> MDW file? Show us the full shortcut. >> >> -Tom. >> Microsoft Access MVP >> >> >> >We have a secured database that worked fine until moved to a new server. It >> >even worked on the new server until they shut off the old one yesterday. >> >The shortcut target is changed to the new paths. It opens Access but not the >> >database. No error message. Any ideas where we should look, what we are >> >missing? Thanks very much for any ideas. >> Le 17/03/09 18:41, dans F56F0423-286C-412A-A95F-50017808B***@microsoft.com,
« denise » <den***@discussions.microsoft.com> a écrit : > We have a secured database that worked fine until moved to a new server. It Yes i'm sure it's very interressing, but si vous pouviez traduire en> even worked on the new server until they shut off the old one yesterday. > The shortcut target is changed to the new paths. It opens Access but not the > database. No error message. Any ideas where we should look, what we are > missing? Thanks very much for any ideas. français, ce serait si pratique pour la minorité monolinguale dont je fais parti.... Mais tant que ça n'altére pas mon ordi, tout va bien..... Et si en plus vous ne pouvez pas regarder ce qu'il y a dedans, c'est mieux. Bien à vous  
Other interesting topics
I think this is a password problem?
Hide Certain Fields wherever they appera to Read-Only Users Set password for groups which group? Create basic user for one database Avira warns of master boot sector system error parental controls Can I convert my MDE file back to MDB Database? Access 2007 security and the Access 2003 system.mdw file Free Antivrius? |
|||||||||||||||||||||||
