"bare" db1 File

I have created a .db1 (where is the name given to
the database) Access database that is being used in multi-user mode.
When the .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 .db1 file to another directory without
affecting the operation of the database.

Re: "bare" db1 File

On Nov 27, 10:42 pm, Don Calloway wrote:
> I have created a .db1 (where is the name given to
> the database) Access database that is being used in multi-user mode.
> When the .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 .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.

Re: "bare" db1 File

On Tue, 27 Nov 2007 22:25:02 -0800, lyle wrote:

> On Nov 27, 10:42 pm, Don Calloway wrote:
>> I have created a .db1 (where is the name given to
>> the database) Access database that is being used in multi-user mode.
>> When the .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 .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.

Re: "bare" db1 File

On Tue, 27 Nov 2007 22:25:02 -0800, lyle wrote:

> On Nov 27, 10:42 pm, Don Calloway wrote:
>> I have created a .db1 (where is the name given to
>> the database) Access database that is being used in multi-user mode.
>> When the .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 .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 .ldb file. Removing it from the
folder where the .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 .db1 file. Usually this phenomenon
occurs when the .db1 files grows to nearly twice its compressed
size. I have the database set to compress on exit.

Re: "bare" db1 File

"Don Calloway" wrote 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

Re: "bare" db1 File

On Wed, 28 Nov 2007 12:36:57 -0000, "Keith Wilby"
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" wrote 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

Re: "bare" db1 File

On Wed, 28 Nov 2007 07:01:58 -0700, Tom van Stiphout wrote:

> On Wed, 28 Nov 2007 12:36:57 -0000, "Keith Wilby"
> 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" wrote 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 .db1 and
the "bare" db1 file at the same time.

Re: "bare" db1 File

"Don Calloway" wrote 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 .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.

Re: "bare" db1 File

Keith Wilby wrote:

> "Don Calloway" wrote 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 .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.

Re: "bare" db1 File

On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:

>Keith Wilby wrote:
>
>> "Don Calloway" wrote 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 .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.

Re: "bare" db1 File

On Thu, 29 Nov 2007 11:48:12 +0000, Keith Wilby wrote:

> "Don Calloway" wrote 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 .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.

Re: "bare" db1 File

On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:

> On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>
>>Keith Wilby wrote:
>>
>>> "Don Calloway" wrote 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 .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?

Re: "bare" db1 File

On Nov 30, 7:11 am, Don Calloway wrote:
> On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
> > On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>
> >>Keith Wilby wrote:
>
> >>> "Don Calloway" wrote 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 .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.

Re: "bare" db1 File

On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:

>Keith Wilby wrote:
>
>> "Don Calloway" wrote 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
--

Re: "bare" db1 File

On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:

> On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>
>>Keith Wilby wrote:
>>
>>> "Don Calloway" wrote 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.

Re: "bare" db1 File

On Fri, 30 Nov 2007 04:25:57 -0800, lyle wrote:

> On Nov 30, 7:11 am, Don Calloway wrote:
>> On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
>> > On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>>
>> >>Keith Wilby wrote:
>>
>> >>> "Don Calloway" wrote 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 .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.

Re: "bare" db1 File

On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway
wrote:

>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>
>> On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>>
>>>Keith Wilby wrote:
>>>
>>>> "Don Calloway" wrote 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.

Re: "bare" db1 File

On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway
wrote:

>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>
>> On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>>
>>>Keith Wilby wrote:
>>>
>>>> "Don Calloway" wrote 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/

Re: "bare" db1 File

On Fri, 30 Nov 2007 12:00:23 GMT, Don Calloway
wrote:

>On Thu, 29 Nov 2007 11:48:12 +0000, Keith Wilby wrote:
>
>> "Don Calloway" wrote 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 .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/

Re: "bare" db1 File

On Sat, 01 Dec 2007 08:24:37 -0600, Charlie Hoffpauir
wrote:

>On Fri, 30 Nov 2007 12:00:23 GMT, Don Calloway
> wrote:
>
>>On Thu, 29 Nov 2007 11:48:12 +0000, Keith Wilby wrote:
>>
>>> "Don Calloway" wrote 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 .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.

Re: "bare" db1 File

