Error in Database Splitting

[shay8020]

All,


I am working on my first access database and I am facing issues in database split. After splitting the database in Front and Back End, some of the columns are not showing any data. Can anyone help me with this issue? Thanks in advance !

[JoeM]

How exactly did you split the data?
Are you seeing this issue in the Front-End or Back-End?
What objects are you seeing this issue in (Table, Queries, Forms, Reports)?

[shay8020]

Joe,
I used the "access database" option under "Database tools" to split the database. I am facing the issues in the front end, I have made some forms using queries as their source, and that is where I am losing the data. I am able to see data in tables and queries.

[ranman256]

SOMETIMES, after a split, you need to refresh the link if changes were made to the BE tables.
just use Linked Table manager, and refresh links.

[shay8020]

That didn't work!

[JoeM]

OK, so the Control Source for your problem form in the Front-End is a Query, and your Query is based on certain Tables.
Let's see if we can pinpoint where the issue is happening.

In the Front-End, can you go to the Tables involved in this (should show as linked tables), open them up, and see the records?
Then, can you go to the query in the Front-End that the Form is based on, open it up, and see the records?
Then, can you open a Form in the Front-end that is based on the Query you just opened up and see the records?

Note is the issue appears to be at the Query level, confirm that the query is good and that records are meeting what criteria you have set in there.

[shay8020]

Joe,
Front End - Table - Yes, the data is available
Front End- Query - Yes the Data is available
Front End Form- No, Data is missing for some columns.

[JoeM]

Can you confirm that the columns that the data is missing for, those values show up in your Query?
If so, try the following:
- Go into the Properties of the Form, remove the "Record Source" and browse and re-select the Query.
- If those columns are still not showing up, remove those fields form the Form and re-add them by clicking and dragging them from the "Add Existing Fields" listing.

[shay8020]

That didn't work. Do you have any other possible solutions?

[JoeM]

Are you sure it worked before it was split?

Can you post screen print of your queries results, and what you are seeing on your forms?

[shay8020]

Yes, it was working before the split. Below is the screen shot.

[JoeM]

Without having access to your system and databases, I really cannot determine what the problem may be. All I can say is that I have split many databases in my time, and have not come across this issue.

One last idea which may help shed some light on the situation:
- Are the back-end tables directly in Access, or are they linked to some other data source (i.e. SQL, etc)?
- Can you post the SQL code of the query that this form is based on (open the Query, switch to SQL View, and copy and paste the code here)?

[shay8020]

I think I found the reason behind it but I am still not sure about the solutions. The values which I am missing are having queries at "Row Source" level.Do you think that can be a possible cause for this issue? If so, then can you please suggest a possible solution for this.

[JoeM]

The values which I am missing are having queries at "Row Source" level.

I am not sure what you mean by this.
Can you explain in more detail?

[shay8020]

I solved it. Somehow in the split, it changed the column bound value of each column. I manually updated that and now it's showing all the values.

Thanks for your time!