Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently December 22nd, 2024, 8:59 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Deleting records from a database.
PostPosted: September 20th, 2005, 10:59 am 
Offline

Joined: October 25th, 2004, 12:32 pm
Posts: 397
Location: Digital Workshop
Q: I have created a publication that uses a Database; I am able to
view the records but am unable to delete records. When I check the box
to edit or amend, no table is shown in the SQL wizard.


A:
To allow Opus to delete a record from your database your
database must have a Primary Key. In Access open your table in Design
View and either add a new Auto Number field or right click on an existing
files and select Primary Key from the presented option.


Regards

Brenden Knifton
DW


For this message Brenden Knifton has been thanked by : mackavi


Top
 Profile Visit website  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group