By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,099 Members | 2,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,099 IT Pros & Developers. It's quick & easy.

"bare" db1 File

P: n/a
I have created a <filename>.db1 (where <filenameis the name given to
the database) Access database that is being used in multi-user mode.
When the <filename>.db1 file is opened by a user, the corresponding
locking file appears in the Windows Explorer view pane as well as
expected. Occasionally, a "bare" db1 file (extension only without a
filename) appears in the Windows Explorer window. Can anyone tell me
what that file is and what it does? I can tell you that it doesn't
appear to have any function since I can move it from the Windows Explorer
view pane containing the <filename>.db1 file to another directory without
affecting the operation of the database.
Nov 28 '07 #1
Share this Question
Share on Google+
26 Replies


P: n/a
On Nov 27, 10:42 pm, Don Calloway <drcallo...@verizon.netwrote:
I have created a <filename>.db1 (where <filenameis the name given to
the database) Access database that is being used in multi-user mode.
When the <filename>.db1 file is opened by a user, the corresponding
locking file appears in the Windows Explorer view pane as well as
expected. Occasionally, a "bare" db1 file (extension only without a
filename) appears in the Windows Explorer window. Can anyone tell me
what that file is and what it does? I can tell you that it doesn't
appear to have any function since I can move it from the Windows Explorer
view pane containing the <filename>.db1 file to another directory without
affecting the operation of the database.
http://support.microsoft.com/kb/208778 tells about ldb files. So do
the 3740 previous posts about them here in CDMA.

Is there a reason that you changed the default extension file
extension from mdb to db1? I don't know of any large reason why you
should not. But I advise you to keep the file well backed-up. Another
user could be forgiven for not realizing such a file was an Access/JET
db and doing something (just about anything) to it that would corrupt
it so that your Data and Access objects were gone forever.
Nov 28 '07 #2

P: n/a
On Tue, 27 Nov 2007 22:25:02 -0800, lyle wrote:
On Nov 27, 10:42 pm, Don Calloway <drcallo...@verizon.netwrote:
>I have created a <filename>.db1 (where <filenameis the name given to
the database) Access database that is being used in multi-user mode.
When the <filename>.db1 file is opened by a user, the corresponding
locking file appears in the Windows Explorer view pane as well as
expected. Occasionally, a "bare" db1 file (extension only without a
filename) appears in the Windows Explorer window. Can anyone tell me
what that file is and what it does? I can tell you that it doesn't
appear to have any function since I can move it from the Windows
Explorer view pane containing the <filename>.db1 file to another
directory without affecting the operation of the database.

http://support.microsoft.com/kb/208778 tells about ldb files. So do the
3740 previous posts about them here in CDMA.

Is there a reason that you changed the default extension file extension
from mdb to db1? I don't know of any large reason why you should not.
But I advise you to keep the file well backed-up. Another user could be
forgiven for not realizing such a file was an Access/JET db and doing
something (just about anything) to it that would corrupt it so that your
Data and Access objects were gone forever.
Actually, the file is an Office Access 2003 (Access 2002) formatted
file. I didn't change the file extension.
Nov 28 '07 #3

P: n/a
On Tue, 27 Nov 2007 22:25:02 -0800, lyle wrote:
On Nov 27, 10:42 pm, Don Calloway <drcallo...@verizon.netwrote:
>I have created a <filename>.db1 (where <filenameis the name given to
the database) Access database that is being used in multi-user mode.
When the <filename>.db1 file is opened by a user, the corresponding
locking file appears in the Windows Explorer view pane as well as
expected. Occasionally, a "bare" db1 file (extension only without a
filename) appears in the Windows Explorer window. Can anyone tell me
what that file is and what it does? I can tell you that it doesn't
appear to have any function since I can move it from the Windows
Explorer view pane containing the <filename>.db1 file to another
directory without affecting the operation of the database.

http://support.microsoft.com/kb/208778 tells about ldb files. So do the
3740 previous posts about them here in CDMA.

