Runs fine, but chokes on database when compiling
Hi there,
In VB, by default it use workspaces(0). if you want to create another
workspace, then open database under the workspace, you have to change your
code to:
'wkspace is the new workspace that you created
Set dbs = wkspace.OpenDatabase(ResumeDirectory & "Resumes.mdb")
Quote:
>I'm creating a program that runs fine in the Visual Basic environment, but
>chokes with a "Permission Denied" error when I try to compile it. I think
>it's having a problem creating a workspace, but I don't know why. Here's
>where it has the problem:
>Set dbs = OpenDatabase(ResumeDirectory & "Resumes.mdb")
>If I try to create the workspace, then execute this line, it will {*filter*}
>where the workspace is being created first.
>This is driving me nuts.
