Dynamic adding of primary key in Access 2.0
Quote:
>Hello everybody,
>The database I'm creating in Access 2.0 needs to import tables with no key
>from a server, edit them and send them back to the server. While editing
>I want to enable the user to sort the table using different fields. My
>specific question is:
>is it possible to mark one of the fields in the table as a primary key
>dynamiclly? and if it is possible, how to do it?
Check out http://www.*-*-*.com/ :2080/VisualBasicSource/
for the section Access
Working with Access without the data control
working with SQL command Like
adding a Field at runtime to an existing table
adding a Index at runtime to an existing table
making a database, table, fields and indexes at runtime
use a Date in SQL
checking if data-field is empty
4 ways to search for a record
exporting acces database to ascii file
making the WHERE from one textbox
gr. walther
----- never stop here -----
Walther Musch; http://www.*-*-*.com/ :2080/VisualBasicSource/
Get PR-Tracker -- tracks problem reports, defects, bugs
INFORMATION: http://www.*-*-*.com/
DOWNLOAD: http://www.*-*-*.com/
