How can I hide a table of data?

[James Franklin]

Hi,

I am designing an application to be used by I.T. users familiar with Access.
They will be able to bypass my UI to view the standard Access UI, but they
will not be able to view VBA code.

As part of a security feature, I need to have a 2 field table of data
available to the application which the users cannot ever see. Can anyone
give me some ideas as to the best way of doing this? I have even thought of
hardcoding the data into an array but
1) I am not sure how to do this,
2) I need a few thousand rows of data
3) I dont know if this is the best way to achieve it.

Can anyone help me?

Many thanks,
Jim

 

[Rick Brandt]

Hi,

I am designing an application to be used by I.T. users familiar with
Access. They will be able to bypass my UI to view the standard Access
UI, but they will not be able to view VBA code.

As part of a security feature, I need to have a 2 field table of data
available to the application which the users cannot ever see. Can
anyone give me some ideas as to the best way of doing this? I have
even thought of hardcoding the data into an array but
1) I am not sure how to do this,
2) I need a few thousand rows of data
3) I dont know if this is the best way to achieve it.

Can anyone help me?

Many thanks,
Jim

Available to the application how? If you keep it in a different file and only
use code to access it then they would have a pretty difficult time figuring out
where the table was.