MDE/Splitting databases

[viperstingray]

Hello,

I have been reading a lot about splitting databases on this forum. I still have some questions.
1) Will the FE (Front End) still show the tables?
2) Will users still be able to edit the forms, reports, etc.?
3) Will my code be hidden
4) Will all the users have up to date data showing when they open the Database?
5) Can more than one person open and input data in the database at the same time?

I also want to make an MDE copy, do I split first or make the MDE and then split?

The whole point is the following: I want the people (maximum 10) that will be using this database to only be able to do enter and view data. They should be able to generate the reports but not create new reports. I only want ONE person to be able to edit the forms, code, and reports. How would I do this.

Your help is much appreciated

 

[viperstingray]

Another small thing. I tried making an MDE out of my data base and got the following message====> "microsoft access was unable to create an MDE database"

Why did I get this message???

 

[viperstingray]

Help Please

This thing is due by friday and I cannot seem to be able to split it or anything

 

[jrjr]

1) you will see linked tables in the FE. The actual tables reside in the BE though

2)no

3)yes

4)yes

5)yes

Any editing or changing of the program will have to be done with the .mdb. Then you will create a new .mde and replace the old one. Make sure you save the .mdb!

Split first then make .mde from the FE

Your code is not compiling, that is the reason you cannot create a .mde. There are some errors in there somewhere that is preventing this. You will have to correct this before moving on.