read an old protect Access database (version 1.1) with VB5
Quote:
> I'am trying to read an old protect Access database (version 1.1) with
> VB5
> I'am doing
> DbEngine.SystemDB = " C:\DATA\SYSTEM.MDA "
> Set wk = DbEngine.CreateWorkSpace(" MyWK ", "USER1 ", _
> "MyPWD"",dbUseJet)
> On this last line, an error occur : Can't find the workgroup file.
> Excuse my bad english
Hmm... let me hint you in on some information.
You do NOT need a workspace. I don't use one myself and create databases
all the time, neither do the people I know use a workspace.
I believe checking the DAO3.5 refrence under the project menu and
simply;
' General Delcarations
option explicit
dim db as database
dim rs as recordset
Public Function OpenDB
' Function
set db = OpenDatabase("c:\datab\system.mda")
set rs = db.openrecordset("Select [field] from [table]")
End Function
and then do what you want to do with the database.
--
Ryan Banas (Compe)
