help!!

[Guest]

I have a program called ARIS Dispatch Data Access Service that contains data
from 1995 up to the middle of 2004. And I also have a data access table with
same data but only from beginning of 2004 and up to the middle of 2005. Does
anyone know if it's possible at all to combine all the data together
(1995-2005) in ARIS, so I can run the reports using ARIS?
Thanks

 

[John Vinson]

I have a program called ARIS Dispatch Data Access Service that contains data
from 1995 up to the middle of 2004. And I also have a data access table with
same data but only from beginning of 2004 and up to the middle of 2005. Does
anyone know if it's possible at all to combine all the data together
(1995-2005) in ARIS, so I can run the reports using ARIS?
Thanks

This sounds like a question about Aris, rather than about Access; I
could suggest an Append query in Access, but not knowing anything
about how ARIS stores data, I'm not sure that this applies! Are there
ARIS support groups or websites which might be able to help? Can you
view or edit the ARIS data from an Access frontend, perhaps using an
ODBC connection?

John W. Vinson[MVP]

 

[Guest]

Thanks for you response. ARIS is actually run by Access. I tried importing
the table from an external source, it worked, but the problem is that it
still doesnt include that table when i try to run reports using ARIS. I think
it has something to do with modules? I probably have to change the coding,
but dont know how.
Anyone to help me with that?
Thx

 

[John Vinson]

Thanks for you response. ARIS is actually run by Access. I tried importing
the table from an external source, it worked, but the problem is that it
still doesnt include that table when i try to run reports using ARIS. I think
it has something to do with modules? I probably have to change the coding,
but dont know how.
Anyone to help me with that?

Again...

This is a problem with ARIS. It is not (directly) a problem with
Access.

I don't know anything about ARIS, not even who produced it or what it
does.

It almost certainly does have something to do with the coding, either
the VBA or the SQL queries used by ARIS, but again... I cannot (nor
can anyone here) help you with queries or code which we cannot see,
and for which we have no documentation.

If you cannot get some support from whoever designed ARIS, you'll
probably need to hire someone to actually examine the ARIS software,
and determine how to accomplish what you need to do... provided that
doing so would be legal under the terms of ARIS' EULA.

John W. Vinson[MVP]

 

[foster_purdy]

Vicky

Is the ARIS db you are referring to for ambulance dispatch data? My
work involves an ARIS database for that.

Ryan