topic Use .dbf for VBA in VBA Forum

Use .dbf for VBA

Anonymous — Wed, 13 Dec 2000 16:35:50 GMT

Dear All,

1. My user do not have install Excell or
Access.

Is there any way for me to use
.dbf as Database to develop my program?

Or I can use Excel or Access to
develop my program and they can use my program?

2. I have load my menu to ACAD,

File name =
MyMenu.mns

***MENUGROUP=MyMenu
***POP15

**MyPopMenu

[My
Function]
........

In LISP:

(setvar "FileDia"
0)

(command "Menuload"
"MyMenu")

(menucmd
"ACAD.POP11=+MyMenu.POP15")

But it does not show my pop menu
on the screen. Why?

Thanks in advance!

Arno Weng

Re: Use .dbf for VBA

Anonymous — Thu, 14 Dec 2000 08:42:00 GMT

RE: #1

I use MS-Access & ADO with AutoCAD. The
.Mdb's are built on a development machine which has Access. The user's
machines do not require Access, as long as no Access-native forms or
reports are used. You can also connect to .Dbf's using ADO. I find
using .Mdb's is somewhat easier.

--
John Goodfellow
irtf'nm
use 'microtouch' in address to email

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Arno Weng" <
href="mailto:Arno.Weng@slatw.com">Arno.Weng@slatw.com> wrote in message

href="news:37B9392F6996767EF405096F7472EDE1@in.WebX.SaUCah8kaAW">news:37B9392F6996767EF405096F7472EDE1@in.WebX.SaUCah8kaAW...

Dear All,

1. My user do not have install Excell or
Access.

    Is there any way for me to use
.dbf as Database to develop my program?

    Or I can use Excel or Access
to develop my program and they can use my program?

2. I have load my menu to ACAD,

    File name =
MyMenu.mns


***MENUGROUP=MyMenu
    ***POP15

    **MyPopMenu

    [My
Function]
    ........

    In LISP:

    (setvar "FileDia"
0)

    (command "Menuload"
"MyMenu")

    (menucmd
"ACAD.POP11=+MyMenu.POP15")

    But it does not show my pop
menu on the screen. Why?

Thanks in advance!

Arno Weng

Re:

Anonymous — Fri, 15 Dec 2000 16:55:27 GMT

Dear John,

If I use ADO & MS-Access, does user need install or
setup anything?

Thanks!

Arno Weng

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"John Goodfellow" <
href="mailto:jgoodfellow@bitbucket.com">jgoodfellow@bitbucket.com>

href="news:D7F0C0F40947ED8E51EB8E735EDE5A55@in.WebX.SaUCah8kaAW">news:D7F0C0F40947ED8E51EB8E735EDE5A55@in.WebX.SaUCah8kaAW...

RE: #1

I use MS-Access & ADO with AutoCAD. The
.Mdb's are built on a development machine which has Access. The user's
machines do not require Access, as long as no Access-native forms or
reports are used. You can also connect to .Dbf's using ADO. I find
using .Mdb's is somewhat easier.

--
John Goodfellow
irtf'nm
use 'microtouch' in address to email

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Arno Weng" <
href="mailto:Arno.Weng@slatw.com">Arno.Weng@slatw.com> wrote in
message
href="news:37B9392F6996767EF405096F7472EDE1@in.WebX.SaUCah8kaAW">news:37B9392F6996767EF405096F7472EDE1@in.WebX.SaUCah8kaAW...

Dear All,

1. My user do not have install Excell or
Access.

    Is there any way for me to
use .dbf as Database to develop my program?

    Or I can use Excel or Access
to develop my program and they can use my program?

2. I have load my menu to ACAD,

    File name =
MyMenu.mns


***MENUGROUP=MyMenu
    ***POP15

    **MyPopMenu

    [My
Function]
    ........

    In LISP:

    (setvar "FileDia"
0)

    (command "Menuload"
"MyMenu")

    (menucmd
"ACAD.POP11=+MyMenu.POP15")

    But it does not show my pop
menu on the screen. Why?

Thanks in advance!

Arno Weng

Re:

Anonymous — Tue, 19 Dec 2000 07:18:18 GMT

You will need to run MDAC_TYP.EXE on the user's
machine to install MS Data Access Components (ADO). If you use an
installer, it can run the .EXE so that the user will not need to. Of
course, you need to make the .MDB's available also.

--
John Goodfellow
irtf'nm
use 'microtouch' in address to email

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Arno Weng" <
href="mailto:Arno.Weng@slatw.com">Arno.Weng@slatw.com> wrote in message

href="news:6780BA1C23FDC9528D569BFA353F7BD3@in.WebX.SaUCah8kaAW">news:6780BA1C23FDC9528D569BFA353F7BD3@in.WebX.SaUCah8kaAW...

