Weird Problem... MS Access create a copy of the database by itself?

[perryche]

What might cause MS Access to create a copy of the database by
itself?

I have a Front End and a BE on a databse, but, some users, when click
on the short cut, another FE database is created with the exact name
of the FE but with a 1 at the end. i.e. FE "ABC.mdb", then when a
certain user access it, an "ABC1.mdb" is created permanently until I
delete it manually. Then, that same user access it again, another one
is created. What's happening?

Thanks for your help in advance.

Perry

[Allen Browne]

Perry, do you have Compact On Close turned on under your options?

Chances are that the spurious databases are left over as the result of a
faulty compact. Access 2007 can do this, but older versions can too.

In general Compact on Close is not a good idea.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pe******@yahoo.comwrote in message
news:11**********************@o5g2000hsb.googlegro ups.com...

What might cause MS Access to create a copy of the database by
itself?

I have a Front End and a BE on a databse, but, some users, when click
on the short cut, another FE database is created with the exact name
of the FE but with a 1 at the end. i.e. FE "ABC.mdb", then when a
certain user access it, an "ABC1.mdb" is created permanently until I
delete it manually. Then, that same user access it again, another one
is created. What's happening?

Thanks for your help in advance.

Perry

[perryche]

Allen,
Thanks for the fast response. No, I double check, I don't
have compact on close turn on. BTW, this only happen in that
computer, which has a short cut to the network .mdb file. No other
computer does this. Any other idea?

Perry

[Allen Browne]

Sorry: I don't know what's going on.

Presumably you have checked the shortcut to ensure it is not doing anything
odd such as running scripts, or compacting the db.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pe******@yahoo.comwrote in message
news:11*********************@p77g2000hsh.googlegro ups.com...

Allen,
Thanks for the fast response. No, I double check, I don't
have compact on close turn on. BTW, this only happen in that
computer, which has a short cut to the network .mdb file. No other
computer does this. Any other idea?

Perry

[perryche]

On Apr 13, 12:08 pm, "Allen Browne" <[e-mail]>
wrote:

Sorry: I don't know what's going on.

Presumably you have checked the shortcut to ensure it is not doing anything
odd such as running scripts, or compacting the db.

No. In fact, I deleted the short cut and created a new one on that
machine. I never had this happened. My suspcion, because this
machine has been acting up for other things as well, could it be
something wrong with the network setup? It seems this machine as an
outside intruder and made a copy? I am just widely guessing. Thanks
anyway.

Perry

[Larry Linson]

The symptom is that you are copying in a DB which already exists and it is
adding a "1"... does the shortcut retrieve the DB from somewhere before
executing it; or are there conditions under which the database itself may
copy from elsewhere?

Larry Linson
Microsoft Access MVP

<pe******@yahoo.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...

On Apr 13, 12:08 pm, "Allen Browne" <[e-mail]>
wrote:

>Sorry: I don't know what's going on.

Presumably you have checked the shortcut to ensure it is not doing
anything
odd such as running scripts, or compacting the db.

No. In fact, I deleted the short cut and created a new one on that
machine. I never had this happened. My suspcion, because this
machine has been acting up for other things as well, could it be
something wrong with the network setup? It seems this machine as an
outside intruder and made a copy? I am just widely guessing. Thanks
anyway.

Perry

[Chuck Grimsby]

The last time I saw something like this happen, the user was using
Internet Explorer to "open" the database. IE, being a web browser,
was actually "downloading" the database, rather then opening it from
it's network location as you would expect.

In networked situations, the FE should *not* be on the network
anyways, but on the user's computer, but I do tend to see this a lot
where the programmer hopes to have only 1 FE that they can update
whenever they feel like and hope everyone will get a "new" copy of the
FE when they open it. (Sad, but that's not the right way to go about
this.....)

On Apr 13, 10:25 am, [e-mail] wrote:

What might cause MS Access to create a copy of the database by
itself?

I have a Front End and a BE on a databse, but, some users, when click
on the short cut, another FE database is created with the exact name
of the FE but with a 1 at the end. i.e. FE "ABC.mdb", then when a
certain user access it, an "ABC1.mdb" is created permanently until I
delete it manually. Then, that same user access it again, another one
is created. What's happening?

Thanks for your help in advance.

Perry