Back end Vs Front end - Split database

[Pedro]

Hi everyone
I have several database on my intranet that i want, some
people of my company to read data. I've tried data access
pages but it works only if my database is closed along
with some dificulties i had on displaying some data. Then
i've tried to create databases with all tables linked and
some qry and reports all through a switchboard manager.
Had good results, visuali speaking, but same problem, i
had to close my database so they can access it. Think it's
a problem of Microsoft. Finaly i want to try the split
database function. Are there anyone who can explain/help
me how it works or just give a link so i can learn how to
do it cose i've tried alone and didn't make it cose, i'm
told it would create a back end and a front end database.
The result was : it has create only a back end and this
one without anything else but the tables only. The front
end, the one i'm told i should put in the access area, has
everything. I'm a litle confuse. I hope you're not with my
english and can help me or direction me to the solution of
this problem through a link so i can learn or simply teach
me.
Tks in advance
Pedro

 

[Immanuel Sibero]

Hi Pedro,

This site has very good information:
http://www.granite.ab.ca/access/splitapp.htm

Immanuel Sibero

 

[Nikos Yannacopoulos]

Pedro,

In a nutshell, the idea is that the Back End holds all the tables and
nothing else (like you say you've done), while the Front End has links to
all the tables in the BE (File > Get External Data > Link Tables) and hosts
all other Access objects, i.e. queries, forms, reports, macros, VB
modules... but no data (or, very little, mostly temporary). The FE is what
the user runs. To put it this way, the FE does all the work managing data
that does not belong to it.

Hope I haven't just confused you!

Nikos