MS access 2007 creates a copy when I close it
I have a database which is located on my server in a shared company folder.
When one of my end users opens the database and then closes it, I
automatically have a copy of the database with a new name. The first time he
opens it, it names itself database, the 2nd time he opens and then closes it,
it makes another copy is is called database1, and this continues this way all
day. By the end of the day I might have 10 or more copies of the database.
This only happens with the one user. Can anyone help me with this please....
--
Beth Brock
.
Relevant Pages
- Re: SetOption "Default Database Directory"
... As I said it works except for the first time the database opens and is set ... even with the rowsource problem solved. ... Database and reopen it and the form, ...
(microsoft.public.access.formscoding) - Re: Capture of First Use Date
... Here is another alternative done completely within the database. ... created when the main form opens. ... the first time the application is used. ... >> Where do you want to store it? ...
(microsoft.public.access.forms) - 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) |
|
