ok.

i have a database, 13 locations are using it and we are planning to get a super server and host it in our HQ, thing is, those 13 locations have been independently using that database, my question is, is there a way to merge all of those data into one? or should i just link it?

ok.

i have a database, 13 locations are using it and we are planning to get a super server and host it in our HQ, thing is, those 13 locations have been independently using that database, my question is, is there a way to merge all of those data into one? or should i just link it?

hope you are not thinking WAN.

Is you current database design to handle all the locations in a single database?

IMHO, the best way would be a single shared databse.

It should be possible to import all the locations into a single back end

How many users at each location? If two or more ( 26+ users ) you probably want to consider upsizing the back end to an SQL Server.

that;s the thing, my back end is scattered to 13 locations, meaning, all of them have the autonumber PK, so to merge them, wouldnt that cause chaos? lols.

whats thebest way to merge them? no am thinking of making it a web based application.

You could consider a Terminal Server but that doesn't overcome the problem of merging 13 separate databases. If a Terminal Server is used, each user will have their own Front End, the worst scenario is each location has it own BE database. Without seeing the data, I don't know how it can be consolidated into one database but that does not mean that combining all the datasets into one is not impossible.

Simon