Subscript out of range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tee See - 15 Feb 2006 23:34 GMT

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

Reply to this Message

Ken Snell (MVP) - 16 Feb 2006 04:24 GMT

Nearly impossible to even guess without knowing anything about the query's
SQL statement. Can you post that?

Signature

Ken Snell
<MS ACCESS MVP>

> 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
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Tee See - 16 Feb 2006 22:05 GMT

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

> Nearly impossible to even guess without knowing anything about the query's
> SQL statement. Can you post that?
[quoted text clipped - 8 lines]
>>
>> Thanks

Reply to this Message

Ken Snell (MVP) - 17 Feb 2006 01:34 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> 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
[quoted text clipped - 18 lines]
>>>
>>> Thanks

Reply to this Message

Ken Snell (MVP) - 17 Feb 2006 01:35 GMT

Or try doing a repair of the ACCESS software installation.

Signature

Ken Snell
<MS ACCESS MVP>

> 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
[quoted text clipped - 18 lines]
>>>
>>> Thanks

Reply to this Message