Db with FE and BE on client and server pc resply.

[anita]

I am a creating a database(db) with tables, forms, reports and queries
in it.
I used the Database splitter to split the database, it created a
backend
database with just the tables in it and I am happy about it.
But the front end db contains all of tables and forms, reports and
queries, which ofcourse I am not happy about. I want the front end to
contain everything except for tables in it. Is it possible to do this
?
Also can i have the Front end db on client pc and Back end db on
server ?
If yes, how can i connect the various controls on forms to the
repsective table fields.
Please anybody's help will be highly appreciated in this regard. I am
brand new
to access programming.
Please help me.
Thanks in advance.

Regards
Anita

[Jeff Smith]

Hi Anita,

The database splitter has done its job correctly. If you have a look at the
tables in the front end you'll notice that the tables also have a black
arrow which signifies that they are "Linked" tables. Try opening up these
linked tables in design view and look at the message that appears. If the
front end didn't have linked tables, the forms, queries and reports wouldn't
have any recordsources to work with.

The whole idea of having a split database is to have a single source for the
data (back end) where the best to place it is on the server and to place a
copy of the front end on each PC that will be using the database. After you
place the back end on the server you need to relink the front end tables so
they know where to look for the correct tables. In the front end go to Tools
on the menu, select Database Utilities and click linked table manager. Click
"Select All" and tick "Always prompt for a new location" and then click OK.
Search for the back end and then click Open. When the relinking has finished
you can then make copies of the front end to place on each PC.

Connecting the controls on the forms to the linked table fields are the same
as standard table fields. If you are a novice in developing in Access,
create your forms using the wizards and select your linked tables as the
record source. Then go into the form's design view and modify the design to
your liking.

Jeff
"anita" <ta*******@yahoo.com> wrote in message
news:6e**************************@posting.google.c om...

I am a creating a database(db) with tables, forms, reports and queries
in it.
I used the Database splitter to split the database, it created a
backend
database with just the tables in it and I am happy about it.
But the front end db contains all of tables and forms, reports and
queries, which ofcourse I am not happy about. I want the front end to
contain everything except for tables in it. Is it possible to do this
?
Also can i have the Front end db on client pc and Back end db on
server ?
If yes, how can i connect the various controls on forms to the
repsective table fields.
Please anybody's help will be highly appreciated in this regard. I am
brand new
to access programming.
Please help me.
Thanks in advance.

Regards
Anita

[Larry Linson]

A good single-user application, just split, doesn't often make a good
multiuser application. There are some different considerations.

So, to take it on from here, there's an introductory presentation on Access
in a Multiuser Environment that I did for my user group that you can
download from http://appdevissues.tripod.com. It will identify topics that I
thought worthwhile to discuss, and a bit more. The best collection of
detailed information and links on the subject of Access in the multiuser
environment is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Best of luck on your project.

Larry Linson
Microsoft Access MVP

[anita]

Hi Jeff

Thanks for your wonderful help. It worked.

Anita

"Jeff Smith" <No***@Not.This.Address> wrote in message news:<cj**********@lust.ihug.co.nz>...

Hi Anita,

The database splitter has done its job correctly. If you have a look at the
tables in the front end you'll notice that the tables also have a black
arrow which signifies that they are "Linked" tables. Try opening up these
linked tables in design view and look at the message that appears. If the
front end didn't have linked tables, the forms, queries and reports wouldn't
have any recordsources to work with.

The whole idea of having a split database is to have a single source for the
data (back end) where the best to place it is on the server and to place a
copy of the front end on each PC that will be using the database. After you
place the back end on the server you need to relink the front end tables so
they know where to look for the correct tables. In the front end go to Tools
on the menu, select Database Utilities and click linked table manager. Click
"Select All" and tick "Always prompt for a new location" and then click OK.
Search for the back end and then click Open. When the relinking has finished
you can then make copies of the front end to place on each PC.

Connecting the controls on the forms to the linked table fields are the same
as standard table fields. If you are a novice in developing in Access,
create your forms using the wizards and select your linked tables as the
record source. Then go into the form's design view and modify the design to
your liking.

Jeff
"anita" <ta*******@yahoo.com> wrote in message
news:6e**************************@posting.google.c om...

I am a creating a database(db) with tables, forms, reports and queries
in it.
I used the Database splitter to split the database, it created a
backend
database with just the tables in it and I am happy about it.
But the front end db contains all of tables and forms, reports and
queries, which ofcourse I am not happy about. I want the front end to
contain everything except for tables in it. Is it possible to do this
?
Also can i have the Front end db on client pc and Back end db on
server ?
If yes, how can i connect the various controls on forms to the
repsective table fields.
Please anybody's help will be highly appreciated in this regard. I am
brand new
to access programming.
Please help me.
Thanks in advance.

Regards
Anita

[anita]

Hello Larry

Your tips were very useful for me.
The links are wonderful. Thank you so much. I really appreciate your help.

Anita
"Larry Linson" <bo*****@localhost.not> wrote in message news:<IMm6d.8230$Mf.3186@trnddc05>...

A good single-user application, just split, doesn't often make a good
multiuser application. There are some different considerations.

So, to take it on from here, there's an introductory presentation on Access
in a Multiuser Environment that I did for my user group that you can
download from http://appdevissues.tripod.com. It will identify topics that I
thought worthwhile to discuss, and a bit more. The best collection of
detailed information and links on the subject of Access in the multiuser
environment is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Best of luck on your project.

Larry Linson
Microsoft Access MVP

[Larry Linson]

"anita" wrote in message

... Thank you so much. . . .

You are most welcome. I'm glad I could be of help.

Larry Linson
Microsoft Access MVP