Disk or network error- Access DB

[Guest]

Hi,
This app was working okay until friday. The server guys applied some Windows Server 2000 patches over the weekend and then I am getting this error while trying to run a query,

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Disk or network error.
9 : <CFQUERY NAME="Entity" DATASOURCE="Contracts">
10 : SELECT EntityId,
11 : [ENTITY NAME] as Entity,
--------------------------------------------------------------------------------

SQL SELECT EntityId, [ENTITY NAME] as Entity, DBA FROM [ENTITY ADDRESS INFO] ORDER BY [ENTITY NAME]
DATASOURCE Contracts
VENDORERRORCODE -1022
SQLSTATE HY000


Can anybody help?

Thanks
VJ

[Jon Cooper]

VJ - it sounds as though either the network mapping/share to the MDB file has gone or the permissions have been mucked up.

Jon

[cfdoogan]

Is this a network or local drive. If network this may help:

Open Control Panel -> Settings -> Administrative Settings -> Services


Right click on Coldfusion Application Server and select Properties.


Second tab in "Log On", choose the second radio button and change the user to one with access rights.


Make sure that the user you selected as the one with the access rights exists on the mapped server

[Guest · Accepted solution]

Thanks Jon and doogan. The problem occured due to some network permissions being messed up. The Access DB is itself on another server (A). CF server connects to this m/c and able to verify the datasource. The Entity table that I was tring to query is a linked table which is located on another m/c (B). CF server was not able to see this m/c. Everything works okay if I copied the table on to server A. The network guys are working on this and will hopefully fix it. Thanks very much for your inputs.

VJ