Error Message

[George]

I have an old program that I created many years ago and I have the password
but it gives me an error message when I try to open it: "The current user
account doesn't have permission to convert or enable this database" How can I
correct this -I thing it's looking for a file that would be on the computer I
used to create it - if thats the case I'm out of luck !

Thanks

[Jackie L]

Was your password set up through security in Access or was it based on an
outside source? Try to import your objects into a new database to see if you
can get past the error.

[George]

Jackie - I copied all the objects into a new database and when it opens at
takes me to the Visual Basic screen with an Error message "User Defined Type
not Defined" the following text is highlighted Dim dbs As Database. Which
leaves me clueless

[AccessVandal via AccessMonster.com]

What version of Access? Sounds like a References problem.

George wrote:
>Jackie - I copied all the objects into a new database and when it opens at
>takes me to the Visual Basic screen with an Error message "User Defined Type
>not Defined" the following text is highlighted Dim dbs As Database. Which
>leaves me clueless

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200912/1

[John W. Vinson]

On Thu, 24 Dec 2009 02:05:16 GMT, "AccessVandal via AccessMonster.com"
<u18947@uwe> wrote:

>What version of Access? Sounds like a References problem.
>
>George wrote:
>>Jackie - I copied all the objects into a new database and when it opens at
>>takes me to the Visual Basic screen with an Error message "User Defined Type
>>not Defined" the following text is highlighted Dim dbs As Database. Which
>>leaves me clueless

Agreed. This is a pretty common symptom - open the VBA editor, select Tools...
References, and find the "Microsoft DAO x.xx Object Library" (use the highest
version, probably 3.6).

It's probably best to use unambiguous references - Dim dbs As DAO.Database,
Dim rs As DAO.Recordset.
--

John W. Vinson [MVP]

[George]

I don't know what version of Access - I can't open it - I created somewhere
back in early 90's. The only way I can get into it is create a new database
and import all the objects, but when I try to open the new database I get
error messages.

Will look at the references - Thanks

"John W. Vinson" wrote:

> .
>

[John W. Vinson]

On Thu, 24 Dec 2009 06:10:01 -0800, George <Geo...@discussions.microsoft.com>
wrote:

>I don't know what version of Access - I can't open it - I created somewhere
>back in early 90's. The only way I can get into it is create a new database
>and import all the objects, but when I try to open the new database I get
>error messages.

Probably Access 2.0 if it's in fact "early" 90's, and that may cause some real
problems; 2.0 was a 16 bit application, and Access 95 and later are 32 bit.
The VBA code changed fairly drastically in the process and some of it may need
to be revised.

Try opening it while holding down the Shift key to bypass any start code. You
may want to refer to Tony Toews' website - IIRC he had some writeups about
converting from 2.0:

http://www.granite.ab.ca/access

[George]

John - I copied the program to my newer laptop running Vista and Office 2007.
Then created a new database in Office 2007 and imported the files from the
old database. Strangely enough its works without any problems - must be the
version I created it in is no longer compatible - thanks for the tip !!!

Happy Holidays....

"John W. Vinson" wrote:

> .
>

[AccessVandal via AccessMonster.com]

That's good to hear.

Yes, if use a new accdb in 2007 there's no need disambiguous references
bacause the default is the newer ACE reference.

George wrote:
>John - I copied the program to my newer laptop running Vista and Office 2007.
>Then created a new database in Office 2007 and imported the files from the
>old database. Strangely enough its works without any problems - must be the
>version I created it in is no longer compatible - thanks for the tip !!!
>
>Happy Holidays....

--

Please Rate the posting if helps you.

Message posted via http://www.accessmonster.com