Gremlins

K

KWhamill

I have a bug issue. the problem is this: I have a database on a shared drive
that I am able to use perfectly. However, when one of my coworkers tries to
use it, it does not work properly. Specifically it will not open a certain
linked spreadsheet that is on the same shared drive. The macro runs and the
query appears to work, however when you look at the final report it is
missing several columns that it should have gotten from the spreadsheet. I
cannot seem to isolate why it is behainv this way. I have tried refreshing
the links and having my coworker do the process from the begining on her
machine with no luck.
 
A

Arvin Meyer [MVP]

If you do not split your database and run only the data tables on the shared
drive, and everything else from each workstation, you are asking for
problems like this, as well as risking corruption.

http://www.granite.ab.ca/access/splitapp/overview.htm

Additionally, make sure that the spreadsheet is on the shared drive and you
have mapped the drive letter properly from each workstation.
 
K

KWhamill

I have found one interesting Item. On my computer the columns on the linked
table that appear to be problematic are formated as numbers but on the
problem machine when i look at the formatting on the very same linked table
they appear as text. So why does the same table in the same database have
different link definitions depending on which computer you look at it from?
and how can i fix this?
 
L

Larry Daugherty

If you are distributing the front end in an editable format (MDB or
ACCDB) you should change it to MDE or ACCDE so that it can't be
changed. Keep the editable copy in a development area that only you
can see.

HTH
 
B

Bill Mosca

The reason that happens is that Access tries to determine the data type for
each column at the time the link is made. It will look at the first 20 rows.
If there is any text in those rows, Access will treat that column as text.

On the problem machine, drop the linked spread sheet and re-link it. That
might fix the issue (if the column is clean)

Is there a need to have this link? Linking to spread sheets has its problems
as you have seen. It would be best to store the data in a real table even if
you had to build a separate little database for the user who populates the
sheet.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/MS_Access_Professionals
 
Top