LINKED ACCESS TABLE WILL NOT OPEN

[MariaL]

I linked a table from an access database to a blank access database. The table shows with the link icon, but when I double click on it, it will not open. Any sugguestion? Is there anything special you should do before linking a table?
Thank you!

 

[GingerR]

do you get any kind of error message?
is the table you linked to in a secure db?

there's nothing special you have to do before linking if you have your own db and link to it from another db and you know where both of the db's reside and there's no security etc etc etc

 

[MariaL]

Thank You for your responce. Once, I got a error log that simple stated "Admin Maria". What could that mean?I am building this for another company and we are e-mailing the database back and forth. Could this be an issue? Thank you so much for your help. I can't continue my work until I figure this out.

 

[GingerR]

if you are linking to a table in a database - the database you're linking to must be in the exact same place in your customer's company.

what is the path to the linked table?
look in the table msysobjects, find the table name and look at where it's linked to.

is it the C:\drive? do you both have the back-end database located in the same place? or does it have another drive letter? again, the place you are linking to must be called the exact same thing in both places.

 

[MariaL]

Thank you for your help. I am still having a very difficult time. The error message states " Admin Maria". This is the admin of my access application. I created the database and sent it to the company. They e-mailed the database back to me, and I now use that database for corrections. I'm simple trying to link to a new database on my computer. I haven't even reached the point where I make it work on their system. How can I pull up the admin name showing on a database and change it if neccessary? It doesn't seem to be security, because I do not have security activated. So, I'm thinking it has nothing to do with the admin there. How do I get to the table msysobjects? Anything you can do to help me would be greatly appreciated. Thank you, Thank you, Thank you

 

[DougStevens]

First the connection string within the table will not change from location to location. You will have to run the Link Table Manager wizard (if installed), or reconnect the tables via code. The earlier post about the location of the external database file is right on. Both location will have use the same connection string (i.e. location) OR you have to run the Link Table Manager Wizard each time you save the file from your email.

Second, are you opening the database from your email or saving it to a location then opening it? Emails store a open file in a temp location before opening it.

Third, not sure what your error message means. Have you ever changed the Database Ownership, and your Workgroup file on your machine? For this database or any other database in the past?

 

[MariaL]

Thank you, I have never changed owners. I checked to make sure the owners are the same on both databases and that checks out OK. I'm trying to pull up the wizard now, but I think it is frozen. I may need to re-install office. How would I go about using code? I appreciate your help and time.

 

[MariaL]

OK, I was able to pull up the link table manager and update the table, but it didn't work. I still couldn't open the table. Then, when I tried to open the manager again I got the following message: "Object Variable or With block Variable not set." Has anyone ever seen this before? Thank you!

 

[GingerR]

i have seen that, but not just opening the linked table wizard.

to test: create a new blank database.
link to the table in question.
does it work?

 

[MariaL]

No, it doesn't work.
I even created two databases, added a table in one and linked it to the other just to make sure I was linking correctly. It worked fine. It must be reading a differnt admin even though the properties show the same admin for each. How would I link the tables using code? Anything else I can try is beyond my knowledge. Access is a lonely world once you get to a certain point. This sight is my only help. Can you recommend a resource that I can buy to help me in these situations. Again, I greatly appreciate your help.

 

[Hillary]

This is a longshot, but do you and your customer both have the same ODBC?

Hillary

 

[MariaL]

No, we do no have the same ODBC. When I go to there office, I will create a back end and link the information. Right now, I'm just trying to link on my computer in the same folder. ODBC shouldn't be an issue, right?

 

[Hillary]

I have had a database work fine on my PC then went to someone else's PC and couldn't connect because we had different ODBC's. Both PC's had an ODBC to the same database but one ODBC was ORACLE and one was Microsoft ODBC for ORACLE. We were connected to our MRP system, not another Access Database. When I couldn't connect with the Microsoft ODBC for ORACLE I didn't get any errors, the system didn't hang up, but nothing would happen. I have found ORACLE ODBC is the best for our applications.

I hope this helps!

Hillary