Hello from Nevada, USA

[samye228]

Hi,

My name is Carol. I am not new to database technologies but new to Access. I have inherited an Access database in my position and need help understanding how to determine what is going on. I am using O365 version but do not know when the DB was originally created. I found a query for MSysObjects and ran it. The earliest date was 9/25/2002. At some point the DB was linked to the 2010 file type of ACCDB.

I have many questions concerning the history of the DB, how to find answers and how to clean-up. Such as:
1. When I go to Database Tools > Relationships, I see a mess of relationships and tables with strange names, [4F4DD22E-9...]. When I open it I get a message that says it is a linked table and has the extension mdb. I'd like to know how to clean up the database and get it all in the current Access format.
2. There are tables with a _1 after them and they are related to the table with the original name, example: Agency Names table has a relationship with Agency Names_1, is this needed?
3. Is it possible to clean up table names, like the one listed in item 2 above? Agency Names has a space and it would be nice to rename to a standard such as tbl_AgencyNames.
4. How can I find what modules are not used?
5. Would it be beneficial to investigate moving to SQL Server?

Please let me know the best place to post these questions.

Thank you,
Carol

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[theDBguy]

Hi. Welcome to AWF!

The first thing we'll need to understand is the purpose of the database. What is it used for? What business process is it trying to model. I would suggest starting a new thread in a different forum than the Introduction one.

 

[NauticalGent]

Welcome aboard, Carol!

 

[pbaldy]

Welcome from northern Nevada (okay, I'm in New Zealand at this moment). FYI I moved your thread to a more appropriate forum.

 

[AngelSpeaks]

Hi Carol.

 

[The_Doc_Man]

Hello, Carol, and welcome to the forum.

I was going to answer your questions but Pat beat me to it. She is a good resource for lots of knowledge as she has lots of experience in various types and sizes of project. Many others of us also can offer help. May I offer a suggestion or two?

You said you were familiar with database technologies. If you are familiar with normalization, great. If not, search this forum (using the SEARCH button in the upper right of the page) for 'normalization.' OR if you use a web browser, search for 'database normalization' because the word 'normalization' also is applied in math, chemistry, medicine, politics and international relations, ... a bunch of topics.

We have several "topic" forums and you can post in any of them. Try to narrow your questions to the match the topics. For instance, don't post a Table question in a Module forum. Other than that, we are wide open and ready to help. Any questions are fair game.

Jon posted a link in his welcome message. It is a short article. You can also look at the bottom of the page, to the right, to find a Help link and a Terms and Rules link.

One last thing that might help: Once you post a question, the forum has some simple matching logic that tries to find five articles that seem like they are related to your question. The "Similar Threads" list can therefore be a useful resource.