Dear John,

If I use ADO & MS-Access, does user need install or
setup anything?

Thanks!

Arno Weng

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"John Goodfellow" <
href="mailto:jgoodfellow@bitbucket.com">jgoodfellow@bitbucket.com>

href="news:D7F0C0F40947ED8E51EB8E735EDE5A55@in.WebX.SaUCah8kaAW">news:D7F0C0F40947ED8E51EB8E735EDE5A55@in.WebX.SaUCah8kaAW...

RE: #1

I use MS-Access & ADO with AutoCAD.
The .Mdb's are built on a development machine which has Access. The
user's machines do not require Access, as long as no Access-native
forms or reports are used. You can also connect to .Dbf's using
ADO. I find using .Mdb's is somewhat easier.

--
John Goodfellow
irtf'nm
use 'microtouch' in address to
email

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Arno Weng" <
href="mailto:Arno.Weng@slatw.com">Arno.Weng@slatw.com> wrote in
message
href="news:37B9392F6996767EF405096F7472EDE1@in.WebX.SaUCah8kaAW">news:37B9392F6996767EF405096F7472EDE1@in.WebX.SaUCah8kaAW...

Dear All,

1. My user do not have install Excell or
Access.

    Is there any way for me to
use .dbf as Database to develop my program?

    Or I can use Excel or
Access to develop my program and they can use my program?

2. I have load my menu to ACAD,

    File name =
MyMenu.mns


***MENUGROUP=MyMenu
    ***POP15

    **MyPopMenu

    [My
Function]
    ........

    In LISP:

    (setvar "FileDia"
0)

    (command "Menuload"
"MyMenu")

    (menucmd
"ACAD.POP11=+MyMenu.POP15")

    But it does not show my
pop menu on the screen. Why?

Thanks in advance!

Arno Weng

Re:

Anonymous — Tue, 19 Dec 2000 16:36:48 GMT

Thanks!

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"John Goodfellow" <
href="mailto:jgoodfellow@bitbucket.com">jgoodfellow@bitbucket.com>
撰寫於郵件
href="news:99272B70607532EDE28C56282FB8148F@in.WebX.SaUCah8kaAW">news:99272B70607532EDE28C56282FB8148F@in.WebX.SaUCah8kaAW...

You will need to run MDAC_TYP.EXE on the user's
machine to install MS Data Access Components (ADO). If you use an
installer, it can run the .EXE so that the user will not need to. Of
course, you need to make the .MDB's available also.

--
John Goodfellow
irtf'nm
use 'microtouch' in address to email

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Arno Weng" <
href="mailto:Arno.Weng@slatw.com">Arno.Weng@slatw.com> wrote in
message
href="news:6780BA1C23FDC9528D569BFA353F7BD3@in.WebX.SaUCah8kaAW">news:6780BA1C23FDC9528D569BFA353F7BD3@in.WebX.SaUCah8kaAW...

Dear John,

If I use ADO & MS-Access, does user need install
or setup anything?

Thanks!

Arno Weng

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"John Goodfellow" <
href="mailto:jgoodfellow@bitbucket.com">jgoodfellow@bitbucket.com>

href="news:D7F0C0F40947ED8E51EB8E735EDE5A55@in.WebX.SaUCah8kaAW">news:D7F0C0F40947ED8E51EB8E735EDE5A55@in.WebX.SaUCah8kaAW...

RE: #1

I use MS-Access & ADO with AutoCAD.
The .Mdb's are built on a development machine which has Access. The
user's machines do not require Access, as long as no Access-native
forms or reports are used. You can also connect to .Dbf's using
ADO. I find using .Mdb's is somewhat easier.

--
John Goodfellow
irtf'nm
use 'microtouch' in address to
email

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Arno Weng" <
href="mailto:Arno.Weng@slatw.com">Arno.Weng@slatw.com> wrote in
message
href="news:37B9392F6996767EF405096F7472EDE1@in.WebX.SaUCah8kaAW">news:37B9392F6996767EF405096F7472EDE1@in.WebX.SaUCah8kaAW...

Dear All,

1. My user do not have install Excell or
Access.

    Is there any way for me
to use .dbf as Database to develop my program?

    Or I can use Excel or
Access to develop my program and they can use my program?

2. I have load my menu to
ACAD,

    File name =
MyMenu.mns


***MENUGROUP=MyMenu
    ***POP15

    **MyPopMenu

    [My
Function]
    ........

    In LISP:

    (setvar "FileDia"
0)

    (command "Menuload"
"MyMenu")

    (menucmd
"ACAD.POP11=+MyMenu.POP15")

    But it does not show my
pop menu on the screen. Why?

Thanks in advance!

Arno Weng