Is there a reason that you changed the default extension file extension
from mdb to db1? I don't know of any large reason why you should not.
But I advise you to keep the file well backed-up. Another user could be
forgiven for not realizing such a file was an Access/JET db and doing
something (just about anything) to it that would corrupt it so that your
Data and Access objects were gone forever.
I just realized there may have been some confusion between my comments
regarding the locking file (ldb) and the "bare" db1 file I referred to.
I'm not referring to the locking file when I refer to the "bare".db1
file. The "bare" db1 file will periodically appear for unknown reasons,
in addition to the usual <filename>.ldb file. Removing it from the
folder where the <filename>.db1 file resides has no effect on that file.
One characteristic of the appearance of the "bare" db1 file is the
increased size of the <filename>.db1 file. Usually this phenomenon
occurs when the <filename>.db1 files grows to nearly twice its compressed
size. I have the database set to compress on exit.
Nov 28 '07 #4

P: n/a
"Don Calloway" <dr********@verizon.netwrote in message
news:kEc3j.43646$Xg.24908@trnddc06...
On Tue, 27 Nov 2007 22:25:02 -0800, lyle wrote:

I have the database set to compress on exit.
The compact action creates a new db file - could that be what you're seeing?

Keith.
www.keithwilby.com

Nov 28 '07 #5

P: n/a
On Wed, 28 Nov 2007 12:36:57 -0000, "Keith Wilby" <he**@there.com>
wrote:

And could it be that the file is "bare" (most likely meaning: without
an extension) because that's how you have configured Windows Explorer:
to display files without extensions? Uncheck Tools Options View >
Hide extensions for known file types.

-Tom.
>"Don Calloway" <dr********@verizon.netwrote in message
news:kEc3j.43646$Xg.24908@trnddc06...
>On Tue, 27 Nov 2007 22:25:02 -0800, lyle wrote:

I have the database set to compress on exit.

The compact action creates a new db file - could that be what you're seeing?

Keith.
www.keithwilby.com
Nov 28 '07 #6

P: n/a
On Wed, 28 Nov 2007 07:01:58 -0700, Tom van Stiphout wrote:
On Wed, 28 Nov 2007 12:36:57 -0000, "Keith Wilby" <he**@there.com>
wrote:

And could it be that the file is "bare" (most likely meaning: without an
extension) because that's how you have configured Windows Explorer: to
display files without extensions? Uncheck Tools Options View Hide
extensions for known file types.

-Tom.
>>"Don Calloway" <dr********@verizon.netwrote in message
news:kEc3j.43646$Xg.24908@trnddc06...
>>On Tue, 27 Nov 2007 22:25:02 -0800, lyle wrote:

I have the database set to compress on exit.

The compact action creates a new db file - could that be what you're
seeing?

Keith.
www.keithwilby.com
The "bare" db1 file sometimes appears while the database is being used
and before the database is compacted. I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1 and
the "bare" db1 file at the same time.
Nov 29 '07 #7

P: n/a
"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>
The "bare" db1 file sometimes appears while the database is being used
and before the database is compacted.
Perhaps it's a completely unrelated file being created by another user or
process.
I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1 and
the "bare" db1 file at the same time.
Not sure I understand what you're saying there Don. Viewing file extensions
would certainly aid the investigative process.

Keith.

Nov 29 '07 #8

P: n/a
Keith Wilby wrote:
"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>
The "bare" db1 file sometimes appears while the database is being used
and before the database is compacted.


Perhaps it's a completely unrelated file being created by another user
or process.
>I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1 and
the "bare" db1 file at the same time.


Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.

Keith.
I read from what I think was the initial post
"Occasionally, a "bare" db1 file (extension only without a filename)
appears in the Windows Explorer window."

I took that to mean he sees a file like
.mdb
without a filename. Which would appear to be odd.
Nov 29 '07 #9

P: n/a
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:
>Keith Wilby wrote:
>"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>>
The "bare" db1 file sometimes appears while the database is being used
and before the database is compacted.


