Finalise database and implement??

[Turbo910]

Hey guys

I need your awesome expert advise once more.

Basically ive finished my database for the mean time and i want to implement it into the business i have created it for for a tral period of a month.
Heres the database in boht 2007 and 2003 form:
View attachment zipInventory.zip

K so give me your views on the databse and give me any tips and changes i should make, in order for it to run successfully within a business environment.

NOW the major question and i guess theres been alot of posts about this which i have seen a few of but i dont understand alot of them.

WHere do i go from here in order to implement the db into a business enviironment?
Do i create and exe. file somehow?
How do i make the db secure so the users cant effect it?
Do i have to split into back end and front end??
All of these kind of questions, but the end result what i want the user to be able to do is look on the desktop and double click an icon exe. or equivalent and load the Main menu form and then go to all 4 forms from that point.


Any help guidence would be appreciated greatly and please spell out all instructions for me as i am not that good with access yet

 

[HiTechCoach]

Do i create and exe. file somehow?

It is not possible to create an EXE file from an Access database. You can compile the database into an MDE or ACCDE. Note that it will still require Access (full or runtime) to be installed to run the database.

How do i make the db secure so the users cant effect it?

Same as above. Compile the database into an MDE or ACCDE.

Do i have to split into back end and front end?
IMHO, Yes! I would always split any database. This way you can compile the front end into an MDE or ACCDE.

Note: I start every database split. I will only support split databases. I will not work on any database that is not split. I will split ti first. Even it is is for a single user run on a stand alone PC.

 

[Turbo910]

Ok great, so would you be able to give me some steps on how to compile and the best way to split and store the databse?

Thankyou

 

[HiTechCoach]

See:

http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Turbo910]

Ok so hey ive split my database.
Packaged the front end as an ACCDE
And trialed it.

Some things i would like to clear up now

Firstly are there any security features that i can put in place so no one tampers with it??? i have already made it ACCDE so anything else i should do??

I have the db set up with a macro so when runtime is installed and the db opens the main menu opens automatically and is a pop out screen but half of it is cut out becasue the pop out makes it centered, is htere any way i can get the whole form to show on screen without automatically making it maximise?, if not how do i make it automatically maximise??

Also obv i have split the db so i have both the be and fe on my computer that i created the database on. Now is it as simple as creating a folder in the user computers documents and placing the be in there or should i do something else to install the be on the users computer?? If you dont understand me please just say and ill try to explain more

thank you