I want to copy an entire table with all its data and references to overwrite an existing table of the same name in another db. (They are both in the same instance of SQL server).I have fiddled around dropping foreign keys, deleting exiting data and then using DTS. Found that it did not copy an...
I have had the same problem when attempting to import a table.
It could be that there is a #Error in a field(s) in the table. I do not know how these arise but you can see them in the Datasheet view of the table.
I had two data fields with #Error in them, in a file of 12,000 records. When...
We have been having problems with Disk/Network errors with 2 multi-user Access 2000 databases under Citrix Terminal services.
A suggested solution to this problem involves, first of all, splitting the DBs and converting the front-end to an MDE file.
I have split a copy of one of the DBs that...
I am new to these Q & A sessions so I am not really sure if I am just talking to myself here.
If you read this Cheryl thanks for your suggestion.
It did turn out to be two data fields with #Error in them, in a file of 12,000 records. When these two records were deleted the table imported...
I have successfully imported all tables into a 2000 Access DB from a 97 DB, except one which gives the error,
Record Deleted and does not import.
I have ensured no one is using the 97 DB and even tried to import the table to another 97 DB, it says it is being used. Also tried copying & pasting...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.