How to upload

[nvk]

I have set up a database for service management. I have sent a copy of the
databases to all my regions and need to connect these databases at one place.

Can you please let me know whether this can be done and if so how do i do it.

Thanks
nvk

 

[jahoobob]

I have set up a database for service management. I have sent a copy of
the
databases to all my regions and need to connect these databases at one
place.

Can you please let me know whether this can be done and if so how do i
do it.

Thanks
nvk

You can. Connect at the backend. Create a backend database on a
server with all your tables (nothing else.) Link all the users tables
to these tables and voila. This is the way you MUST do this. Must,
not meaning it isn't possible any other way but meaning this is the
only way for your sanity. All the expert users will tell you this is
true. It is one of the "Commandments" of Access developers.
If you have any further questions, don't hesitate to ask.
Bob

 

[Amy Blankenship]

What sort of hardware do you have connecting the regions?

-Amy

 

[Amy Blankenship]

Assuming there's an actual physical connection possible. If there isn't,
this isn't likely to work.

-Amy

 

[nvk]

Dear Amy,

Thanks for the info.

All my regions send me the dtatbases through email for the time being!!! Ig
i am successful then we will be uploading the same on out website.

-nvk

 

[Amy Blankenship]

You'll probably have to code an import or export feature in either your
central database (import) or the copies (export). It's impossible to give
you more specifics without knowing your table structure or exact needs.

HTH;

Amy