Linking Data Tables

G

George

We have a program at work that was created by a previous employee that is run
on a LAN. His program is split into a front end and back end. We needed some
additional features to access the files in the back end so rather then modify
his program I created a new front end. I started by copying his tables into
my program then created the forms, etc I needed. I linked my new program to
his backend program and everything worked as planned, at home. I took my new
front end program to work and selected link tables. The link screen came up
and I selected all the tables from my program to link to his and it wouldn't
work. The only way it would work is if I linked one table at a time. Is there
something I missed when I created my new front end program ?

Thanks - George
 
G

Gina Whipp

George,

Could it be you navigated to database that contaied the linked tables and
not the back-end? That's the only time I have ever seen that message
because you can link multiple front ends to a a single back-end.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
G

George

No it was definitely the back end - it has a unique name.
It's also the same version of Access.

Thanks
 
S

Sylvain Lafontaine

If you want to change the connection for multiple ODBC linked tables at the
same time, you must the Linked Tables Manager (under the Tools menu)
instead.
 
G

Gina Whipp

Did you try leaving it unchecked? OR you can have a look at...

http://www.mvps.org/access/tables/tbl0009.htm

It sounds like all the back-end tables are in the same place so it shouldn't
be getting confused as to where to look. Not sure why it wants to do it one
at a time, interesting though... he above Function will show you a way to do
it from code and that code has never given me an issue.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
G

George

Thanks - I will try it tomorrow at work.

George

Sylvain Lafontaine said:
If you want to change the connection for multiple ODBC linked tables at the
same time, you must the Linked Tables Manager (under the Tools menu)
instead.
Click to expand...
 
B

Bob Larson

I've had that problem before and haven't quite figured out when it will do
it and when it won't. But, I typically will copy the path and then just
paste it in so I don't have to keep navigating to it.

--

Thanks,

Bob Larson
Access MVP

Free Access Tutorials and Resources: http://www.btabdevelopment.com
 
G

George

I tried this at work and noticed that my program
had one more file in the table that I didn't put
there "MSysCompactError" I removed it and all
is well. Seems like Access generated this file.
 
J

John W. Vinson

I tried this at work and noticed that my program
had one more file in the table that I didn't put
there "MSysCompactError" I removed it and all
is well. Seems like Access generated this file.
Click to expand...

ummmmmm....

Yes, Access put it there. It's to warn you that there is an error in your
database which happened when the database was Compacted (perhaps automatically
with Compact on Close).

Removing the error table makes it much harder to tell what the error was, and
does not remove or prevent the error from happening again.

There are several other tables with names starting with MSys, usually visible
only if you use Options to make systems tables visible. These are *essential*
to the functioning of your database. They generally can't be deleted but you
wouldn't want to do so (any more than you'ld want to take the transmission and
the alternator out of your car).
 
G

George

Thanks John

But when the front-end has a file that the back-end table doesn't the linking
process stops and gives you an error message can not Find That File/s.

George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidden Tables 2
linked tables 2007 <--> 95 4
How to link a split _be? 1
Ghost references to deleted tables in a back end database (Access2000 XP) 5
Linking New Tables 5
Can't see data from 2 of 3 linked tables that a main table depends 1
Distributing a FE/BE and linking them 9
SQL Server Backend: linked tables or no more bound forms ? 4

Top