Connecting front and back end

[Karen Patalano]

I have 10 accounts using the same access program, except they have different data in their tables. I have made several changes to the queries, forms and reports in one of the access programs. I would like to split the databases and reconnect the front end with the changes to the tables in the 10 access programs currently in use. All the programs were copies of the same program originally so the tables are the same, except for the data of course. I have tried to split the new program and an old program and connect the front end of the new program to the data in the old program and it did not work...any ideas?:

 

[boblarson]

When you say:

I have tried to split the new program and an old program and connect the front end of the new program to the data in the old program and it did not work

You need to be more specific. What didn't work? What were the results. What happened, what didn't happen that you expected to happen. Just saying it doesn't work is like telling the doctor that you have an ache and not telling him anything about it.

 

[Karen Patalano]

When I selected all it only pulled up one table so I individually clicked on each table and chose the back end each time but it still did not link.

 

[boblarson]

When I selected all it only pulled up one table so I individually clicked on each table and chose the back end each time but it still did not link.

What that means is that you have selected tables from more than one source. In other words, if I have 6 tables and 5 are linked to C:\MyFolder\MyDatabase.mdb and 1 is linked to \\MyServer\MyFolder\MyOtherDatabase.mdb then I would need to select the tables ONLY for the first and do the relink and then run the Linked Table Manager again and then select only the table which was linked to the second database and then select its backend file.

But I also question this:

except they have different data in their tables.

which would tend to indicate that they have a self-contained database on their machine (or run from somewhere else) and somehow you would need to bring all of the data together under a single backend (which is how it should have been set up to begin with).

 

[Karen Patalano]

I can bring all the data together under a single back end as the new program has only two entries. How would I go about doing this?

 

[Karen Patalano]

When I connected the two programs tables I ended up with duplicate tables. Is there a way to transfer only the data to the new access program?