field mapping to another access db

J

Janis

I can get to an Access db via terminal services. I will get access to the
server. I do have a question about it though. I can look on the terminal
server and see some reports. I can also print the table names and
definitions but I can't see any data in database design. Presumably for
security purposes. My problem is I need to import the data and I don't know
which fields to map to my fields.

If I get access to the server then can I see the field data to map my fields
to? Or do I need to be able to see the tables in design view on the terminal
server? Since I can't get to external data I don't know what to ask for.

thanks,
 
A

Arvin Meyer [MVP]

If you want to see which fields to import, try using a query. If you cannot
write a new query, that is a security block. You can always import
everything in the tables (assuming permissions on the tables) and weed them
out in your own database.
 
J

Janis

thanks ARvin, I just went to try it and besides being blocked I realized I
don't want to do an import every week do I? Wouldn't that write over the
previous weeks data I think I need to do a SQL query to the Access db. I am
sure I cannot write a new query in the terminal server db but I do need to
get the data out of it some way. Do you mean write a SQL query in my Access
db? If it weren't blocked could I see the other tables in the other db?
thanks,
 
Top