field mapping to another access db

[Guest]

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,

 

[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.

 

[Guest]

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,

 

[Arvin Meyer [MVP]]

When running a terminal server app, you are a dumb terminal. The only
processing that takes place locally is what's required for your video, and
for you to print. Everything else takes place on the server app. You really
don't even need Access, since it's running on the terminal server. You need
to make an arrangement with the server admin for you to either connect to
the data with a query on the server, or copy the data to your local machine
where you can do what you wish.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com