Jspenceratty at 14:26, 1 February 2023

2023-02-01T14:26:09Z

← Older revision		Revision as of 14:26, 1 February 2023
Line 3:		Line 3:
	Where do you find it in Prime?		Where do you find it in Prime?
	:1) There is a secret, undocumented command in Access that allows you to remove almost all the garbage that accumulates during programming. Go to Explorer, after you've made major modifications to the front end and look at the file size. If it is larger than 60 MB you might want to try the following.		:1) There is a secret, undocumented command in Access that allows you to remove almost all the garbage that accumulates during programming. Go to Explorer, after you've made major modifications to the front end and look at the file size. If it is larger than 60 MB you might want to try the following.
	:2) Press the Start Button, choose Run, ~~and then type:~~		:2) Press the Start Button, choose Run, (where you do this depends on your version of Windows) and then type:
	~~MSAccess /decompile~~
	(~~Where~~ you do this depends on your version of Windows). Microsoft Access should open. ~~Look at~~ the ~~list~~ of ~~programs displayed by Access and~~ Prime ~~should show up as the last program opened. Start it~~. Access will take a little longer and decompile the front end. It will also remove all the excess baggage that Access accumulates.		::MSAccess /decompile
	:3) This is half the job~~. Now close the Start Screen and the Main Menu~~. Press F11 to open the Navigation Pane and go to any Module and double click on it to open it up. Choose the top line menu, Debug, and select Compile. Then click on File on the Ribbon Bar and pick Repair and Compact. (~~Where~~ this is depends on your version of Access.) This can shrink the program down significantly. Exit the program and check the size of the program in Explorer. Its size should be significantly smaller.
			Microsoft Access should open. Use the options available to select and open your copy of Prime. Access will take a little longer and decompile the front end. It will also remove all the excess baggage that Access accumulates.
			:3) This is half the job. Press F11 to open the Navigation Pane if it is not open, and go to any Module and double click on it to open it up. Choose the top line menu, Debug, and select Compile. Then click on File on the Ribbon Bar and pick Repair and Compact. (Again, where this appears depends on your version of Access.) This can shrink the program down significantly. Exit the program and check the size of the program in Explorer. Its size should be significantly smaller.
	:4) Now push out this front end to all users.		:4) Now push out this front end to all users.

Kempscas: Created page with "Heavy customizations of the front-end of Prime causes it to accumulate extra ‘stuff’ that isn’t removed by a standard Compact and Repair. It can also cause the code to b..."

2017-08-24T19:24:54Z

Created page with "Heavy customizations of the front-end of Prime causes it to accumulate extra ‘stuff’ that isn’t removed by a standard Compact and Repair. It can also cause the code to b..."

New page

Heavy customizations of the front-end of Prime causes it to accumulate extra ‘stuff’ that isn’t removed by a standard Compact and Repair. It can also cause the code to become decompiled. This process will return the front end to the smallest size possible.

Where do you find it in Prime?
:1) There is a secret, undocumented command in Access that allows you to remove almost all the garbage that accumulates during programming. Go to Explorer, after you've made major modifications to the front end and look at the file size. If it is larger than 60 MB you might want to try the following.
:2) Press the Start Button, choose Run, and then type:
MSAccess /decompile
(Where you do this depends on your version of Windows). Microsoft Access should open. Look at the list of programs displayed by Access and Prime should show up as the last program opened. Start it. Access will take a little longer and decompile the front end. It will also remove all the excess baggage that Access accumulates.
:3) This is half the job. Now close the Start Screen and the Main Menu. Press F11 to open the Navigation Pane and go to any Module and double click on it to open it up. Choose the top line menu, Debug, and select Compile. Then click on File on the Ribbon Bar and pick Repair and Compact. (Where this is depends on your version of Access.) This can shrink the program down significantly. Exit the program and check the size of the program in Explorer. Its size should be significantly smaller.
:4) Now push out this front end to all users.

Decompile, Recompile, Repair and Compact - Revision history

Jspenceratty at 14:26, 1 February 2023

Kempscas: Created page with "Heavy customizations of the front-end of Prime causes it to accumulate extra ‘stuff’ that isn’t removed by a standard Compact and Repair. It can also cause the code to b..."