Question At my witt's end and need help

[snoopy4801]

Hi All,
I would say I"m at intermediate when it comes to developing databases, but am still in beginner stages for some areas, and I'm at my witt's end with a new problem and would greatly appreciate any help you could provide.

here's the scenario:
I built a database and split it, then realized i had some of the tables wrong, so I made a copy of my front end, made all of my changes and then "saved as" as two other full copies (or at least in my eyes), then I deleted the old front end and back end. So now I have two databases with all of the tables, queries, and forms in them, but when i go to use my forms, they are still trying to reference the old back-end database which no longer exists because i deleted it.

In theory, I thought i could just take my new copy and re-split it, but even when i do that it is still trying to find my old Back end.

What should I do, or am I hosed....?

 

[pbaldy]

You should be able to go into the Linked Table Manager (in the front end) and relink the tables. Do that by selecting them and checking the box that says "Always prompt for new location". You can then navigate to the new back end.

 

[MSAccessRookie]

Hi All,
I would say I"m at intermediate when it comes to developing databases, but am still in beginner stages for some areas, and I'm at my witt's end with a new problem and would greatly appreciate any help you could provide.

here's the scenario:
I built a database and split it, then realized i had some of the tables wrong, so I made a copy of my front end, made all of my changes and then "saved as" as two other full copies (or at least in my eyes), then I deleted the old front end and back end. So now I have two databases with all of the tables, queries, and forms in them, but when i go to use my forms, they are still trying to reference the old back-end database which no longer exists because i deleted it.

In theory, I thought i could just take my new copy and re-split it, but even when i do that it is still trying to find my old Back end.

What should I do, or am I hosed....?

Sounds like your Links might be incorrect in your Front End. If this is the case, then you can open up the Front End and use the Tools Menu to correct the Links. On the Tools Menu, Select Database Utilities, and then Select Linked Table Manager. This will cause a window with the table names and Link Descriptions to pop up. If the Link Descriptions are incorrect, then you would need to correct them.

 

[snoopy4801]

I tried doing that, but it only updated a few of the tables. For the others it says it can not find the table or it doesn't exist, even though i can see it in my front end.

Would I really screw things up if i exported the missing tables front the front end to the back end and then tried refreshing the links again?

 

[pbaldy]

Is the table in question in the new back end? What you see in the front end is simply a link. You could delete the table in the back end and still see it in the front, you just wouldn't be able to open it or use it.

 

[snoopy4801]

that's exactly where the problem is. there are quite a few tables that are not in the back-end, so what is the best way of getting them there, without messing up the data in my forms? i.e. if i export them to the back end and then put info in the form on my front end, will it only be updating the front end table? Would the exported table in the be then just be considered a copy?

 

[ghudson]

You can simply open both database, then cut and paste the tables to move the tables into the database you want. Then create the links [get exteranl data] from the front end pointing to the backend to link the front end to the back end tables.

 

[snoopy4801]

ok, so i tried that, Now i can see them all (with the same exact names) but when i try and use the link manager to link them it tells me the table doesn't exist, even though i can see it in both db's...

Sorry for being a pain.. I greatly appreciate the help!

 

[MSAccessRookie]

ok, so i tried that, Now i can see them all (with the same exact names) but when i try and use the link manager to link them it tells me the table doesn't exist, even though i can see it in both db's...

Sorry for being a pain.. I greatly appreciate the help!

In the Front End:

Do the Tables Exist, or are they defined as links to tables in another database?

 

[snoopy4801]

I managed to fix it. I'm sure i went the rookie's way around, but here's what i did. Since i could see the tables in my fe, I copied them into Excel and then re-imported them into a clean database and named the tables the same, so when i imported my reports and queries they would still work. It was quite timely, but everything seems to be working now. I think it's time to go home for the weekend!!!

Thank you all for your help!

Cheers til next time!