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

Moving data to a new access database

100+
P: 229
Hi, I wonder if anyone can advise. I am moving my website from one access database to another. The new database has passwords, PasswordKey and PasswordEncrypted which the old one didnt have. I have over a thousand members to transfer. To input them all manualy in the control panel would take ages. Is there a way to do this as a batch? The trouble is the PasswordEncrypted etc fields require data and obviously a correct encryption which it seems only by adding each in the control panel will do.
Any suggestion would be great.
Thanks
Richard
May 11 '09 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,709
I don't know about this, but are you saying there is a password set on a per field basis? Your post seems unclear.

I've used password protected databases before, which a relatively straightforward. You link the tables across to another db which also links to the alternative and copy from one set of tables to the other.
May 11 '09 #2

100+
P: 229
Hi, thanks. Sorry I mean that the new database is actually a login database for an application and so there is a password field for each user. for example there are 5 fields. I am trying to move my old database of users without the password field to the new one.
password,passwordencrypt,name,surname,address
My old database doesnt have a password field. The passwords for each user in the new database are created when one adds a user in the control panel. Trouble is I have over 1000 people to enter and am looking for a way to add them to the new database without doing it manually one by one via the control panel. The thing would be how to create a thousand passwords and passwordencrypts for the fields.
Thanks for your reply.
Richard
May 12 '09 #3

NeoPa
Expert Mod 15k+
P: 31,709
Let me see if I can get this straight.

You have an old table, in an old database, with four fields ([PasswordEncrypt],[Name],[Surname],[Address]).
You want to copy all this data into a new table in a new database with five fields ([Password],[PasswordEncrypt],[Name],[Surname],[Address]).

You've said nothing about any constraints on any of this data, so I'll assume setting a default value for all records is fine. If not, then please feel free to update with any important information.

My suggested solution would be to :
  1. Set a default value in the table design for your [Password] field (No default results in a default of Null).
  2. Link to the old table in the old database.
  3. Design a query to copy the records from the old to the new
  4. Execute the query.
As far as I can understand from what you've said (so far at least), this should work.

Let us know how you get on.
May 12 '09 #4

100+
P: 229
Hi, Thanks, thats right, I will give that a go. Let you know how I get on.
Thanks
Richard
May 12 '09 #5

Post your reply

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