Invalid argument how to fix?

[Guest]

I have a record which has #### in each field. I have surmised that due to
the nature of my split, replicable MDB my best course of action is to create
an append query to copy all the uncorrupt data into a new table.

Here's my problem.... I havent written queries for about 3 years and cannot
remember what criteria I need to put in in order to make this work. Any help
would be appreciated.

Thanks in advance

Charlie

 

[Guest]

Not trying to be smart here, but is it possible that the "####" in each field
is simply because the column width is not wide enough to display the results?


If that is possible, click on the upper left corner of the sheet to
highlight all cells, then click format, then column, then auto fit.

 

[Guest]

Hi,

When trying to access this record an 'invalid argument' error occurs. As
this error is only in one replica set and replication is throwing errors up
because of this I need to remove this line of data. I need to run the append
query so that I may keep the autonumber field which is the primary key. If I
try to compact and repair it causes my replica to become un replicated hence
the problem.

Charlie

 

[Guest]

Sorry the data in the fields read #Error

Hi,

When trying to access this record an 'invalid argument' error occurs. As
this error is only in one replica set and replication is throwing errors up
because of this I need to remove this line of data. I need to run the append
query so that I may keep the autonumber field which is the primary key. If I
try to compact and repair it causes my replica to become un replicated hence
the problem.

Charlie

 

[Tony Toews]

I have a record which has #### in each field. I have surmised that due to
the nature of my split, replicable MDB my best course of action is to create
an append query to copy all the uncorrupt data into a new table.

Here's my problem.... I havent written queries for about 3 years and cannot
remember what criteria I need to put in in order to make this work. Any help
would be appreciated.

Assuming you have used an ascending autonumber as your primary key
your criteria for the query would be from 1 to the record number
immediately before this corrupt record. And another query for
greater than the corrupt record ID.

tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Hi thanks for you response.

The saga continues..... I have created my new table got all my data now
onto the next problem.

The corrupt data is in the main table in a replica. I cannot get a new
table in the replica that will replicate with others. The design mater
cannot synchronise because of the error.

The design master for the set flys out to another country so I need to get
this fixed ASAP.

Thx in advance

Charlie

 

[Tony Toews]

The saga continues..... I have created my new table got all my data now
onto the next problem.

The corrupt data is in the main table in a replica. I cannot get a new
table in the replica that will replicate with others. The design mater
cannot synchronise because of the error.

I have no idea when it comes to replicas. I'd suggest asking in the
replication newsgroup or starting a new thread with replication in the
subject.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm