Security Access to a database

[Bernie]

my partner and I are the administrators of our database when it was 2003. We
brought the database into 2007 and everything seemed alright till we created
a backend database and used the frontend to input data as we did with no
problems in 2003. Now it won't let us access the database, back or front
end.

Is there a way to wipe out the security settings and start clean?

 

[Gina Whipp]

Bernie,

Access 2007 requires that the files be in a Trusted Location. Have a look
at...

http://www.regina-whipp.com/index_files/TrustedLocation.htm

Oh, and you can't *wipe that out*.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Bernie]

Thanks Gina.

We went to our backup and started over and did what you recommended. Our
next problem is that we export our data to an Excel spreadsheet. Our macro
for 2003 worked great; however, the error we get now is Excel doesn't
recogized the database. Our db suffix is "accdb" and not the old "mdb". Any
suggestions?

 

[Gina Whipp]

Bernie,

I believe that was fixed with the second patch (or update). Are you up to
date with all your patches?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Providing the resolution as Bernie provided me with a sample file...

Turns out the database was Access 2007 but the Excel spreadsheet was in
2003. Once the spreadsheets were converted all appears to be functioning!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm