Using an Array

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

Joe Williams

I have data that I want to store and utilize in Access but NOT be stored in
a table. This is becuase it is sensitive data that I do not want the users
to see, and even though I could control table access with forms and the
like, they still would be able to access the tables in other ways. I need to
prevent this, without going to Access Security

I was told a possible solution might be to store the infomration in an array
constant, as long as the dat did not change much and there wasn't alot of it
to store. This fits nicely with my situation.

My question is, how do I set up an array constant in vba? I would like to
store about 4 variables, both numeric and text. Do I need to set up 4
different arrays with one variable each, or can you basically store all four
things into one array?

Thanks

Joe
 
There is no contstant array in VBA, so you have to make it string, integer,
long, byte, etc
for sensitive data - you can try to encrypt it and store in a table
 
Thanks Alex,

How do you encrypt data in a table?
Click to expand...

Like this?

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Back
Top