Perhaps it's a completely unrelated file being created by another user
or process.
>>I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1 and
the "bare" db1 file at the same time.


Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.

Keith.

I read from what I think was the initial post
"Occasionally, a "bare" db1 file (extension only without a filename)
appears in the Windows Explorer window."

I took that to mean he sees a file like
.mdb
without a filename. Which would appear to be odd.

There definitely seems to be some sort of communication problem here.
Don has posted 4 messages in this thread and still no one knows what
he means by a "bare" db1 file.

My guess is that he is seeing db1.mdb but has "Hide extensions for
known file types" checked in Windows Explorer.
Nov 30 '07 #10

P: n/a
On Thu, 29 Nov 2007 11:48:12 +0000, Keith Wilby wrote:
"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>
The "bare" db1 file sometimes appears while the database is being used
and before the database is compacted.

Perhaps it's a completely unrelated file being created by another user
or process.
>I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1 and
the "bare" db1 file at the same time.

Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.

Keith.
What I'm saying is, contrary to what the previous poster said, I do not
have my system set up to view just file extension. I can view filenames
and extensions at the same time. Hope this is clearer.
Nov 30 '07 #11

P: n/a
On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:
>>Keith Wilby wrote:
>>"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
The "bare" db1 file sometimes appears while the database is being
used and before the database is compacted.
Perhaps it's a completely unrelated file being created by another user
or process.

I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1
and the "bare" db1 file at the same time.
Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.

Keith.

I read from what I think was the initial post "Occasionally, a "bare"
db1 file (extension only without a filename) appears in the Windows
Explorer window."

I took that to mean he sees a file like
.mdb
without a filename. Which would appear to be odd.


There definitely seems to be some sort of communication problem here.
Don has posted 4 messages in this thread and still no one knows what he
means by a "bare" db1 file.

My guess is that he is seeing db1.mdb but has "Hide extensions for known
file types" checked in Windows Explorer.
No. Not at all. There is a communication issue here. What I'm saying
is this: First, I can see both filenames and file extensions in my
Explorer view. When I go to the directory on the network server where my
database resides, I can see its filename and extension. Let's say the
program is myprog.db1. As soon as someone opens the file for use in
shared mode, the locking file myprog.ldb appears as expected. However,
what happens occasionally after the program has been in use for a while--
this doesn't happen all the time--is a file appears with no filename in
the same directory on the server. This file is named "db1," without the
quotes. In other words, there is no filename (bare), just the db1
extension. I have no idea what this file is, but removing it has no
affect on the database's performanc. One noted characteristic of the
appearance of this db1 file is an unexpected enlargement in the size of
myprog.db1 file. It is usually around twice its normal, compacted size
when this db1 file appears. Does anybody have a clue as to what might be
causing this and what it means?
Nov 30 '07 #12

P: n/a
On Nov 30, 7:11 am, Don Calloway <drcallo...@verizon.netwrote:
On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <o...@vinegar.comwrote:
>Keith Wilby wrote:
>"Don Calloway" <drcallo...@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>The "bare" db1 file sometimes appears while the database is being
used and before the database is compacted.
>Perhaps it's a completely unrelated file being created by another user
or process.
>>I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1
and the "bare" db1 file at the same time.
>Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.
>Keith.
>I read from what I think was the initial post "Occasionally, a "bare"
db1 file (extension only without a filename) appears in the Windows
Explorer window."
>I took that to mean he sees a file like
.mdb
without a filename. Which would appear to be odd.
There definitely seems to be some sort of communication problem here.
Don has posted 4 messages in this thread and still no one knows what he
means by a "bare" db1 file.
My guess is that he is seeing db1.mdb but has "Hide extensions for known
file types" checked in Windows Explorer.

