Can I change the database that a form is linked to?

English
#1

I tend to change the name of my databases from year to year and I find that forms can no longer find their data source. Is there a way to link a form to a renamed database?

Thanks,
Jim

#2

Hello,

Your question is lacking basic information. It appears you are using an external DB. If so, and the table and field name are the same, it should be just a matter of changing the connection string. From Base menu Edit->Database.

#3

I’m sorry to have given insufficient information. I am not using an external DB. I will try to elaborate:

I have a Family database containing names, addresses and so forth. This data is in the form of a table entitled “Address Database 2018.” Information from the table can be displayed in forms. Recently, I added more data to the table and renamed it “Address Database 2020.” The forms can then no longer display their information because the “Address Database 2018.” does not exist. So, what I’m asking is can Instruct the forms to look for their data in the renamed “Address Database 2018.” i.e., “Address Database 2020.” Obviously, I can reverse the name change. Thank you. Jim

#4

Hello,

Your terminology is incorrect in the question. I only bring this up as it determines where to look for an answer. Changing the name of a database would indicate using an external database. You are not changing the name of your database but rather the name of a table. A database consists of one or many tables, views, queries, etc. Each of these components has its’ own name as does the database itself.

As long as you have not changed field names, changing the data source in the form property should give you what you want.

Edit your form. On the Form Design toolbar is an icon for Form Navigator. Left click. You then right click on the internal name of your form (under Forms) and select Properties. On the Data tab, select you newly named table using the drop down in the Content property. Close. Save form and data should be available.

#5

Hi,

Thank you for your advice which I have applied and which has given the desired result.

Thank you also for correcting me on terminology which I shall seek to apply in the future:

In my Family Database I have changed my, erroneously named “Address Database” to Address Table."

Thanks again,

Kind Regards,

Jim

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.