On Dec 1, 6:56 am, Don Calloway wrote:
> On Fri, 30 Nov 2007 04:25:57 -0800, lyle wrote:
> > On Nov 30, 7:11 am, Don Calloway wrote:
> >> On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
> >> > On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>
> >> >>Keith Wilby wrote:
>
> >> >>> "Don Calloway" wrote 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 .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.as pas
> > 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.

Re: "bare" db1 File

On Sat, 01 Dec 2007 08:21:16 -0600, Charlie Hoffpauir wrote:

> On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway
> wrote:
>
>>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>>
>>> On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>>>
>>>>Keith Wilby wrote:
>>>>
>>>>> "Don Calloway" wrote 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.

Re: "bare" db1 File

On Sat, 01 Dec 2007 13:25:05 +0000, Arch wrote:

> On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway
> wrote:
>
>>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>>
>>> On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>>>
>>>>Keith Wilby wrote:
>>>>
>>>>> "Don Calloway" wrote 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.

Re: "bare" db1 File

On Sat, 01 Dec 2007 07:39:35 -0800, lyle wrote:

> On Dec 1, 6:56 am, Don Calloway wrote:
>> On Fri, 30 Nov 2007 04:25:57 -0800, lyle wrote:
>> > On Nov 30, 7:11 am, Don Calloway wrote:
>> >> On Thu, 29 Nov 2007 18:56:11 -0500, Arch wrote:
>> >> > On Thu, 29 Nov 2007 12:27:45 -0800, Salad
>> >> > wrote:
>>
>> >> >>Keith Wilby wrote:
>>
>> >> >>> "Don Calloway" wrote 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
>> >> >>>> .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.as pas
>> > 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?

Re: "bare" db1 File

"Don Calloway" schreef in bericht =
news:UZb4j.10731$AX6.7848@trnddc07...
=20
> What is clear is that anyone who posts follow up quips verses =
legitimate=20
> assistance in newsgroups with the sole intent of evoking a laugh =
should=20
> keep their rye humor to themselves and let people who really wish to=20
> 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...=20

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

Arno R

Re: "bare" db1 File

On Sat, 01 Dec 2007 16:04:40 GMT, Don Calloway
wrote:

>On Sat, 01 Dec 2007 13:25:05 +0000, Arch wrote:
>
>> On Sat, 01 Dec 2007 11:47:52 GMT, Don Calloway
>> wrote:
>>
>>>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>>>
>>>> On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>>>>
>>>>>Keith Wilby wrote:
>>>>>
>>>>>> "Don Calloway" wrote 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.

Open up Windows Explorer. On the menu, choose Tools, then Folder
Options. When the Folder Options dialog appears, choose the View tab.
Near the center of the tab that appears, you will see a little window
titled Advanced Settings:. Approximately 12 lines from the top, you
will see "Hide extensions for known file types". Clear the check box
for this line. Click OK, then go back to Windows Explorer and examine
the folder that contains your database file.

HTH,
Arch

Re: "bare" db1 File

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
>>wrote:
>>
>>
>>>On Fri, 30 Nov 2007 17:41:40 -0500, Chuck wrote:
>>>
>>>
>>>>On Thu, 29 Nov 2007 12:27:45 -0800, Salad wrote:
>>>>
>>>>
>>>>>Keith Wilby wrote:
>>>>>
>>>>>
>>>>>>"Don Calloway" wrote 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".

Re: "bare" db1 File

Don Calloway wrote:

>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/

Re: "bare" db1 File

Don Calloway wrote in
news:9Bf4j.10983$AX6.3181@trnddc07:

> 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.

You're either a troll or an idiot.

Anyone with passing familiarity with Access would know:

1. the default extension for Access databases is MDB.

2. if the extension is DB1 then somebody has renamed the file,
either manually or programatically.

3. if you use the Windows default settings, you won't see registered
file extensions displayed.

4. when you compact an MDB, a temporary file is created named
DB1.MDB. If you have file extensions turned off, you'll see only
DB1.

5. if someone is using the MDB when it is compacted, the DB1.MDB
will persist, since the original file can't be deleted in order for
the DB1.MDB file to be renamed to the original file name.

You've been told all of these things, yet, you never seem to
actually check any of the things you're told.

Thus, I can only conclude:

You are either a Don Mellon-style troll, or a complete blithering
idiot.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/