No. Not at all. There is a communication issue here. What I'm saying
is this: First, I can see both filenames and file extensions in my
Explorer view. When I go to the directory on the network server where my
database resides, I can see its filename and extension. Let's say the
program is myprog.db1. As soon as someone opens the file for use in
shared mode, the locking file myprog.ldb appears as expected. However,
what happens occasionally after the program has been in use for a while--
this doesn't happen all the time--is a file appears with no filename in
the same directory on the server. This file is named "db1," without the
quotes. In other words, there is no filename (bare), just the db1
extension. I have no idea what this file is, but removing it has no
affect on the database's performanc. One noted characteristic of the
appearance of this db1 file is an unexpected enlargement in the size of
myprog.db1 file. It is usually around twice its normal, compacted size
when this db1 file appears. Does anybody have a clue as to what might be
causing this and what it means?
It's clear to me that You and Your instance of Access have been given
magical powers by some higher being. We can only pray that they will
be used to combat War, Poverty and Televised Cialis Commercials.

I can recommend http://www.irishtinker.com/sweaters/images/capes.asp
as a good place to get Your cape.
Nov 30 '07 #13

P: n/a
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:
>Keith Wilby wrote:
>"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>>
The "bare" db1 file sometimes appears while the database is being used
and before the database is compacted.
Just curious, what type of file can have a .db1 extension?

Chuck
--
Nov 30 '07 #14

P: n/a
On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:
>>Keith Wilby wrote:
>>"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
The "bare" db1 file sometimes appears while the database is being
used and before the database is compacted.
Just curious, what type of file can have a .db1 extension?

Chuck
MS Access 2000 file format has this extension.
Dec 1 '07 #15

P: n/a
On Fri, 30 Nov 2007 04:25:57 -0800, lyle wrote:
On Nov 30, 7:11 am, Don Calloway <drcallo...@verizon.netwrote:
>On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <o...@vinegar.comwrote:
>>Keith Wilby wrote:
>>"Don Calloway" <drcallo...@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>>The "bare" db1 file sometimes appears while the database is being
used and before the database is compacted.
>>Perhaps it's a completely unrelated file being created by another
user or process.
>>>I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1
and the "bare" db1 file at the same time.
>>Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.
>>Keith.
>>I read from what I think was the initial post "Occasionally, a "bare"
db1 file (extension only without a filename) appears in the Windows
Explorer window."
>>I took that to mean he sees a file like
.mdb
without a filename. Which would appear to be odd.
There definitely seems to be some sort of communication problem here.
Don has posted 4 messages in this thread and still no one knows what
he means by a "bare" db1 file.
My guess is that he is seeing db1.mdb but has "Hide extensions for
known file types" checked in Windows Explorer.

No. Not at all. There is a communication issue here. What I'm saying
is this: First, I can see both filenames and file extensions in my
Explorer view. When I go to the directory on the network server where
my database resides, I can see its filename and extension. Let's say
the program is myprog.db1. As soon as someone opens the file for use
in shared mode, the locking file myprog.ldb appears as expected.
However, what happens occasionally after the program has been in use
for a while-- this doesn't happen all the time--is a file appears with
no filename in the same directory on the server. This file is named
"db1," without the quotes. In other words, there is no filename
(bare), just the db1 extension. I have no idea what this file is, but
removing it has no affect on the database's performanc. One noted
characteristic of the appearance of this db1 file is an unexpected
enlargement in the size of myprog.db1 file. It is usually around twice
its normal, compacted size when this db1 file appears. Does anybody
have a clue as to what might be causing this and what it means?

It's clear to me that You and Your instance of Access have been given
magical powers by some higher being. We can only pray that they will be
used to combat War, Poverty and Televised Cialis Commercials.

I can recommend http://www.irishtinker.com/sweaters/images/capes.asp as
a good place to get Your cape.
What is clear is that anyone who posts follow up quips verses legitimate
assistance in newsgroups with the sole intent of evoking a laugh should
keep their rye humor to themselves and let people who really wish to
assist others post their responses here.
Dec 1 '07 #16

P: n/a
On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway
<dr********@verizon.netwrote:
>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:
>>>Keith Wilby wrote:

