Manage Databases

  • Thread starter Thread starter Gina Whipp
  • Start date Start date
G

Gina Whipp

Hello All,

I have over 100 databases on my computer. My memory not being what it used
to be I would like to have an icon on my start menu that I can click on and
look up these databases and what they do ie...

DatabaseName Comment Creator
db1.mdb login-on form Me
db2.mdb my favorite main menu & search form Me
db3.mdb sample combo boxes
NameOfCreator

Anyone ever run across a program that I can do that with? It would save me
time searching when I'm looking for a which database has what in it.

Thanks to anyone who can help!
Gina
 
Gina Whipp said:
Hello All,

I have over 100 databases on my computer. My memory not being what it used
to be I would like to have an icon on my start menu that I can click on and
look up these databases and what they do ie...

DatabaseName Comment Creator
db1.mdb login-on form Me
db2.mdb my favorite main menu & search form Me
db3.mdb sample combo boxes
NameOfCreator
Click to expand...

I'd start by renaming the databases to something that means something.
rename db1 "log on form"
I'd also go through them and see if they can be grouped into one data base
Chances are all the tables, forms reports can be imported into a few
databases.

db1 and db2 probably and db3 etc would go into a tools database.
 
Did that Mike and I still have over 100. Took me two days! The issue is
I'd like to be able to pull up the list, "on-the-fly" without looking in
Explorer AND some databases have five items in them.
 
Gina Whipp said:
Did that Mike and I still have over 100. Took me two days! The issue is
I'd like to be able to pull up the list, "on-the-fly" without looking in
Explorer AND some databases have five items in them.
Click to expand...

What do you mean by five items? Five queries, reports and forms?
FWIW one FE of mine has 1200 queries, 400 forms and 300 reports.

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,

Let me try to explain this better...

I have over 200 databases (I counted today). Some databases are programs I
have written, some are samples I've downloaded and some are ones I've
written to 'play'. When I want to find something I have done in any one
database to transfer the one I am working on now I have to remember which
database I wrote in it. Now some of the databases have more then one sample
in them. Like the one called directoryprint.mdb has a way to print
directories but it also has a cool search form I like to use and a great
form layout. (That's what I mean by some of them have up to five items in
them. I was not refering to how many queries, tables, etc...)

What I would like (but it seems as though I'll be coding this one, good way
to learn VB 6.0 which I bought and used once) is on my task/menu bar in my
Windows desltop an icon that I can click on and would open up a menu or
window that shows me a list and where what is and what is does that I can
populate. Like file manager but with notes...

FileName Notes Creator
db1.mdb cool log-on form name of creator
db1.mdb search form name of creator
db2.mdb favorite main menu name of creator

This way, memory not being it used to be, when I am looking for a form or
query or table I set up in a previous database I can click the icon have the
list come up similar to Windows menu and look for the item I want and then
click it to open it.

Hope that better expalins it. Thanks for any help you can give me. Oh, I
tried looking for file managers but they don't give me quite what I want.

Thanks,
Gina
 
What I would like (but it seems as though I'll be coding this one, good way
to learn VB 6.0 which I bought and used once) is on my task/menu bar in my
Windows desltop an icon that I can click on and would open up a menu or
window that shows me a list and where what is and what is does that I can
populate. Like file manager but with notes...
Click to expand...

You might want to set up a <gasp!> Access database of databases...

I'll follow this thread with interest; I don't know how to do this in
Explorer, if it can be done at all, but I'd be interested in finding
out!
 
John Vinson said:
You might want to set up a <gasp!> Access database of databases...
Click to expand...

Excellent idea. I should've thought of that myself. <smile>

See the Dir command in the online help. Add a record to a table for
each file.

There should be some logic somewhere which allows you to recursively
go through all subdirectories and sub sub directories out there,
likely in VB but which should work with a few modifications.

Then you can create another memo field and type in what you want and
then use like "*xyz*" to search.

When you want to refresh just see if that directory and file name
already exists in your table. If not add it.

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
 
Not exactly what I had in mind but you know necessity is the mother of
invention... (I was hoping someone already had something out there.

Thanks 8-)
Gina
 
Back
Top