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

Usage of db1.mdb file ??

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"Mike Thomas" <mi**@ease.com> skrev i en meddelelse
news:QG*****************@newssvr28.news.prodigy.co m...
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


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

Best regards
Stef
Nov 12 '05 #2

P: n/a
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
re******@pcdatasheet.com
www.pcdatasheet.com
"Mike Thomas" <mi**@ease.com> wrote in message
news:QG*****************@newssvr28.news.prodigy.co m...
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

Nov 12 '05 #3

P: n/a
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" <sr*@srd.dk> wrote in message
news:40***********************@dread15.news.tele.d k...

"Mike Thomas" <mi**@ease.com> skrev i en meddelelse
news:QG*****************@newssvr28.news.prodigy.co m...
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


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

?
Best regards
Stef

Nov 12 '05 #4

P: n/a
Many thanks,

I think Stef had it right in the first post.

Mike Thomas

"PC Datasheet" <sp**@nospam.spam> wrote in message
news:rN*****************@newsread1.news.atl.earthl ink.net...
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
re******@pcdatasheet.com
www.pcdatasheet.com
"Mike Thomas" <mi**@ease.com> wrote in message
news:QG*****************@newssvr28.news.prodigy.co m...
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


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.