Import/Export Tables

[mishbaker]

Using my front-end, I need to export tables to an export.mdb that can be sent via email. The back-end is secure and presenting problems for me. I'm trying to transferdatabase from the back-end into my front-end then transferdatabase to the export.mdb. After that is done it is set to delete the tables in my front end.

My main problem is the password on my backend. How do I get around that? It asks me to input the password then when I do it tells me it's wrong. Which I know is BS since I try opening it normally and it works fine!

Is there a better way to import/export tables from a db? I have to keep the autonumber in tact, so I'm not using a query.

Thanks in advance

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[Ed2020]

How have you secured your backend? With user-level security, or just with a database password?

Ed Metcalfe.

Please do not feed the trolls.....

 

[mishbaker]

Just with a database password.

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[Ed2020]

Strange, it works fine for me with Access 2000. Which version of MS Access are you using?

To be honest I'd recommend not using database passwords but putting the extra time into implementing full user-level security. The offer a far greater degree of security, once the user has opened the system, a database password offers no protection at all.

Ed Metcalfe.

Please do not feed the trolls.....

 

[mishbaker]

I use it to keep the riff raff out. I tried to implement full security following the FAQ but was unable.

I am currently working in Access 2000. I got it to work with the password entered manually, but is there a way to do it without entering a password for each table?

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[Ed2020]

Not that I'm aware of, but then I don't use database passwords so I don't have much in the way of experience.

If you want to use a database password rather than user-level security then I think you'd be better off not splitting the system into a frontend/backend.

Try using the wizard to set up user-level security. The one in Access 2000 and onwards is pretty good and easy to use.

Ed Metcalfe.

Please do not feed the trolls.....