front end/back end issue

[Guest]

Greetings!
I have an access database and it works well. I have a front-end and a
back-end. Now here's what I want to do:

I have a LAN with 5 computers namely PC1, PC2, PC3, PC4 and laptop (as the
network admin PC). Now, since I don't have a real server, all my files are
stored in my laptop. My back-end is stored in my laptop and the front-end are
in PC1, PC2, PC3, and PC4. Of course, when my laptop is not online, my users
cannot use the front-end.

Is it possible for my users to use the front-end, store the data in a
temporary table, then update my back-end files when my laptop is back online?
If its possible, how to write a code that automatically update my back-end
files or table?

Please help!

Thank you very much!

Resty

 

[Douglas J. Steele]

Look into Replication. Start at
http://office.microsoft.com/en-us/access/CH062526841033.aspx

Note that this is a fairly complicated topic!

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"Last user''''s name that modified a reco"

 

[Guest]

Hi, Mr. Steele! Thanks for the prompt reply. However, as I skim the article
you suggested, I find the process a little complicated. I think I have to
study the article further. Will post again what might come out with my
replicating my databases.

Again, thank you very much and more power to you, Sir!

Resty

 

[Tony Toews [MVP]]

Last user''''s name that modified a reco

I have an access database and it works well. I have a front-end and a
back-end. Now here's what I want to do:

I have a LAN with 5 computers namely PC1, PC2, PC3, PC4 and laptop (as the
network admin PC). Now, since I don't have a real server, all my files are
stored in my laptop. My back-end is stored in my laptop and the front-end are
in PC1, PC2, PC3, and PC4. Of course, when my laptop is not online, my users
cannot use the front-end.

Is it possible for my users to use the front-end, store the data in a
temporary table, then update my back-end files when my laptop is back online?
If its possible, how to write a code that automatically update my back-end
files or table?

Why not put the BE on PC1?

Replication is not for the faint of heart.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/