No Read Definitions Permissions

[Bert]

Hi, Ive just taken over someones role as application developer and I have a
problem accessing an Access 97 database. Ive found the password to get into
the database but as soon as I try and view data or change a table I get a
message

"Couldn't read definitions; no read definitions permissions for table or
query ....."

Now we use visual basic to access the data on this database and when its
creating the link to the database it is doing

' set db security file
If fso.FileExists(App.Path & "\bin\SECURITY.MDW") = True Then
SystemDB = App.Path & "\bin\SECURITY.MDW"
DBEngine.SystemDB = App.Path & "\bin\SECURITY.MDW"
DBEngine.DefaultUser = "vveadministrator"
DBEngine.DefaultPassword = "4EsZ99hN9IjN"
' Create Microsoft Jet Workspace object.
Set wrkSystemJet = DBEngine.CreateWorkspace("",
"vveadministrator", "4EsZ99hN9IjN", dbUseJet)
' Open Database object from saved Microsoft Jet database
Set dbSystemDatabase = wrkSystemJet.OpenDatabase(DATABASEPATH,
False, False, ";pwd=Zs05Gty83Mpl;")
End If


So Im presuming the default user and password enable read definitions to
occur, but is there a way of me getting into Access with this user and
password or do I have to relog into windows as this user or ??

Any pointers would be gratefully recieved

 

[Joan Wild]

You can create a desktop shortcut like:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to security.mdw"

The path to security.mdw is apparently the "path to where the mdb
is"\bin\security.mdw

Open via the shortcut and enter the username/password.

 

[Bert]

Is there something missing between

"path to msaccess.exe" "path to mdb"

??


Ive tried creating a short cut for

"path to msaccess.exe" "path to mdb" /wrkgrp "path to security.mdw"

but when I click next after entering it I get a message

"The file C:\Program cannot be found"

Ive check its OK by getting rid of "path to mdb" /wrkgrp "path to
security.mdw"
and then that just opens access (as expected) and also just

"path to mdb" /wrkgrp "path to security.mdw"

which opens up the database in question (still problems though)

 

[Joan Wild]

You need to include the double quotes around any path that has spaces in it.

When you say 'click next', that suggests you are using the create shortcut
wizard - I think you need to just browse to the location of msaccess.exe and
then click finish. Then right-click on the shortcut and choose properties
and modify the target by adding the "path to mdb" /wrkgrp "path to mdw"

 

[Bert]

Cheers Joan thats got me in,

Thank You!

You need to include the double quotes around any path that has spaces in it.

When you say 'click next', that suggests you are using the create shortcut
wizard - I think you need to just browse to the location of msaccess.exe and
then click finish. Then right-click on the shortcut and choose properties
and modify the target by adding the "path to mdb" /wrkgrp "path to mdw"

--
Joan Wild
Microsoft Access MVP

table definitions