RE: Quick Access Toolbar and Runtime

Sorry this is in the wrong thread. I'll try to repost it.

"KateAtSIS" wrote:

I do not want the users to have access to the Quick Access Toolbar.

I tried renaming the .accde to .accdr That works fine for the first
database, but we connect to other databases using:

Const strConPathToSamples = "D:\Database\dbenroll.accdr"

Set appAccess = _
CreateObject("Access.Application")
appAccess.OpenCurrentDatabase strConPathToSamples

This give me the following error:

"Microsoft Office Access can't open the database because it is missing, or
opened exclusively by another user, or it is not an ADP file."

Noone else is on the machine, there are no L files for the database I am
trying to open.


.

Relevant Pages

  • Re: Compressing a .mdw file
    ... >> we copy it and compress it using Tools | Database ... >> We decided to compress it by writing a program and using ... >> then renaming the original to x.old and renaming the new ... >Dim jro As JRO.JetEngine ...
    (microsoft.public.access.security)
  • Re: Script in GUI (Was: openSUSE as a router, how to? Solved!)
    ... test if there is nothing busy with using the database, ... I understand the rpm bit. ... It's not the renaming that does it. ... The partition in question is ext3. ...
    (alt.os.linux.suse)
  • Re: How can I rename a database table?
    ... You may want to ask this in an SQL group, but perhaps you'll have to write a stored procedure to do this sort of thing and it could be that the queries you do through the MFC interface are more restricted. ... As a result of my limited database and MFC knowledge I am having ... theDataBase.ExecuteSQL("RENAME oldTableName TO newTableName"); ... Can anyone suggest a way of renaming this table programmatically? ...
    (microsoft.public.vc.mfc)
  • Re: DataReader Seek
    ... I tried compacting the database and renaming back to the original name and got the same result. ... the array notation above or do a new SqlInt32 and set it to a value of 9. ...
    (microsoft.public.sqlserver.ce)
  • Re: Compressing a .mdw file
    ... > we copy it and compress it using Tools | Database ... > We decided to compress it by writing a program and using ... > then renaming the original to x.old and renaming the new ... Dim jro As JRO.JetEngine ...
    (microsoft.public.access.security)