Splitting Database without SQL?

[Guest]

I searched, but could not find anything on this. I would like to split a
database and am wondering it you need to be using SQL to do this correctly. I
had split the databse and it the swichboard and everything works, but the
data is not being updated throughout the database. It only get's updated at
the local PC and not on the Server. Do I have to use some type of SQL
programming for this?

Thanks,

 

[Wayne Morgan]

There is a splitting wizard in Access. It will move the tables to a
"back-end" file and create linked tables in the "front-end" file. The
back-end should have nothing but the data tables. If you have any tables
that you use for temporary storage, these should be in the front-end
(there's an even better way to handle this though). See if these links from
Tony will help.

http://www.granite.ab.ca/access/performancefaq.htm
http://www.granite.ab.ca/access/splitapp/index.htm
http://www.granite.ab.ca/access/bloatfe.htm

 

[Albert D.Kallal]

I explain in detail how this splitting stuff works here...

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm