Closed Thread Icon

Topic awaiting preservation: Any M$ Access pros out there? Pages that link to <a href="https://ozoneasylum.com/backlink?for=25561" title="Pages that link to Topic awaiting preservation: Any M$ Access pros out there?" rel="nofollow" >Topic awaiting preservation: Any M$ Access pros out there?\

 
Author Thread
bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted posted 04-20-2005 22:58

I'm doing an assignment and I have set up an access db which I'm using with a group. (Real basic IS for managment class). Anyway I ftp'd the mdb file to my site but when others in my group download the file they can't open it due to security restrictions.

Anyone know how to just kill any required permissions in Access?



.:[ Never resist a perfect moment ]:.

Moon Dancer
Bipolar (III) Inmate

From: The Lost Grove
Insane since: Apr 2003

posted posted 04-20-2005 23:17

I wouldn't call myself a probut I'll give it a stab...

What sort of message are they receiving about security restrictions? Did you setup anything special under the Tools>Security area? If you left that at defaults, it treats everyone who opens the database as an admin...

(Edited by Moon Dancer on 04-20-2005 23:18)

bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted posted 04-20-2005 23:57

I didn't set up any permissions. That's what I thought would happen. Maybe theres some version differences?



.:[ Never resist a perfect moment ]:.

Moon Dancer
Bipolar (III) Inmate

From: The Lost Grove
Insane since: Apr 2003

posted posted 04-21-2005 01:18

That could be...

It really depends on the message they are getting. If it's "Unrecognized database format" then it's definately a version issue. Hmmm... are they actually downloading it, or are they maybe choosing the Open option? If they are choosing the Open option, they might be running into each other... I dunno. I'd see if you can get more specific messaging - that would really help in determining what might be the problem.

ZaddyDog
Bipolar (III) Inmate

From: Canada
Insane since: Apr 2005

posted posted 04-21-2005 01:29
quote:
bitdamaged said:

Anyone know how to just kill any required permissions in Access?



As Moon Dancer posted, Access does not have any permissions or security restrictions set by default.
If it is locked, for example, you will see a lock appear on the file icon.

version errors (backwards compatibility issues) will usually give you an error message to that effect.

can you post a link to the file?

bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted posted 04-21-2005 01:41

http://isstrategy.sfsu.edu/~mryan05/team/music_db.mdb



.:[ Never resist a perfect moment ]:.

ZaddyDog
Bipolar (III) Inmate

From: Canada
Insane since: Apr 2005

posted posted 04-21-2005 01:58

It's not you - it's your friends. Are they on Access version 2.0?

Are they trying to open the file from a university that places restrictions on mdb files?

http://www.ephotohut.net/viewpic.cfm?pic=200405194013.jpg

edit: pic shows Access 2000, i used Access 2002 to open file

p.s. why can't this file be displayed -cold fusion served??



so much for ephoto -screw them



(Edited by ZaddyDog on 04-21-2005 02:26)

ZaddyDog
Bipolar (III) Inmate

From: Canada
Insane since: Apr 2005

posted posted 04-21-2005 03:39

http://www.ust.hk/itsc/msoffice/compatible.html

quote:
MS Access 97 and 2000 will have problems due to the newly supported of the Unicode format in Access 2000.



anything older than Access 2000 will not be able to read your file:
Access 2, Access 95, Access 97 won't work

Moon Dancer
Bipolar (III) Inmate

From: The Lost Grove
Insane since: Apr 2003

posted posted 04-21-2005 07:06

bitdamaged,

I think I figured out the problem. Due to the recent security updates to either IE or SP2 (not sure which is the culprit) Windows is basically saying the .mdb came from an untrusted site and won't open the database. If the user right clicks on the database, selects Properties and clicks the Unblock button, they should be able to open the database.

« BackwardsOnwards »

Show Forum Drop Down Menu