2 database in one ?

Question

i have a 2 SharePoint sites where a similar database runs on the same linked tabels on each site.

So the databases run totaly seperate from each other.

now i want to combine those databases in another to have an overview.

can i use the forms of these databases and override de  filenames , or querynames? 

or should  i make a database where you can open these databases ?

Answer 1

Hi,

One front end can connect to multiple back ends, so I don't see why you can't have just one front end as long as your forms or queries are pointing to the correct sites.

Just my 2 cents...

Answer 2

if you have 2 companies

and this tables

c1_orders                  c2_orders

c1_Ordersdetail          c2_ordersdetail

each company have their own databse to put in orders.

but now i want to use the same orderform for the headoffice

they have all the tables linked in 1 database , but depending on for which company they put in orders, the recordsource of the form orders  and subform ordersdetail must change .   Orders is an data-entry form

how does that go ? 

Answer 3

Hi tekoko,

For your scenario, I would suggest you add a new table to store company, and then add companyId field to these tables, when you need to insert order and orderdetail for c1, you could save the information and companyId for c1 in the orders table, when you query from table, you could add a filter field based on the current company.

As this way, you will be able to combine multiple comany information into one database.

Best Regards,

Tao Zhou

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

how is it going in the right SharePoint list?

Answer 5

if you have 2 companies

and this tables

c1_orders                  c2_orders

c1_Ordersdetail          c2_ordersdetail

each company have their own databse to put in orders.

but now i want to use the same orderform for the headoffice

they have all the tables linked in 1 database , but depending on for which company they put in orders, the recordsource of the form orders  and subform ordersdetail must change .   Orders is an data-entry form

how does that go ? 

Hi,

When you open the form, you could ask the user to select a company. Based on the selection, you can set the Record Source of the form to the selected company.

Will that work?

Answer 6

i'ce tried that, but  it did not work.

it is a  data- entry form with subform, , to you have to set the recordsource of the subform too ?

Answer 7

Hi tekoko,

If you need to work with two sharepoint sites, you may create separeate link tables for them, create a new middle table which will query the information based on the company name from the linked tables, bind the form with the new middle table.

Best Regards,

Tao Zhou

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 8

i can understand that, , say fro the orders-table 

but how  is it going for the ordersdetail table ? the key  the key in the  2 SharePoint tables of the ordersdetail table can be the same .? 

Answer 9

or is chaning the recordsource in the program a better idea ?

Answer 10

I think you could go with changing recordsource.

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 11

You can have to active links to different back end SharePoint sites.

The "know" part will be HOW and WHEN you created the linked table to the correct site (access remembers this setting).

What this means that if both different back ends have say a "same" name for a table, then you get this:

tblCustomers

tblCustomers1

So the tables for all "thinking" issues are 100% separate, and the two databases are still 100% separate. However the end result is that you can work with both tables in "one" front end. Of course this setup will not by magic "combine" the data between the two systems - only allow you to build forms and reports for both back ends in one front end.

So you are free to have "active" linked tables to more then one back end. And while you can have this active connection to two systems, each table name in your front end will have to have a different name for the case when both back ends have the same table name.

You could change/set the forms record source to either table - but as noted, those tables with the same name back end will have a different name in the front end.

Albert D. Kallal (Access MVP, 2003-2017)

Edmonton, Alberta Canada