By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,883 Members | 1,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,883 IT Pros & Developers. It's quick & easy.

ACCESS Help with System DSN

P: 7
:confused: I could really use some help

A Access Database was created and put out in a shared drive--so that anyone could run these queries.

I copied the db and made some changes and created a new db by adding two new tables and creating a subquery to run with all the current queries.

My problem is that now no one can use the queries. The run fine on my machine..and a selected few other machines.

When viewing the link table manager I find that the old db looks like this

example A link table R_b_A_detail ()

and mine now show the following

example B link table R_b_A_detail(DSN=op01rtdb02;)

I have been told that example A are pass thru queries???? The db shows them as select queries.

How can I change the new tables I added to look like example A?

Thanks to anyone who can help....

May 10 '06 #1
Share this Question
Share on Google+
5 Replies

P: 70
Did you split the db or the users accessing through shortcuts?
May 10 '06 #2

P: 7
Did you split the db or the users accessing through shortcuts?
What I did was link two new tables the ones with the (DSN XXXX), The other linked tables have just a () after them.

When I added the tables and rewrote the queries. They get an ODBC error message and are unable to run them. However, if you have set up in your control panel the odbc the data source dsnop01rtdb02 then you can run them. How do I change the two tables that I linked to be like the ones that were already in the odbc with just the () after them. All I can think of is it has to be the way I linked up the tables.

May 10 '06 #3

P: 70

you might try to relink to the data and see if that helps. in the mean time I'll see what I can find out for you.
May 10 '06 #4

P: 70
This one was tricky for me. I've never linked to tables the way you are doing it. I found a link that might help you, though...

Good Luck - let me know how it works out..
May 10 '06 #5

P: 7
Thank you so much I appreciate your help...I got it to work with some tweaking and your great find!
May 11 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.