splitting database

[Guest]

I need some assistance with splitting my database. I have succesfully split
the database, but cannot understand how it works. I thought it meant that
once data had been entered in the front end, it would update the back end,
which it does, but i was lead to believe that you could not then delete or
alter information in the tables from the front end? only I should be allowed
to do that. as we have just recently had our server upgraded along with
terminal services, i have to make the database available to multiple users.
There problem i am really having is that how many copies of front ends do i
need to make? becuase there will need to be access available to some users in
our USA office too. we have some form of remote access available to us now,
but what are my options for making this database available for users here
(LAN) and in our USA office? data acces pages just dont seem right to me. I
dont really like the way the work.

Hope this makes sense to someone.

Kind regards
Rigby

 

[Douglas J Steele]

You're not storing any data in your front-end: assuming you split correctly,
your data exists only in the back-end. That means that there's no such thing
as deleting or altering information in the tables in the front-end: You
don't have tables in your front-end. You have pointers to tables in the
back-end.

Each user should have his/her own copy of the front-end, preferably on their
hard drive.

Assuming that your remote users have their copy of the front-end on the
terminal server, they should be fine. Otherwise, Access tends to be very
sensitive to network problems. You could consider Replication, whereby you'd
have independent copies of the back-end that get synchronized on a regular
basis, but that has a fair learning curve as well.

 

[Guest]

Dear Douglas

I used the wizard to split the database, i am hoping that should have split
it correctly. So, where do I store the back end of the database? and where
would I store the front ends of the database for those remote users? you
mentioned saving them on the terminal server. I am not very educated in this
side of things, unfortunately, so do you mean that i should have a separate
directory for remote users on the server with a number of copies of the front
ends? will this all update the back end (if it is in the right location)?

Thank you so much for your help.

Very Kind Regards
Rigby

 

[Douglas J Steele]

Albert Kallal has a lot of good information about splitting at
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm, and Tony
Toews does as well at http://www.granite.ab.ca/access/splitapp/index.htm

 

[Guest]

Douglas

thank you kindly. This has been a load of help. It explains so much for me.

Cheers
Kind Regards

Rigby