Moving data to a new access database

[fran7]

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

[NeoPa]

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.

[fran7]

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

[NeoPa]

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.

[fran7]

Hi, Thanks, thats right, I will give that a go. Let you know how I get on.
Thanks
Richard