Split Db: Data being stored in FE tables, not BE tables

[DruTheFu]

I have created an Access 2000 Db, and have gone through the motions of splitting the Db via the Splitting Tool. Since I have done this split, I have added forms, queries, and reports to the Front End. I have left the Back end table structures alone.

This is where my problem comes into play. To enter data into the Db, I use the forms. After splitting the Db, I assumed that the data would be stored in the tables in the BE. An issue had just presented itself and I went into the BE table structure to add a field to a couple of the tables, and when I opened the BE table in the datasheet view, I noticed that there were no records. I then became curious because when I run my reports and queries, the information is present. So I opened the FE tables and what do you know, all the data I have input since the split is housed in the FE tables.

I already attempted to Update the Table Links, but that did not solve the problem, and the data is still in the FE.

Can someone, anyone please help or offer some suggestions on how to resolve this dilemna.

Thank you in advance,

DtF

 

[ScottGem]

Something went wrong during the split. Try resplitting. Ten make sure that the data is in the BE and only linked tables in the FE

 

[DruTheFu]

I figured it out. The linked tables were pointing to a different location, but I couldn't see it in the Link Manager because I couldn't scroll far enough to the right to see the full path.

 

[Pat Hartman]

You can distinguish local tables from linked tables by the icon to the left of the name. Linked access tables contain a black arrow. ODBC linked tables use a globe as their icon. Other types of linked files show different icons.