Help

[aftershokk]

All of the sudden - every time I open one of my databases, a second one is being created with a '1' in the name????

 

[KeithG]

Do you get message stating a backup copy was made?

 

[aftershokk]

no

I never received this message? It just started to do it and I am the admin on all of these DBs???

 

[WayneRyan]

aftershokk,

You probably have some code in your app's startup that does a
Compact/Repair.

When the Compact/Repair finishes, it can't delete the current
database because you're using it. So it adds the "1" to the
DB name.

If you don't delete the "1" version, you'll probably see a
"2" version (and so on).

The "1" version is probably identical, only smaller.

Or maybe the DB Compact/Repairs on exit and for "some reason"
can't delete your original DB file.

hth,
Wayne

 

[aftershokk]

no compacts going on

 

[rainman89]

Are you on a network?

its possible that your modify privledges got messed up somewhere, and you are only allowed to write a new file not modify the existing

 

[WayneRyan]

aftershok,

Can you post a sample of your DB?

You can delete ALL of your tables if you want.
They shouldn't be needed for this.

Wayne

 

[aftershokk]

thanks Wayne

I just fixed it!

I clicked on default settings for the "open with" in the folder option portion of "my computer" and it fixed the issue. Not sure how messed it up in he first place.

thanks to all! cheers!

 

[WayneRyan]

aftershokk,

Glad to see that it's fixed, but I don't know how that could affect things
in the first place.

Oh well ...

Wayne

 

[The_Doc_Man]

Wayne, the "Open With..." dialog means his association between .MDB and Access was broken and something else was trying to open the DB. Of course, that something else had absolutely no clue as to what it was seeing, so opened a new version as a backup.