<div>
You can certainly create a new logical but it will still need some sort of uniqure key for Access to deal with it. &nbsp;If there is no unique key at all, how do you maintain the records in the file? &nbsp;Is it a dumping ground for logs or something like that? &nbsp;Is there a date\time stamp?<br />
<br />
Jon
</div>


You can certainly create a new logical but it will still need some sort of uniqure key for Access to deal with it.  If there is no unique key at all, how do you maintain the records in the file?  Is it a dumping ground for logs or something like that?  Is there a date\time stamp?

Jon

<div>
See notes above, worked with IBM on the solution
</div>


See notes above, worked with IBM on the solution

<div>
<div class="content wysiwyg-content">
I would like to use Windows Access 2010 to modify an AS400 Physical File.<br />
<br />
The AS400 file has No Key and no combination of fields will create a Unique Key.<br />
<br />
I can access the file using iSeries Access using a Linked Table ODBC Connection.<br />
<br />
Is there any way to create a logical file on the AS400 with a unique key or<br />
create a psuedo unique key in Windows Access in the link.<br />
<br />
Without a unique key the file cannot be updated in Windows Access
</div>
</div>


I would like to use Windows Access 2010 to modify an AS400 Physical File.

The AS400 file has No Key and no combination of fields will create a Unique Key.

I can access the file using iSeries Access using a Linked Table ODBC Connection.

Is there any way to create a logical file on the AS400 with a unique key or
create a psuedo unique key in Windows Access in the link.

Without a unique key the file cannot be updated in Windows Access

AS400 iSeries Access Unique Index for Windows Access

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.