Using Relationships from a Back-End Database

[RSfromCO]

I am splitting an existing database into Front-End and Back-End.

The back-end database contains all the tables and relationships, but when I link to all of those tables in the front-end database, the relationships do not appear to be there (in the front-end). When I use the Front-end database it seems slower than when it was all a single database, so I am wondering if it is because the relationships are not defined in the front-end database.

Is the fact that the relationships are not defined in the front-end causing a slowness? If so, is there a way to easily get the relationships that are defined in the back-end database into the front-end database?

 

[JoanneM]

hello there

if you have created relationships in the repository then when you go to relatationships show all button in the relationship window in your front end then they will appear.

Slowness can be due to
Network traffic
not optimising queries
loading huge amounts of data on opening forms and opening lots of forms without closing


Heavy functionality and untrapped errors to name but a few buglets that can slow you down

Along with many users and poor normalisation

where would you like to start?

regards

jo

 

[RSfromCO]

Thank you for the response, but if I create a new database and then Link in all the tables from the back-end database, when I go to the relationships window there is nothing there. If I Add all of the tables to the relationships window they are there with no relationships defined.

I can create the relationships again (within the front-end database) but that would take a lot of work and time.

I am aware of the other reasons you mentioned for possible slowness, but those seem like they would be the same regardless of using linked tables or local tables (when all files are on a local hard drive).

 

[RSfromCO]

Good news!

I found that if I use the "Database Splitter" feature it places all the tables into a new back-end database, changes the current database to use links to the new back-end database, and leaves the "Relationshps" defined in the front-end.

I was trying to create a new front-end database from scratch, create the links, and have the relationships copied from the back-end. Using the "Database Splitter" accomplishes the task, it just does it in reverse of what I was trying to do.

This will save me a bunch of work.

 

[JeroenNL]

Been searching for a topic like this one for i have a simular problem.

I have an Oracle backend with tables and relationships defined between them but when I try to link them in my MS-Access frontend, the tables are there without their relationships. What am I doing wrong?

Bye,
Jeroen

A 3D editor project

http://www.delgine.com