Table Links

[dcjones]

Hi All.

Is it possible to remove all the links form the FE database to the BE database.

Because of lots of problems I am having after my database split I want to gp back to the beginning and have a standard database without linked tables.

I need help with this one as it is giving myself and my customer major problems.

Any help please.


Kind regards, keep safe and well.


Dereck

 

[dcjones]

Hi Pat, thanks for your reply, again.

The problem I am having is this. I developed the database on my PC. I then split it so that the :

FE was in f:\database\admissions\referral.mdb

and

BE was in F:\database\backend\referral_be.mdb.

Now that I am ready for the database to go from development to production I want to move the whole system to the server.

On the server I have a shared directory named, database$

On the workstation I have a drive Y mapped to the share:

I then have the workstation use Y:\admissions\referral.mdb

When I execute the database using the mapped drive I get the error:

"The Microsoft Jet database engine cannot find the input table or query "THE TABLE NAME". Make sure it exists and its name is spelled correctly."

I get this error on a number of tables when I try and re-link using the Link Manager.

Any idea why.

Many thanks

Regards

Dereck

 

[dcjones]

Hi,

Looking at the Tables window, why is it that some of the tables are split, ie, they have a blue (right) arrow next to them and others do not.

I know that the arrow indcates that the table is linked but when the split was done should not all the tables in the database ne in the split process.

I think I need to go back to the place before the split.

How do I remove the links. If you could advise you could get me out of trouble.


Many thanks in advance


Regards

Dereck

 

[dcjones]

Hi Pat and All,

I have fould out what was incorrect with my split database. For some reason the tables were linked to 2 different directories.

I deleted all the links in the FE and exported all the linked tables from both the BE files (different directories) back into the FE.

Then I restructired the directories and ran the Database Spliter again. Now I have all the tables in a BE file in 1 directory and the FE in another.

I then copied the FE and BE files to the server, relinked the tables and all is well.


Thanks for your input.

This has made an Old man Young again.

Kind Regards, keep safe and well.

Dereck