Just checking....

[alexgore]

I've just split my database and expected the file size of the front end file to be small and the back end file to be large....

However the size of the files are approx 175,000 kb each. Does that mean I haven't split it correctly? Does a database need to be empty when you split it? I had about 150 records in it.

Thanks in advance

Alex

 

[JHB]

Have you done the "Compact and repair"?

 

[bob fitz]

The size of the BE will depend on the number of tables and fields that you have and the amount of data they contain.
The size of the FE will depend on the number of queries, forms and reports etc and their complexities.
What was the size of the UNsplit DB?

 

[alexgore]

Hi Bob

The size of the original file was 175,096.
The fe is now the same and the back end is 174,368.
I saved the fe as a accde file and that is now 436 kb

The front end is just a form.

Thanks, Alex

 

[RainLover]

alexgore

I would suggest that before distributing the Database or more particularly converting to a accde file that you do a decompile. then compile your code then do a compact and repair. On both front and back ends. This will clean out any code that is still there but lost from view. It also dose a general clean out.

 

[alexgore]

Thanks for your advice Rain. I am a beginner so if you could point me in the direction of how to de compile, recompile and compact and repair that would be much appreciated.

Cheers

Alex

 

[RainLover]

If you do a Google you should find what you need.

There are slight differences between Versions so it is best to get the right information.

A bit more information for you. While you are designing you may copy a form for the basic layout then delete all the code behind it and replace that code with something different. Or you may delete some code or a Form.

What happens is that sometimes this code still exists. You will never find it but it is there and can interfere with other code. You need to get rid of this. Usually you would do this when the project is complete or if you are getting some strange errors.

A Decompile will do this for you. So you do a Decompile first. Then do a compile to make sure it does indeed compile. Finally a Compact and Repair which gets rid of unnecessary gaps/space in the database.

If you don't do this then maybe nothing bad will happen. It is just one of those things I believe you should do. It is not a regular thing to do. Only do it if you are have code problems or you are about to release a new version.

Back up first. You should while developing be making a back up often. How often is up to you. Just think along the lines of how much work do you want to redo.

Hope this is of some help to you.