By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Removing an index unique key

P: 2
I have a table which has an index unique key.

However the Access DB is installed in a PC which I have no access and its operated by a user with no Access knowledge.

So I need to create a script will help me remove the index key by someone with no knowledge of Aceess Database.

Ideally will be a script which can be executed by double clicking on a file and will make the appropriate changes in the Access DB.

Thanks in advance.
Jan 8 '08 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,366
Why would you need to remove a primary key? They are there to prevent duplicates. And for relationships.
Jan 8 '08 #2

jaxjagfan
Expert 100+
P: 254
Do you actually need to remove the index? Are you using the data exported for another process and just dont need the index column? I know you said the User doesn't know anything about Access but someone set that user up with Access to support some sort of business process (I assume). Deleting the primary key could cause any queries and/or functions to stop working and (As Stated) allow duplicates.

BTW - What you are looking for is a VBS script but even that will not modify a Jet (Access) data structure.

What sort of process are you trying to accomplish? If possible give us some details. I am sure with all of the processes all of the members here have been faced with that we can provide a viable solution.
Jan 8 '08 #3

P: 2
Ok I need to be more clear.

Its not the actually primary key of the table. Was added later as a unique key due to client requirement to stop the user insert new records which will have the same date.

So I went into the database and I crated an index key type unique and added the date field. Now the process has change and they want me to remove that restriction. However this applications has been sent to 3000+ users and I can not ask them every single one go and change there database by themselves.

So I need a kind of script who will remove the additional unique key from the index so they can click on the file and execute the change on the access database.

Maybe do not need to delete the index just need to alter it from unique key to something else.
Jan 10 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.