"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
The "bare" db1 file sometimes appears while the database is being
used and before the database is compacted.
Just curious, what type of file can have a .db1 extension?

Chuck

MS Access 2000 file format has this extension.
Not normally. It is normally .mdb.
Dec 1 '07 #17

P: n/a
On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway
<dr********@verizon.netwrote:
>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:
>>>Keith Wilby wrote:

"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
The "bare" db1 file sometimes appears while the database is being
used and before the database is compacted.
Just curious, what type of file can have a .db1 extension?

Chuck

MS Access 2000 file format has this extension.
No. I'm running MS Access 2000 and the file extension is .mdb. Always
has been. The only time I see anything like db1 is when Access creates
a database file for me. The first one is named db1.mdb, the second one
db2.mdb, etc. Tha'ts why most readers of your post think you have
"display file extensions" turned off. with extensions off, the first
file created would look like db1 without an extension.

--
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/
Dec 1 '07 #18

P: n/a
On Fri, 30 Nov 2007 12:00:23 GMT, Don Calloway
<dr********@verizon.netwrote:
>On Thu, 29 Nov 2007 11:48:12 +0000, Keith Wilby wrote:
>"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>>
The "bare" db1 file sometimes appears while the database is being used
and before the database is compacted.

Perhaps it's a completely unrelated file being created by another user
or process.
>>I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1 and
the "bare" db1 file at the same time.

Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.

Keith.

What I'm saying is, contrary to what the previous poster said, I do not
have my system set up to view just file extension. I can view filenames
and extensions at the same time. Hope this is clearer.
It's still not clear because of the way you reply. You say "I do not
have my system set up to view just file extensions..." What we'd like
to see you say is "I do not have my system set up to view files
without displaying extensions".

What I'd really like to see is for you to post a view of your explorer
showing the file list you're writing about.

--
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/
Dec 1 '07 #19

P: n/a
On Sat, 01 Dec 2007 08:24:37 -0600, Charlie Hoffpauir
<in*****@invalid.comwrote:
>On Fri, 30 Nov 2007 12:00:23 GMT, Don Calloway
<dr********@verizon.netwrote:
>>On Thu, 29 Nov 2007 11:48:12 +0000, Keith Wilby wrote:
>>"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...

The "bare" db1 file sometimes appears while the database is being used
and before the database is compacted.

Perhaps it's a completely unrelated file being created by another user
or process.

I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1 and
the "bare" db1 file at the same time.

Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.

Keith.

What I'm saying is, contrary to what the previous poster said, I do not
have my system set up to view just file extension. I can view filenames
and extensions at the same time. Hope this is clearer.

It's still not clear because of the way you reply. You say "I do not
have my system set up to view just file extensions..." What we'd like
to see you say is "I do not have my system set up to view files
without displaying extensions".

What I'd really like to see is for you to post a view of your explorer
showing the file list you're writing about.
Or, alternatively, open a cmd window and do a dir. Paste the results
into a post here.
Dec 1 '07 #20

