DAO and MS Access

Printable View

Apr 12th, 2005, 11:18 AM
oyad

DAO and MS Access

am using DAO in my VB project with means my Access has to be in MS Access 97. its working fine but i want to passwordthe mdb file. i dont know how to open the file in VB, icant set the password property or whats wrong
dayo :o

Re: DAO and MS Access

VB Code:

Set objDB = OpenDatabase("C:\SomePath\SomeName.mdb", _
                              True, False, ";pwd=yourpassword")

Apr 12th, 2005, 11:32 AM
RobDog888

Re: DAO and MS Access
You need to set the password in Access first. Then you need to create a DAO workspace to connect and pass a password.
VB Code:
```
Private wsDB As Workspace
Private dbDB As Database
Set wsDB = DBEngine.CreateWorkspace("Username", "admin", "pwd")
Set dbDB = wsDB.OpenDatabase("DBName")
```
Apr 12th, 2005, 12:48 PM
haruki

Re: DAO and MS Access

Weird, Im using Access 2003 with DAO. I dont think its limited to the old 97 version.
Apr 12th, 2005, 12:54 PM
BruceG

Re: DAO and MS Access

Correct, DAO still lives on.
Apr 12th, 2005, 01:07 PM
oyad

Re: DAO and MS Access

Quote:

Originally Posted by haruki

Weird, Im using Access 2003 with DAO. I dont think its limited to the old 97 version.

whenever i set the database name in the property window, when i get to the recordsource property,i receive an error, so i tried converting the mdb to 97, using tools menu in access and henceforth it worked fine. so i guessed it was the version. or what do u think?
Apr 12th, 2005, 01:15 PM
RobDog888

Re: DAO and MS Access

I thought that in order to make changes to a 97 db you needed to convert it to 2000. Then it doesnt matter
which version of Access your running.

Are you using the Data control to try to connect?
Apr 12th, 2005, 01:25 PM
Hack

Re: DAO and MS Access

Quote:

Originally Posted by RobDog888

I thought that in order to make changes to a 97 db you needed to convert it to 2000. Then it doesnt matter
which version of Access your running.

Are you using the Data control to try to connect?

If you have the lastest version of MDAC installed (2.7 I believe), you can use DAO with Access 2000 (I know...I accidentally converted my 97 Access copy of Biblio to Access 2000 against which I was running some DAO code on other problem on the forum, and got myself all bollaxed up because my version of MDAC wasn't up to date.)
Apr 12th, 2005, 01:49 PM
RobDog888

Re: DAO and MS Access

Actually the latest MDAC is 2.8. Its included in Windows XP SP2, so if the thread starter is running that then
that could be an issue?
Apr 12th, 2005, 03:25 PM
GregLoutsenko

Re: DAO and MS Access

implementing just a single password potentially is a bad idea. if in the future u r trying to expand the app for multi users u will not be able to create users, so u cant set access permision. look up workgroup info files for further info on this.

ps
i am coding a security sys for my app at the minute which uses workgroup file and its prooving to be very hard as i cant find any good tutorials on it and the documentation isnt very good
Apr 23rd, 2005, 01:53 PM
oyad

Re: DAO and MS Access

plz, when i try to open the app on an OS with no VB installed , i received errors,
something like this

runtime error "713"
class not registered,looking for object with CLSID: {00000010-0000-0010-8000-00AA00602EA4}

how am i goona fix this thru my VB code (including other means)?
waiting
Apr 23rd, 2005, 05:34 PM
si_the_geek

Re: DAO and MS Access

You can't fix it in code, you need to create an installation package for your program.

You can use the Package & Deployment Wizard that comes with VB (it should be on your start menu), or one of the many alternatives (see our Application Deployment forum for details & advice).
Apr 27th, 2005, 12:37 PM
oyad

Re: DAO and MS Access

Quote:

Originally Posted by si_the_geek

You can't fix it in code, you need to create an installation package for your program.

You can use the Package & Deployment Wizard that comes with VB (it should be on your start menu), or one of the many alternatives (see our Application Deployment forum for details & advice).

something like using regserver from VB from the application is launched and un-register it when the application closes because the application will not be distributed as an installation but as a stand -alone EXE on a CDROM disk
Apr 27th, 2005, 12:45 PM
Hack

Re: DAO and MS Access

Quote:

Originally Posted by oyad

something like using regserver from VB from the application is launched and un-register it when the application closes because the application will not be distributed as an installation but as a stand -alone EXE on a CDROM disk

This isn't going to work as you are finding out. You must create an installation package that will include all of the dependancy files required by your .Exe or the program will never, ever, run.

The installation package, not the .Exe should be on the CD, and the customer should be provided with instructions on how to run the install.
Apr 28th, 2005, 01:50 PM
oyad

Re: DAO and MS Access

Quote:

Originally Posted by Hack

This isn't going to work as you are finding out. You must create an installation package that will include all of the dependancy files required by your .Exe or the program will never, ever, run.

The installation package, not the .Exe should be on the CD, and the customer should be provided with instructions on how to run the install.

hi, plz can u help, i just discovered that the rest app had similar problems-like error-one of its dependences not file or missing file , for tabctl32.ocx,winsock.ocx,flxgrd.ocx etc. any tip or solution.
plz, am waiting!
oyad :wave: :) :cry: :o
Apr 28th, 2005, 01:54 PM
RobDog888

Re: DAO and MS Access

Like Hack suggested, you need to create an installation package. You can use the P&D Wizard that
comes with VB to create one or download one from the Application Deployment FAQ forum.