Re: Homegrown synchronization

"rdemyan" <rdemyan@xxxxxxxxxxx> wrote in
news:1168111230.478856.325780@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

You mentioned a number of posts back about using TransferDatabase
instead of FileCopy to essentially make a copy of a backend
database even if it is in use. I've posted in a couple of forums
about a problem I'm having with this, but haven't received a reply
after a couple of days. Here's the link:

http://groups.google.com/group/comp.databases.ms-access/browse_thre
ad/thread/1381cad360898c8/b675afa35b590f9c?lnk=gst&q=rdemyan&rnum=1
#b675afa35b590f9c

Any suggestions you might have are greatly appreciated.

Another option is to simply append the records to empty tables in a
shell MDB that is appropriately secured.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Using Visual Basic Net as front end - Access as back end
    ... really powerful machine to run the database front-end, ... I originally wanted to have the backend located in the California ... I could not have just one backend database it took Florida ... Report as the report writer and Access as the ...
    (microsoft.public.access.formscoding)
  • Re: Why does splitting a mdb make it slower?
    ... In one form that opens as a continous form, the data looks like it is being repainted as it displays...you can see each row being created quickly. ... I created a table on the backend called KeepOpen. ... performance when opening the main database and opening tables and forms, by forcing the linked database to remain open." ... The folder name is 8 characters in length. ...
    (comp.databases.ms-access)
  • Re: Distribution of a split db as a runtime
    ... I have a database that I plan to ... make installation package with the packaging wizard, ... it should find the backend automatically but if not add ... Dim Tdfs As TableDefs ...
    (microsoft.public.access.devtoolkits)
  • Re: Using Visual Basic Net as front end - Access as back end
    ... Currently I am using Access 2002 I developed an inventory tracking database, which this database is used in California and in Florida. ... Unfortunately, I could not have just one backend database it took Florida about 40 to 50 seconds or longer to open up a form and about 2 minutes or more to open up a report, which the backend was in California. ... We are on a budget like most IT shops and I thought using the combination of Visual Basic net, Crystal Reports, Access will be the least expensive way to go. ...
    (microsoft.public.access.formscoding)
  • Re: Set password for modification
    ... I realize that anyone can easily hack my password but that ... > It sounds to me like you've set a database password on the backend. ... >>> file from the master FE db and distribute the .mde file to your ...
    (microsoft.public.access.security)
Loading