Avatar billede Slettet bruger
28. april 2001 - 18:10 Der er 5 kommentarer og
1 løsning

Opdatering af access-db fra to eksterne brugere

Skal have lavet en central database der kan opdateres af to eksterne uafhængige brugere via email eller diskette. Er der nogen der kender en god måde at gøre det muligt på ?
Avatar billede Slettet bruger
28. april 2001 - 18:16 #1
...og også den anden vej .
Avatar billede terry Ekspert
30. april 2001 - 13:08 #2
look at Database Replication
Avatar billede Slettet bruger
01. maj 2001 - 00:37 #3
Hej .. How can it be done with a replication. Is it not just a copy.
/agerskov.
Avatar billede terry Ekspert
01. maj 2001 - 08:08 #4
I understood your question to mean that the other users also had the same database on another PC and you want to sycronize databases. If this is correct then Replication can be used for this although its best to design the database with this in mind.

From Access HELP:
The process of updating two replicas in which all updated records and objects are exchanged. The exchange of data between two replicas can be one-way or two-way and may be handled by a Synchronizer.

If its just a case of getting some data in or out then use Import and Export.

Avatar billede Slettet bruger
03. maj 2001 - 21:33 #5
Thanks for your hint - it works, but if You think the best way to do it is in the design of the db, what are the requirements(rougly).
Avatar billede terry Ekspert
06. juni 2001 - 08:27 #6
When a databases is converted to a replicated database a number of changes are made to it. Some you dont need to think about and others you do. For example, Autonumber fields are changed from incremental to random, which consequently can have consequences for reports which use this field for sorting.

If you intend using replication then I would suggest that you purchase a book. Also Access does have quite a bit of help on the subject.

It could save you quite a bit of work!
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester