Greetings, I am trying to upsize

[meldrape]

Greetings,

I am trying to upsize or even import a database from Access 2000 but I am receiving the following errors on certain tables:

Error Source Microsoft JET Database Engine
Error Description: Record(s) cannot be read; no read permission on ‘name’

I have compared these tables with the ones that import or upsize properly and I can't see any difference. Any thoughts would be greatly appreciated. I am able to export them from Access, but I need to maintain the relationships. Thanks.

 

[tlbroadbent]

If a table has a function as the default property for a field, Upsize will fail. Field validation rules may also cause failure.

Source:

http://msdn.microsoft.com/library/techart/upsize00.htm

Here are some other possible reasons for Upsize failure.

If a unique index is set on a field, and the required property is set to "No" in Access, the Microsoft Upsizing Wizard will fail.

If you have created a table and then reordered the fields after you have saved it, the Microsoft Upsizing Wizard will often fall over.

Tables with invalid dates will be skipped without warning (SQL Server smalldatetime can only store from the years 1900 to 2079. Dates outside this range will fail.) For example, Access will allow data entry errors such as '1/1/199'.

Fields with multiple-key indexes cannot be upsized if the total size of the fields adds to more than 450 characters.

Source:

http://www.ssw.com.au/ssw/UpsizingPRO/Upsizing-TalesFromTheBattleField.htm

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[meldrape]

Hi Terry,

After I set the permissions for those tables and made sure the Primary Fields were set properly, it seems to have upsized successfully. Thanks so much for all of your tips and tricks and suggestions.