Search results

Ok, I need some advice from all you access wizards out there. I will try to explain what I am trying to do and hopfully you can put me on the right road to complete this task. I have a database, with tables to store information along with a couple of lookup tables for some computations, forms...

Try running an update query between the original database and the new database.

I may be wrong but there must me a better way than "cut and paste".

Mike, I do have VB6 and would appreciate the code. Do you have a suggestion on a good source book to learn encryption technics? I would like to try your suggestion of encrypting the lookup tables. Would this just me a matter of reading the record data jumbling it up and putting it back in the...

I am begining to think this is a lost cause. No matter what I do besides running the Security wizard, my data is not secure. Microsoft strikes agian.

ok, if you are still interested. This is what I have done so far. 1. Made a logon screen to set the code that locks out the shift key. 2. Hid all the objects and turn off show hidden obljects in the menu. 3. Passworded my Visual Basic code. 4. Made an MDE file. 5. Encrypted the MDE file. Some...

oldsofty I have proceeded with an approach of using the function to turn off the "shift key" on program load, hidding objects and disableing the menus. Along with this I have implemented a form to input a user name and password to control the "shift key" and set a bit to display some of the...

Oldsoftboss, ok I thought about this a little more. If I hide all objects and lock out the shift key by a password, then a user cannot see the objects to import into another database? Is there anyway around this? I mean is there someway a user can see these objects if they cannot get to the menu...

Oldsoftboss, yes I have looked at or tried all that you suggest. I have a problem with your comment "Are your customers Access literate". Anybody with some computer knowledge, a little time and the "love of the challenge" will figure this out within a few minutes. Our customers are large...

Thanks, for the quick reply. I am finding that the security scheme of this product is not useful for the product that I am building or I am missing something. We will distribute this database to customers after a work session with them. It will provide recommendations based on how they...

I have spent some time going through the information on securing an Access 2k database along with using the Security wizard. I have come to some conclusions, the security schemes are not straight forward and #$%!. Sorry for the venting. What I am trying to do is as follows. I have a database...

I had used the Sorting and Grouping to do the original report. This did not work for what I needed for the new report. I needed to put each record into two groups or one group baised on the results of two fields. The way that I had to do it was create a query for each group that OR'd the two...

I would like to know if it is possible to group a report on two fields of a form. The form is based on a query. I have several questions with multiply answers. Each answer is given a score and that score is applied to the record. Each record is grouped according to the score which worked well on...