Unlocking Access Database
Christel Kirwan
Our database is password protected,and the person who designed it is no
longer with the company. Does anyone have any suggestions on how to unlokc
the database?
Wayne N. Paul
Christel Kirwan wrote in message <01bd88b7$3f989980$450a10ac@reginv>...
>Our database is password protected,and the person who designed it is no
>longer with the company. Does anyone have any suggestions on how to unlokc
>the database?
If it were easy to get in without the password, umm ... what
would be the point of even having security.
That said, let's move on...
You'd be absolutely amazed what a simple, one-page letter signed by
an attorney in your legal department (sent registered mail/return receipt)
will do. (or if you don't have a legal department you can probably hire one
to do this for a small fee.)
Does this former employee refuse to give up the password ???
If so then a lawsuit for any damage to your business would seem
appropriate. Hell, in my state, you file in small claims yourself, don't
even need an attorney.
Check with an attorney. Your mileage may vary.
Bas Berghoef
Hi,
Seems like you ex-employee wasn't very happy with leaving.
www.crak.com
Has a util that seems to do the trick. (haven't tried it though)
HTH
Bas Berghoef
Richard Yang
I have some problem with Access97. I want to display
pictures(like .jpg or .bmp file) in one field on the form.The form
is for keeping track of products. Each product has a picture to display.
Once the user selects a product, the picture field will change to
the picture for that product. There are 4000 pictures, so I do not
want insert pictures into my database, because that needs too much memory.
The picture is stored in a file that the file name is the same as product code.
Product code
is MVC-001s, the file of the picture name is MVC-001s.jpg or .bmp. Would
you help me to find the way that each time when I select one product,
the picture for that product will display in the field on the form?
Thank you for your help !
Dev Ashish
While it's possible to actually store the images within the database itself
as OLE objects, normally it's not the preferred way. When you embed an OLE
object in a table, you're storing a lot of overhead as well. This overhead
is the information about the object (such as it's parent application) that
Access needs to store in order to render the object properly. For more
details, visit this link
Article ID: Q123151
Why OLE Objects Cause Databases to Grow
The preferred way to display images is to store the complete path and
filename to the actual files themselves within a table, and then use the
Image tool (in Access 95/97) to update the display. For details, check out
this article.
Article ID: Q148463
How to Display Image in Form Without Storing It in Table
Lastly, if you have a bunch of files in a folder that you need to load
into a table, then check out this article. Note: The method described in
the article actually loads the image in the table. If you don't want to do
that (see above), then you can simply save the filename in a string field.
Article ID: Q158941
How to Load OLE Objects from a Folder into a Table
HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------
Richard Yang wrote in message <3572E3DB...@previewsoft.com>...
:I have some problem with Access97. I want to display
:
:
:
Fernando Martins
>I have some problem with Access97. I want to display
>
>pictures(like .jpg or .bmp file) in one field on the form.The form
>
Take a look at Wang Imagin Controsl in Win95 OSR2 and WinNT 4
or any other ActiveX Control for images