Clicky

The same file on a network will not open in 2 x  Win 7 32 bit system but opens Ok in a Vista system - its the exact same file? The error msg is cannot find an input table. Any ideas Thanks

asked 12/05/2011 10:55

Neliduff's gravatar image

Neliduff ♦♦


7 Answers:
Hi,

Are you using the same office version?
link

answered

hellblazeruk's gravatar image

hellblazeruk

Does the Access application include linked tables?  If so, are the links by drive letter?  Are the drive mappings the same on the Win 7 boxes as the Vista box?  What table, specifically, is named in the error message?  Is it a local table?
OM Gang
link

answered 2011-12-06 at 07:03:30

omgang's gravatar image

omgang

Same office version either 2002 or 03 and the file sits on the same drive that both system types are mapped to and yes the table is linked. The table is in a backend file with apparently the appropriate permissions granted as well.
link

answered 2011-12-06 at 07:12:44

Neliduff's gravatar image

Neliduff

To confirm that it's not a permissions issue log on as the same user that works on Vista when testing on the Win 7 machine.
link

answered 2011-12-06 at 07:27:03

kmslogic's gravatar image

kmslogic

So, just to clarify, the linked table is linked as J:\TheDirectoryPath\TheOtherAccessFile.mdb
AND J: exists on the Vista machine and is mapped to the appropriate share on the server
AND J: exists on the Win 7 machines and is mapped to the appropriate share on the server.

Even if the mdb file resides on a server, the links are relative to the client machine running the application, i.e. the links must exsit on the client machine and point to the correct server shares.

You might try changing the links from mapped drive letter to UNC path to see if that resolves the problem.
OM Gang
link

answered 2011-12-06 at 07:28:53

omgang's gravatar image

omgang

you can link using the unc like \\machine\share\file.mdb which avoids the network drive mapping issue.
link

answered 2011-12-06 at 07:51:07

kmslogic's gravatar image

kmslogic

Many thanks

link

answered 2011-12-06 at 09:13:57

Neliduff's gravatar image

Neliduff

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

Asked: 12/05/2011 10:55

Seen: 238 times

Last updated: 12/17/2011 05:16