Selasa, 29 Oktober 2019

Re: [MS_AccessPros] Securing FE

 

Crystal,

Thanks a lot. You provided lot of information for my future development work.

Thanks again.
Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

hi Khalid,

definitely, you always want to keep your source code before you deploy a FE so you can change it and make it again!

The FEs you deploy will need to have its tables hooked up again to where ever their back-end is. If you don't have code to do this, they'll need to use the Linked Table Manager.

> "should I ask him to delete his BE "

absolutely not!! Your BE doesn't have the latest data. If anything, you should connect or visit and back up their BE for them. Show them how to do it though. And after it is backed up, it should have Compact/Repair done.

----- steps to open database for development -----

1. Close Access if it is open
2. Open Windows Explorer to your working directory
2. Back up database
2A. In Windows Explorer, right-click on current database filename. From the shortcut menu, choose:
??Send To > Compressed (zipped) folder
??to create a ZIP file
2B. After creating ZIP file, drag it to a backup folder to get it out of the working folder
3. rename database file to keep better track of changes
3A. Rename the file to include:?????????????????????? yymmdd_time
??WHERE
??'yymmdd' is year-month-day, two digits for each
??'time' is a time code like 1400 or 8a or 2p or whatever you want to know the current time

4. open the database in Access
5. compact/repair the database
6. do the development you have in mind

~~~

best wishes for better health

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 10/27/2019 8:48 PM, khalidtanweerburrah@... [MS_Access_Professionals] wrote:

Hi all & respected MVP???s,

After more than a year I???m back, the reason is that I???m sick and on bed due to problem with my legs & feet, moreover my laptop was destroyed.

Anyways struggling and now ambitious to start working, during my this period of illness I think over what I have been doing and was forced and stop me on one main point which, I was doing wrong from the very beginning which I ignored and now realized that is a must. It was giving to my client .be + .accde instead of giving .fe + .accde.

But I???ve some concerns in this regard for which I???m not clear, I need & request complete guidance step by step, I remember John helped and posted in perhaps last quarter of 2013 how to secure FE and I put one module about shift bypass key in my database.

Now in a week or so I have to make many changes in my application on the request and demand of my client, so that is why I need help and guidance from the group.

Very first thing is that I???ve always given BE and .ACCDE to my client, I mean to say whenever the changes or updating was demanded by him, I took his BE make necessary work, copy his BE on my laptop and pass him his BE and latest .ACCDE.

Now for the first time I will give him secured FE + .ACCDE, should I ask him to delete his BE or it may remain on his system.

Secondly, what is the procedure of giving FE to client, would I have to make separate copy of secured FE for my client and protected copy of FE for me to make future updating and changes.

Need help please.

Regards

Khalid??

__._,_.___

Posted by: khalidtanweerburrah@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

.

__,_._,___

Tidak ada komentar:

Posting Komentar