FE/BE

[gtree]

Hi,
I have a Question regarding using Access as both the Back-end and front-end in a multi-user environment.
I have split my Database.
My FE is still retaining data. I don't want data in the FE. How can data be stored ONLY in the BE?
I was reading some answers given earlier on this website,
It said "3) If your FE still has data tables, import them into the BE file and link them from the BE to the FE. You may choose to leave some lookup tables in the FE for the sake of speed but this is not necessary"
I imported the tables from the FE back to BE and deleted them from the FE. Now when I try to open the Form on my FE it says MS Jet Database engine cannot find the input table or query. Also there are now 2 sets of tables in my BE

How do you think I should go about creating a BE-FE in a multi-user environment using Access. the FE would be Access Forms/Reports.

If you could please answer this, it would help me a lot.

Thanks

 

[jazzz]

There should be NO data in the FE except something like a version table. So open the BE and import the tables with data from the FE to the BE. Now rename them in the FE to tableold or whatever then Link to them in the BE via the FE and that should do it?
Life's a journey enjoy the ride...

jazzz