P: n/a
On Dec 1, 6:56 am, Don Calloway <drcallo...@verizon.netwrote:
On Fri, 30 Nov 2007 04:25:57 -0800, lyle wrote:
On Nov 30, 7:11 am, Don Calloway <drcallo...@verizon.netwrote:
On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <o...@vinegar.comwrote:
>Keith Wilby wrote:
>"Don Calloway" <drcallo...@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>The "bare" db1 file sometimes appears while the database is being
used and before the database is compacted.
>Perhaps it's a completely unrelated file being created by another
user or process.
>>I also don't have the system set
to view extensions only because I'm able to see the <filename>.db1
and the "bare" db1 file at the same time.
>Not sure I understand what you're saying there Don. Viewing file
extensions would certainly aid the investigative process.
>Keith.
>I read from what I think was the initial post "Occasionally, a "bare"
db1 file (extension only without a filename) appears in the Windows
Explorer window."
>I took that to mean he sees a file like
.mdb
without a filename. Which would appear to be odd.
There definitely seems to be some sort of communication problem here.
Don has posted 4 messages in this thread and still no one knows what
he means by a "bare" db1 file.
My guess is that he is seeing db1.mdb but has "Hide extensions for
known file types" checked in Windows Explorer.
No. Not at all. There is a communication issue here. What I'm saying
is this: First, I can see both filenames and file extensions in my
Explorer view. When I go to the directory on the network server where
my database resides, I can see its filename and extension. Let's say
the program is myprog.db1. As soon as someone opens the file for use
in shared mode, the locking file myprog.ldb appears as expected.
However, what happens occasionally after the program has been in use
for a while-- this doesn't happen all the time--is a file appears with
no filename in the same directory on the server. This file is named
"db1," without the quotes. In other words, there is no filename
(bare), just the db1 extension. I have no idea what this file is, but
removing it has no affect on the database's performanc. One noted
characteristic of the appearance of this db1 file is an unexpected
enlargement in the size of myprog.db1 file. It is usually around twice
its normal, compacted size when this db1 file appears. Does anybody
have a clue as to what might be causing this and what it means?
It's clear to me that You and Your instance of Access have been given
magical powers by some higher being. We can only pray that they will be
used to combat War, Poverty and Televised Cialis Commercials.
I can recommendhttp://www.irishtinker.com/sweaters/images/capes.aspas
a good place to get Your cape.

What is clear is that anyone who posts follow up quips verses legitimate
assistance in newsgroups with the sole intent of evoking a laugh should
keep their rye humor to themselves and let people who really wish to
assist others post their responses here.
Recently I haven't been able to post from Google Groups, so I'll use
this opportunity to test that procedure.
Evoking a laugh was not my sole intent. I hoped that you would
understand that what you describe is not anything that I have ever
seen, or imagined as possible. After checking other replies in this
thread, you might have concluded that I am not alone.
From this I thought you might have decided to reconsider what you are
reporting, to rewrite the information more clearly, even to cut and
paste anything that might be helpful, and to cast your mind over the
situation to see if there is some pertinent matter that you have
forgotten to include.
If God said to me, "Lyle, if you can't figure this out it's bye-bye
for you!" I would have to guess. My guesses would include:
1. You're not really seeing what you report, but are a troll, trying
to see if you can store up a little angst here in our group;
2. You're running MS-Access is some unusual environment, perhaps
within Linux and the Wine Windows Compatibility Layer;
3. You're technically challenged/mentally handicapped;
4. English is not your first language.
Unless, of course, He said, "And, if you go, I'm sending you to Red-
Head Heaven"; in which case I would guess:
5. This brilliant person, Don Calloway, is years ahead of me and is
operating at a level too advanced for me to comprehend.
Then I'd spend my remaining time practicing my smile.
Dec 1 '07 #21

P: n/a
On Sat, 01 Dec 2007 08:21:16 -0600, Charlie Hoffpauir wrote:
On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway <dr********@verizon.net>
wrote:
>>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>>On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:

Keith Wilby wrote:

"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>
>
>The "bare" db1 file sometimes appears while the database is being
>used and before the database is compacted.
>
Just curious, what type of file can have a .db1 extension?

Chuck

MS Access 2000 file format has this extension.

No. I'm running MS Access 2000 and the file extension is .mdb. Always
has been. The only time I see anything like db1 is when Access creates a
database file for me. The first one is named db1.mdb, the second one
db2.mdb, etc. Tha'ts why most readers of your post think you have
"display file extensions" turned off. with extensions off, the first
file created would look like db1 without an extension.
I see. The database I have developed is installed at my workplace where
I don't manage the configuration of my PC nor have privileges to make
certain configuration changes. Thanks for the tip.
Dec 1 '07 #22

P: n/a
On Sat, 01 Dec 2007 13:25:05 +0000, Arch wrote:
On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway <dr********@verizon.net>
wrote:
>>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>>On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:

