Microsoft Access: some questions

[Nige]

I hope this is the right group, the Microsoft hierarchy seems a bit
random. I've got a few questions about Microsoft Access; I'm using 2003,
but most of the questions will relate to earlier version.

[1] Can I link each record in a database to an external picture, then
display that picture on a form?

[2] Can you globally change the field names in a database, so all the
queries and forms get updated?

[3] How do I stop Access 2003 from asking if I want to open the
database. I wrote it, I know it's OK? I've read the KB info, but I don't
know how to do what it says.

 

[James Goodman]

1. Yes. See this link:
http://www.angelfire.com/sports/f1pictures/AccQuestion3.htm
2. Yes, this can be accomplished using Name Autocorrect. It does however
incur a performance overhead.
3. Not sure, I havent used 2003 yet...

 

[Grumpy Aero Guy]

[1] Can I link each record in a database to an external picture, then

display that picture on a form?

EXTERNAL pic... hmmmm... don't think so, but not sure. I AM pretty sure that
you can store pictures in a record field in a table. You may want to try
that approach.

[2] Can you globally change the field names in a database, so all the

queries and forms get updated?

Yes....Versions beyond 97 have an (automatic) cascade update feature, such
that when you cahnge a field name (or such), the updates cascade through to
forms, queries, etc. If you have vb code behind your forms, reports, or
modules with code, I believe you may have to go in "manually" and update the
code for the appropriate change. Check help and check if you have to turn
that feature "on", or if it is enabled by default.

[3] How do I stop Access 2003 from asking if I want to open the

database. I wrote it, I know it's OK? I've read the KB info, but I don't
know how to do what it says.

Good one....I'm looking for an answer to that as well. It IS irritating.
I'll keep my scope on this post because I'd like to know as well.

Hope this helps.

--


Frank Bachman
(Grumpy Aero Guy)

I hope this is the right group, the Microsoft hierarchy seems a bit
random. I've got a few questions about Microsoft Access; I'm using 2003,
but most of the questions will relate to earlier version.

[1] Can I link each record in a database to an external picture, then
display that picture on a form?

[2] Can you globally change the field names in a database, so all the
queries and forms get updated?

[3] How do I stop Access 2003 from asking if I want to open the
database. I wrote it, I know it's OK? I've read the KB info, but I don't
know how to do what it says.


--
Nige

Please replace YYYY with the current year
ille quis mortem cum maximus ludos, vincat

 

[Arvin Meyer]

I hope this is the right group, the Microsoft hierarchy seems a bit
random. I've got a few questions about Microsoft Access; I'm using 2003,
but most of the questions will relate to earlier version.

[1] Can I link each record in a database to an external picture, then
display that picture on a form?

Yes, see the sample PictureMgr app at my website:

http://www.datastrat.com/Download/Picture2K.zip

[2] Can you globally change the field names in a database, so all the
queries and forms get updated?

Yes, You can turn on Name AutoCorrect, and in A2003 use the dependency tool.
There is a huge performance hit, (nothing to worry about on a high power
machine) and a few minor bugs. I prefer one of the 3rd party utilities to do
this. They only are working when you open them so there's no performance hit
at all. They're also stable.:

Speed Ferret:
http://www.moshannon.com/

and Find & Replace:
http://www.rickworld.com/products.html

[3] How do I stop Access 2003 from asking if I want to open the
database. I wrote it, I know it's OK? I've read the KB info, but I don't
know how to do what it says.

On your own machine you can self-certify the application. If there's a
Certificate Server in your own domain, you can create a certificate. You can
also buy a certificate at one of the Authentication services (see
microsoft.com for a list). You can also set security to low if you aren't at
risk (connected to the internet or using outside code). Do that in Tools ...
Macros ... Security.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Albert D. Kallal]

[1] Can I link each record in a database to an external picture, then

display that picture on a form?

EXTERNAL pic... hmmmm... don't think so, but not sure. I AM pretty sure that
you can store pictures in a record field in a table. You may want to try
that approach.

If you read the many posts here (we get about 1 a day), all of the regular
developers here recommend that you DO NOT store the pictures in side of
ms-access. The first problem is a rather large bloating problem. A 100k jpeg
compressed picture becomes a good 1 meg file in ms-access. You store 100
pictures...you get 100 megs. A horrible situation.

further, buy leaving the pictures out in a dir, then you are free to use all
kinds of the cool picture printing utilities, or just simply use your
favourite picture editor. Putting all those pictures stuck inside the
database is also real horrible to get them back out when you migrate to
another database, or even want some other software to use those images.
Simply put...keep them out of the database.

Here is a few links on this issue:

http://www.mvps.org/access/forms/frm0030.htm


It is very easy to set a field to the path to the image,and then give that
path name to the image control.