Re: Saving A database to the desktop

Yes each time a user wants to access the database they will need to save
over the current database

Thanks for your time

"Steve Schapel" wrote:

Ram,

You mean the whole application including the data will be on the local
machine? So that means any data entry/editing that is done locally
needs to be re-synchronised with everyone else's?

--
Steve Schapel, Microsoft Access MVP

ram wrote:
Hi to All,

I would like help with the following question:

Currently I have a database located on a share drive. 500 different user
located throughout the country access this database. Their complaint is the
database takes to long to open and after it does open it takes to long for
the forms to load and retrive data.

When I have the users drag the database to their desktop and then open the
database it opens quickly and things work fine.

Is there a way to create a Macro that would automaticlly save the database
to their desktop after they double click on the database to open it?

I would like the following to happen:
1. User open the share drive
2. User double clics on the database to open it
3. A copy of the database is copied to the user desktop
4. The user open the copied databse from the desktop


Thanks in advance fro any help or suggestion

Ram





.

Relevant Pages

  • Re: Tracking Log In and Log Out times of Users
    ... The fact that the database is on the server should be irrelevant. ... Type mismatch and then highlights Set rst = ... On my startup form, (that opens every time the database is open, ... I then went to the load ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • Re: Code causes error 2486 in access 2000, IPF in 2002
    ... Compact the database to get rid of this junk: ... Allen Browne - Microsoft MVP. ... Windows 98 machine. ... update queries and opens another form - ...
    (microsoft.public.access.formscoding)
  • Re: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)
  • Re: security wizard cannot be run
    ... You need to open your database using your secured mdw (i.e. the desktop ... Open Access (not via the shortcut). ... Create a new mdb and import everything from your 'secure' mdb. ... Once the database opens, the ...
    (microsoft.public.access.security)