Keith Wilby wrote:

"Don Calloway" <dr********@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>
>
>The "bare" db1 file sometimes appears while the database is being
>used and before the database is compacted.
>
Just curious, what type of file can have a .db1 extension?

Chuck

MS Access 2000 file format has this extension.

Not normally. It is normally .mdb.
I think the problem is that I have my database installed on a server at
my workplace where I don't have control over the default configuration
nor do I have privileges to make certain configuration changes. Thanks
for your assistance.
Dec 1 '07 #23

P: n/a
On Sat, 01 Dec 2007 07:39:35 -0800, lyle wrote:
On Dec 1, 6:56 am, Don Calloway <drcallo...@verizon.netwrote:
>On Fri, 30 Nov 2007 04:25:57 -0800, lyle wrote:
On Nov 30, 7:11 am, Don Calloway <drcallo...@verizon.netwrote:
On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <o...@vinegar.com>
wrote:
>>Keith Wilby wrote:
>>"Don Calloway" <drcallo...@verizon.netwrote in message
news:zlx3j.42167$dh.19768@trnddc05...
>>>The "bare" db1 file sometimes appears while the database is
being used and before the database is compacted.
>>Perhaps it's a completely unrelated file being created by
another user or process.
>>>I also don't have the system set
to view extensions only because I'm able to see the
<filename>.db1 and the "bare" db1 file at the same time.
>>Not sure I understand what you're saying there Don. Viewing
file extensions would certainly aid the investigative process.
>>Keith.
>>I read from what I think was the initial post "Occasionally, a
"bare" db1 file (extension only without a filename) appears in the
Windows Explorer window."
>>I took that to mean he sees a file like
.mdb
without a filename. Which would appear to be odd.
There definitely seems to be some sort of communication problem
here. Don has posted 4 messages in this thread and still no one
knows what he means by a "bare" db1 file.
My guess is that he is seeing db1.mdb but has "Hide extensions for
known file types" checked in Windows Explorer.
>No. Not at all. There is a communication issue here. What I'm
saying is this: First, I can see both filenames and file extensions
in my Explorer view. When I go to the directory on the network
server where my database resides, I can see its filename and
extension. Let's say the program is myprog.db1. As soon as someone
opens the file for use in shared mode, the locking file myprog.ldb
appears as expected. However, what happens occasionally after the
program has been in use for a while-- this doesn't happen all the
time--is a file appears with no filename in the same directory on
the server. This file is named "db1," without the quotes. In other
words, there is no filename (bare), just the db1 extension. I have
no idea what this file is, but removing it has no affect on the
database's performanc. One noted characteristic of the appearance
of this db1 file is an unexpected enlargement in the size of
myprog.db1 file. It is usually around twice its normal, compacted
size when this db1 file appears. Does anybody have a clue as to
what might be causing this and what it means?
It's clear to me that You and Your instance of Access have been given
magical powers by some higher being. We can only pray that they will
be used to combat War, Poverty and Televised Cialis Commercials.
I can recommendhttp://www.irishtinker.com/sweaters/images/capes.aspas
a good place to get Your cape.

What is clear is that anyone who posts follow up quips verses
legitimate assistance in newsgroups with the sole intent of evoking a
laugh should keep their rye humor to themselves and let people who
really wish to assist others post their responses here.

