DB stalls and does not open?

[Guest]

If any of you can help me out with this issue it would be great.

We are using a Access 2003 Database at work and for some reason some users
cannot open it once it has already been opened and a *.ldb file is created.
As soon as everyone closes out of the database and the *.ldb disappears, the
problem user can go into the without a hitch. Then everyone else can also go
into it without a problem. There is no error message what so ever, you
double click on the *.mdb file and it just sits there and does not even open
or show and hourglass. She has the same permissions to the network as the
rest of us.

Anyone have a clue on what this could be?

If you need more information, just let me know.

Dominick A. Obermeyer, SrA, USAF
Kadena AB

 

[Joseph Meehan]

I would guess the users who are having problems have their copies of
Access configured to open files "exclusively."

 

[Guest]

Is this a setting that is set by the individual computer's access? Because
it is no different how we all access it.

If so where is this adjustment. My appologies if this sounds like a dumb
question though.

SrA Obermeyer

 

['69 Camaro]

Hi, Dominick.

She has the same permissions to the network as the
rest of us.

Yes, but that doesn't matter, since she doesn't trust the network, and
therefore can't use the default, "Don't make me think!" Windows setting
everyone else is using to open Jet database files. She can change her
Internet Explorer settings to trust the local intranet (so she, too, can use
the default setting), or she can type the actual command in a DOS command
shell, or she can use a Windows shortcut that executes that command when she
double-clicks on it (so she never again has to think of what the command
is). Use the following syntax for the DOS command or the shortcut's target
(all one line):

Kadena AB

Hey! I know where that is. It's up the road from the commissary at Foster.
We used to catch a hauncho to go up to Gate 2 Street on weekends.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Joseph Meehan]

Yes it is an Access program setting. Sorry I don't remember the menu
location and I at a non-Access machine right now. Hunt around and you
should find it.

 

[Guest]

I tried that and its a no go. Playing with access, I found that if you open
Access first, then open the file, it works fine, just not when you open the
file from a shortcut or from windows explorer directly.

SrA Obermeyer

 

['69 Camaro]

Hi, Dominick.

I tried that and its a no go. Playing with access, I found that if you
open
Access first, then open the file, it works fine, just not when you open
the
file from a shortcut or from windows explorer directly.

That happens when the shortcut requests the same thing double-clicking on
the file name in Windows Explorer does: "Give me my Windows default setting
for opening this type of file." Please post the shortcut here verbatim, and
we'll see if we can spot the problem.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

here is the shortcut link...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "<network
Directory>\Mini-Goose.MDE"

Do not want to give out our server/directory info.

SrA Obermeyer

 

['69 Camaro]

Hi, Dominick.

Do not want to give out our server/directory info.

Then good luck hiring a mind reader. The accurate ones who know Access well
are really, really expensive.

Alternatively, you can either alter the default setting in the Windows
Registry to accommodate planned usage or else add the local intranet to
trusted sites on the problem computer. I'd suggest the latter.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

well if I was to tweak the registry... where i start snooping?

SrA Obermeyer

 

['69 Camaro]

Hi, Dominick.

well if I was to tweak the registry... where i start snooping?

If you need to ask, then you probably shouldn't be making those changes in
the Windows Registry. Instead, on the problem workstation open Internet
Explorer 6.0 and select the Tools -> Internet Options menu. Select the the
"Security" tab and then "Local Intranet." Select the "Sites" button. In
the "Local Intranet" dialog window, ensure that the "Include all local
(intranet) sites not listed in other zones" and "Include all network paths
(UNC)" check boxes are marked. You may also want to ensure "Include all
sites that bypass the proxy server" checkbox is marked, but I don't believe
it's required for networked Access (Jet) database files in general.

If you have IE 7.0, then it will be a similar process to trust the local
network.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.