Subscript out of range

  • Thread starter Thread starter Tee See
  • Start date Start date
T

Tee See

The above error message occurs when I try to build a query. The strange part
is that I have built several queries using the same two tables in the past
without this error occurring.
My database is used on a LAN with the tables residing on the server.When
convert back to a stand alone database this error does not appear.

Any ideas as to why this is happening "all of a sudden"

Thanks
 
Nearly impossible to even guess without knowing anything about the query's
SQL statement. Can you post that?
 
Thanks Ken. Your response made me think a little more about this.I tried
again to create a query, using the wizard,with two fields from two separate
tables and received the same error message. Tried again with the same fields
but no wizard and didn't receive an error. Can't post the SQL 'cos I can't
get thru the wizard to complete the query. At least can work around the
wizard but as I said initially I have devised queries before with no problem
utilizing the same two tables.

Regards
 
Try re-registering this file:
Accwiz.dll

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

Or run from Start | Run window (example):
Regsvr32 "path\msexcl40.DLL"

etc.
 
Back
Top