Recently I haven't been able to post from Google Groups, so I'll use
this opportunity to test that procedure. Evoking a laugh was not my sole
intent. I hoped that you would understand that what you describe is not
anything that I have ever seen, or imagined as possible. After checking
other replies in this thread, you might have concluded that I am not
alone. From this I thought you might have decided to reconsider what you
are reporting, to rewrite the information more clearly, even to cut and
paste anything that might be helpful, and to cast your mind over the
situation to see if there is some pertinent matter that you have
forgotten to include.
If God said to me, "Lyle, if you can't figure this out it's bye-bye for
you!" I would have to guess. My guesses would include: 1. You're not
really seeing what you report, but are a troll, trying to see if you can
store up a little angst here in our group; 2. You're running MS-Access
is some unusual environment, perhaps within Linux and the Wine Windows
Compatibility Layer; 3. You're technically challenged/mentally
handicapped; 4. English is not your first language. Unless, of course,
He said, "And, if you go, I'm sending you to Red- Head Heaven"; in
which case I would guess: 5. This brilliant person, Don Calloway, is
years ahead of me and is operating at a level too advanced for me to
comprehend. Then I'd spend my remaining time practicing my smile.
I believe the problem I'm having is since I have my database installed on
a server at my workplace where I don't have control over certain aspects
of my PC's default configuration nor do I have privileges to make changes
to those aspects, I believe the default extension is .mdb (just can't see
it because it's hidden) so the file that appears is actually db1.mdb.
That makes more sense. So the question becomes this: why is the
db1.mdb file appearing in the same directory as myprog.db1.mdb?
Dec 1 '07 #24

P: n/a

"Don Calloway" <dr********@verizon.netschreef in bericht news:UZb4j.10731$AX6.7848@trnddc07...
What is clear is that anyone who posts follow up quips verses legitimate
assistance in newsgroups with the sole intent of evoking a laugh should
keep their rye humor to themselves and let people who really wish to
assist others post their responses here.
You must be kidding here...
Sometimes a good laugh can make a day...

BTW: Lots of people who are trying to help you, including Lyle.
He asked: "Is there a reason that you changed the default extension file
extension from mdb to db1"??
You did not even answer him...

I would check and double check your file-extension, since it is NOT .db1 by default.
If you have the file <filename.db1then rename the file to <filename.mdband see if your symptom goes away.

Arno R
Dec 1 '07 #25

P: n/a
Don Calloway wrote:
On Sat, 01 Dec 2007 08:21:16 -0600, Charlie Hoffpauir wrote:

>>On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway <dr********@verizon.net>
wrote:

>>>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
On Thu, 29 Nov 2007 12:27:45 -0800, Salad <oi*@vinegar.comwrote:
>Keith Wilby wrote:
>
>
>>"Don Calloway" <dr********@verizon.netwrote in message
>>news:zlx3j.42167$dh.19768@trnddc05...
>>
>>
>>
>>>The "bare" db1 file sometimes appears while the database is being
>>>used and before the database is compacted.
>>
Just curious, what type of file can have a .db1 extension?

Chuck

MS Access 2000 file format has this extension.

No. I'm running MS Access 2000 and the file extension is .mdb. Always
has been. The only time I see anything like db1 is when Access creates a
database file for me. The first one is named db1.mdb, the second one
db2.mdb, etc. Tha'ts why most readers of your post think you have
"display file extensions" turned off. with extensions off, the first
file created would look like db1 without an extension.


I see. The database I have developed is installed at my workplace where
I don't manage the configuration of my PC nor have privileges to make
certain configuration changes. Thanks for the tip.
Maybe somewhere, someplace code is creating a database for you. Maybe a
temp database like Db1. When the code that uses the temp database is
complete it doesn't kill the file...simply leaves it there. Thus you
can kill it later without affecting anything. You might want to do a
search in your code modules for the word "CreateDatabase".
Dec 1 '07 #26

P: n/a
Don Calloway <dr********@verizon.netwrote:
>I believe the problem I'm having is since I have my database installed on
a server at my workplace where I don't have control over certain aspects
of my PC's default configuration nor do I have privileges to make changes
to those aspects, I believe the default extension is .mdb (just can't see
it because it's hidden) so the file that appears is actually db1.mdb.
That makes more sense. So the question becomes this: why is the
db1.mdb file appearing in the same directory as myprog.db1.mdb?
Try right clicking on the file and viewing the properties. Hopefully that will show
the complete file name.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Dec 2 '07 #27

This discussion thread is closed

Replies have been disabled for this discussion.