Hide ldb file

[Stephen sjw_ost]

Hello again,

I have a need to be able to pragmatically hide the LDB file once my MDB/MDE
file is opened.
Reason is, not everyone that needs to use my DB is computer savy and if the
DB is already open, some folks are trying to open the ldb by mistake.

Can the ldb file be hidden pragmatically? If so, any sample code would be
greatly appreciated.

 

[Tom van Stiphout]

On Wed, 28 Jan 2009 18:46:05 -0800, Stephen sjw_ost

(I think you meant programmatically) No, I can't see an easy way to
hide the ldb file. But why not simply put a shortcut (perhaps even
with a cool icon) on the desktop?

-Tom.
Microsoft Access MVP

 

[Stephen sjw_ost]

The icon idea is a great idea but my DB is accessed accross America, from
Florida to New Mexico, by quite a few people. I don't beleive coordinating an
icon would be the answer for this particular issue.
Any other thoughts of how I might be able to distingush the MDB/MDE from the
LDB file?
If nothing else, I guess I could create a switchboard thru access. I was
hoping to avoid this if possible.
Thank you for your response.

 

[Stephen sjw_ost]

Sorry, fast typing and under a deadline.

 

[Tom van Stiphout]

On Wed, 28 Jan 2009 19:50:11 -0800, Stephen sjw_ost

You should consider distributing your app using a Setup program. It
could create the desktop shortcut.

-Tom.
Microsoft Access MVP

 

[Tony Toews [MVP]]

The icon idea is a great idea but my DB is accessed accross America, from
Florida to New Mexico, by quite a few people. I don't beleive coordinating an
icon would be the answer for this particular issue.

1) Generally we give users a convenient option such as a desktop
shortcut to start the app as it's a lot easier that going through
Windows Explorer. Many users don't even know how to use Windows
Explorer.

2) You should be giving each user their own copy of the FE anyhow
usually stored on thier local system. They shouldn't be sharing the
MDB in the fashion you are describing.

If nothing else, I guess I could create a switchboard thru access.

What do you mean by this.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/