linked tables question

[shrndegruv]

Hi everyone

So I developed an application with a backend containing tables and a front end with forms, queries, and reports. This is so I can give my employer some basic functionality and then add more reports/functionality to the front end over time.

My questions are:

1) If I change the underlying tables by adding some fields, how do I get the data into the new back-end
2) When I update the front end and give it to my employer, do I have to delete the table references that I set up and relink, given that the front end is now on the employers machines and the directories are all different? Im assuming yes, so the real question is, what is the best way to link the back-end to the new front-end?

thanx
mike

 

[NJudson]

I'm a little confused by what your saying, but if you link the front end to the tables in the back end then anything you do to the linked tables in the front end will essentially do the same to the back end. One way to look at it is that the front end linked tables is a "shortcut" to the backend tables. So if you make changes to the tables on your front end then your boss will automatically see the changes to the tables on his front end if they are linked properly. However, your boss's queries, forms, reports may need updated to reflect any changes to the tables that you made.

 

[shrndegruv]

N

heres the process

I develop mdb files A (back end) and b(front end). B uses the tables in A.

Deliver both B and A to my employer. Question: I have to relink A and B because the path from B to A has changed? A resides on a shared disk, B is installed on a number of desktops. User adds data to A through B.

Now I make changes to B, adding functionality, and deliver it? Do I have to relink A and B?

Now the user requests functionality not in the original design, forcing additions to A.

I need to import from A to A', and deliver a B' to match the added functionality.

Do I again have to relink? And if so what is the best way to do it? Right now when A' and B' are installed in the appropriate places, I delete all the table references in B' and relink. Is there a better way to do it? Id like to just be able to deliver the files and have it handled automatically...

mike

 

[Bat17]

In addins you should have a linked table manager this will let you relink tables as necessary. if you link them using the server name rather than mapped drive letter then they should be ok on any pc and not need relinking

\\Server\Directory\Directory\File.mdb

HTH

Peter