Re: DAO 3.51
- From: "Dave O." <nobody@xxxxxxxxxxx>
- Date: Thu, 14 Jun 2007 15:05:25 +0100
Hi
Not sure if this will help you but I notice you don't set up any User ID in
the creation so it may be superfluous in the open statement.
It seems a bit strange to create with DAO and access with ADO, you mention
recordsets but DAO seems quite content with recordsets (unless there is a
specific flavour you need!).
Unfortunately I am not very familiar with ADO but do try the string without
the User ID also I think the string should be terminated with a ;
If none of this helps you, it might be useful to look at the
microsoft.public.vb.database NG
Regards
Dave O.
"Rick" <Rick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0404FCE4-E269-469B-BA03-857915841C93@xxxxxxxxxxxxxxxx
Sure.
DB Creation(DAO):
Set dbLocal = DBEngine.CreateDatabase("C:\WorkDir\MyDB.mdb", dbLangSpanish
&
";pwd=Mypwd", dbEncrypt)
--- later ---
DB Connectio(ADO):
MyCnn.Open "Provider=Microsoft.Jet.OLEDB.3.51; Data
Source=C:\WorkDir\MyDB.mdb;User ID =Admin;password=Mypwd"
And the error is that there is a problem with password or User ID.
--
Thanks,
Rick.
"Every problem needs a fast and efficient solution"
"Dave O." wrote:
"Rick" <Rick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC5B4EEE-BEC5-45C7-8D1A-E9ACDC1D3710@xxxxxxxxxxxxxxxx
<<snip>>
I get an error
I'm using a standard connection string.
And that connection string is.....
For something like this you really need to show us what you've got and
TELL US WHAT ERROR YOU GET!
I'm sorry to shout but "I get an error" tells us exactly nothing.
Dave O.
.
- References:
- Re: DAO 3.51
- From: Dave O.
- Re: DAO 3.51
- Prev by Date: Re: Can't convert LinkedList(Of X) to LinkedList(Of Y) even tho X inherits Y
- Next by Date: HtmlHelp reload same file
- Previous by thread: Re: DAO 3.51
- Next by thread: Re: DAO 3.51
- Index(es):
Relevant Pages
|
