Usage of db1.mdb file ??

[Mike Thomas]

We are using an Access 2000 application on a Windows NT / Citix server. The
app is split into a front end and back end mdb, and each user has the front
end mdb in their own folder.

Since we have put the front end mdb into each user's folder, I've noticed
the appearance in some of them of db1.mdb, db2.mdb etc.

It seems like these files are created when the users start their
applications, then closed and deleted when they exit the app. I suspect
that these files have been left behind when the server was rebooted while
the application was open for these users.

What is the function of these files and how can they be deleted? Is there
anyway to eliminate this problem short of not rebooting the server?

Many thanks,
Mike Thomas

[Steffen Beck]

Re: Usage of db1.mdb file ??


"Mike Thomas" <mike@ease.co m> skrev i en meddelelse
news:QG7Ub.49$t 16.107998@newss vr28.news.prodi gy.com...[color=blue]
> We are using an Access 2000 application on a Windows NT / Citix server.[/color]
The[color=blue]
> app is split into a front end and back end mdb, and each user has the[/color]
front[color=blue]
> end mdb in their own folder.
>
> Since we have put the front end mdb into each user's folder, I've noticed
> the appearance in some of them of db1.mdb, db2.mdb etc.
>
> It seems like these files are created when the users start their
> applications, then closed and deleted when they exit the app. I suspect
> that these files have been left behind when the server was rebooted while
> the application was open for these users.
>
> What is the function of these files and how can they be deleted? Is there
> anyway to eliminate this problem short of not rebooting the server?
>
> Many thanks,
> Mike Thomas
>
>[/color]

Hi Mike, just a thougt, but are the databases set to be compresed on exit ?

Best regards
Stef

[PC Datasheet]

Re: Usage of db1.mdb file ??

Mike,

The db1.mdb, db2.mdb etc. files are being created because your users are trying
to create new database files. When you try to create a new database, Access
first requires you to create and save a file name for the database. Access
defaults to dbX.mdb for the file name and then provides you an opportunity to
give the file a name of your choice.

Your application apparently displays the Access menu at the top allowing the
users full access to Access as well as the application. If you would put a
custom menu at the top of your aplication, you would no longer see db1.mdb,
db2.mdb etc. because the users could no longer create new databases.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Mike Thomas" <mike@ease.co m> wrote in message
news:QG7Ub.49$t 16.107998@newss vr28.news.prodi gy.com...[color=blue]
> We are using an Access 2000 application on a Windows NT / Citix server. The
> app is split into a front end and back end mdb, and each user has the front
> end mdb in their own folder.
>
> Since we have put the front end mdb into each user's folder, I've noticed
> the appearance in some of them of db1.mdb, db2.mdb etc.
>
> It seems like these files are created when the users start their
> applications, then closed and deleted when they exit the app. I suspect
> that these files have been left behind when the server was rebooted while
> the application was open for these users.
>
> What is the function of these files and how can they be deleted? Is there
> anyway to eliminate this problem short of not rebooting the server?
>
> Many thanks,
> Mike Thomas
>
>[/color]

[Mike Thomas]

Re: Usage of db1.mdb file ??

Stef,

Not bad, yes they are, I had not thought of this. Some are getting left
behind. Is there a reason?

Thanks
Mike Thomas



"Steffen Beck" <srd@srd.dk> wrote in message
news:40215d08$0 $29327$edfadb0f @dread15.news.t ele.dk...[color=blue]
>
> "Mike Thomas" <mike@ease.co m> skrev i en meddelelse
> news:QG7Ub.49$t 16.107998@newss vr28.news.prodi gy.com...[color=green]
> > We are using an Access 2000 application on a Windows NT / Citix server.[/color]
> The[color=green]
> > app is split into a front end and back end mdb, and each user has the[/color]
> front[color=green]
> > end mdb in their own folder.
> >
> > Since we have put the front end mdb into each user's folder, I've[/color][/color]
noticed[color=blue][color=green]
> > the appearance in some of them of db1.mdb, db2.mdb etc.
> >
> > It seems like these files are created when the users start their
> > applications, then closed and deleted when they exit the app. I suspect
> > that these files have been left behind when the server was rebooted[/color][/color]
while[color=blue][color=green]
> > the application was open for these users.
> >
> > What is the function of these files and how can they be deleted? Is[/color][/color]
there[color=blue][color=green]
> > anyway to eliminate this problem short of not rebooting the server?
> >
> > Many thanks,
> > Mike Thomas
> >
> >[/color]
>
> Hi Mike, just a thougt, but are the databases set to be compresed on exit[/color]
?[color=blue]
>
> Best regards
> Stef
>
>[/color]

[Mike Thomas]

Re: Usage of db1.mdb file ??

Many thanks,

I think Stef had it right in the first post.

Mike Thomas

"PC Datasheet" <spam@nospam.sp am> wrote in message
news:rNdUb.9802 $jH6.2906@newsr ead1.news.atl.e arthlink.net...[color=blue]
> Mike,
>
> The db1.mdb, db2.mdb etc. files are being created because your users are[/color]
trying[color=blue]
> to create new database files. When you try to create a new database,[/color]
Access[color=blue]
> first requires you to create and save a file name for the database. Access
> defaults to dbX.mdb for the file name and then provides you an opportunity[/color]
to[color=blue]
> give the file a name of your choice.
>
> Your application apparently displays the Access menu at the top allowing[/color]
the[color=blue]
> users full access to Access as well as the application. If you would put a
> custom menu at the top of your aplication, you would no longer see[/color]
db1.mdb,[color=blue]
> db2.mdb etc. because the users could no longer create new databases.
>
>
> --
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications
> resource@pcdata sheet.com
> www.pcdatasheet.com
>
>
> "Mike Thomas" <mike@ease.co m> wrote in message
> news:QG7Ub.49$t 16.107998@newss vr28.news.prodi gy.com...[color=green]
> > We are using an Access 2000 application on a Windows NT / Citix server.[/color][/color]
The[color=blue][color=green]
> > app is split into a front end and back end mdb, and each user has the[/color][/color]
front[color=blue][color=green]
> > end mdb in their own folder.
> >
> > Since we have put the front end mdb into each user's folder, I've[/color][/color]
noticed[color=blue][color=green]
> > the appearance in some of them of db1.mdb, db2.mdb etc.
> >
> > It seems like these files are created when the users start their
> > applications, then closed and deleted when they exit the app. I suspect
> > that these files have been left behind when the server was rebooted[/color][/color]
while[color=blue][color=green]
> > the application was open for these users.
> >
> > What is the function of these files and how can they be deleted? Is[/color][/color]
there[color=blue][color=green]
> > anyway to eliminate this problem short of not rebooting the server?
> >
> > Many thanks,
> > Mike Thomas
> >
> >[/color]
>
>[/color]