Lock VBA

[alex]

Lock VBA

Hello,

I have a form object that I need to send to a group of users…

These users already have an mdb file and I thought one of the easiest
ways was to send them a “container” mdb that contained my form. Users
could simply open the “container” mdb and export my form to their mdb
file.

The aforementioned works, but I want to lock the VBA behind my form.
If I do this, users cannot export the form without first unlocking the
project/vba.

Any thoughts?

Thanks,
alex

 

[Douglas J. Steele]

Your application should be split into a front-end (containing the forms,
reports, macros and modules), linked to a back-end (containing the tables
and relations). Only the back-end should be on the server: each user should
have his/her own copy of the front-end, ideally on his/her hard drive.

In that way, you simply replace the front-end for each user, rather than
fussing with importing and the like. In fact, Tony Toews has an AutoFE
Updater utility available at http://www.autofeupdater.com/

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

Lock VBA

Hello,

I have a form object that I need to send to a group of users…

These users already have an mdb file and I thought one of the easiest
ways was to send them a “container” mdb that contained my form. Users
could simply open the “container” mdb and export my form to their mdb
file.

The aforementioned works, but I want to lock the VBA behind my form.
If I do this, users cannot export the form without first unlocking the
project/vba.

Any thoughts?

Thanks,
alex

 

[alex]

Your application should be split into a front-end (containing the forms,
reports, macros and modules), linked to a back-end (containing the tables
and relations). Only the back-end should be on the server: each user should
have his/her own copy of the front-end, ideally on his/her hard drive.

In that way, you simply replace the front-end for each user, rather than
fussing with importing and the like. In fact, Tony Toews has an AutoFE
Updater utility available athttp://www.autofeupdater.com/

--
Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)


Lock VBA

Hello,

I have a form object that I need to send to a group of users…

These users already have an mdb file and I thought one of the easiest
ways was to send them a “container” mdb that contained my form.  Users
could simply open the “container” mdb and export my form to their mdb
file.

The aforementioned works, but I want to lock the VBA behind my form.
If I do this, users cannot export the form without first unlocking the
project/vba.

Any thoughts?

Thanks,
alex

Thanks for responding Doug...

I understand the whole fe/be concept, but I'm just supplying the form
(to a db that I didn't create) and cannot reproduce the fe (the user's
mdb is not your typical relational model--it's a tool to query/
interact with ORACLE tables). Think of it as supplying an after-
market part to a preexisting machine.

With that said, what's your expert opinion?

 

[Douglas J. Steele]

If the data is being used to query Oracle tables, then it's a front-end.

What's different about it than any other front-end?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

Thanks,
alex

Thanks for responding Doug...

I understand the whole fe/be concept, but I'm just supplying the form
(to a db that I didn't create) and cannot reproduce the fe (the user's
mdb is not your typical relational model--it's a tool to query/
interact with ORACLE tables). Think of it as supplying an after-
market part to a preexisting machine.

With that said, what's your expert opinion?

 

[alex]

If the data is being used to query Oracle tables, then it's a front-end.

What's different about it than any other front-end?

--
Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)



Thanks for responding Doug...

I understand the whole fe/be concept, but I'm just supplying the form
(to a db that I didn't create) and cannot reproduce the fe (the user's
mdb is not your typical relational model--it's a tool to query/
interact with ORACLE tables).  Think of it as supplying an after-
market part to a preexisting machine.

With that said, what's your expert opinion?

I cannot replace this fe; I can only add to it!

 

[a a r o n _ k e m p f]

you should just try to keep your business logic on the database
server-- so you don't need to update frontends whenever you make a
change

moving to SQL Server / Access Data Projects makes it a lot easier to
manage databases for multiple users

thanks & good luck

-Aaron

 

[a a r o n _ k e m p f]

and for the record.. _YES_ SQL Server can link to Oracle databases

 

[Access Developer]

moving to SQL Server / Access Data Projects
makes it a lot easier to manage databases for
multiple users

Before you leap to follow Mr. Kempf's advice, you should understand that the
Access team no longer recommends ADPs as the method of choice for accessing
SQL Server. Classic ADO, on which the ADP is based, has been superceded in
the Microsoft world of "real development" (DotNet) by ADO.NET which is not
based on OLEdb and which uses a different object model.

The Access team recommends using MDB/ACCDB (or the "compiled versions"
MDE/ACCDE) with ODBC to link the SQL Server tables.

Just for the record, there are ODBC drivers for just about every server
database product, so you are not (as you are with ADP) limited to Microsoft
SQL Server. MS SQL Server should be given consideration when choosing a new
server DB, but many companies have, long since, chosen a different server DB
as their corporate standard, so ADPs are not appropriate in those
environments.

 

[a a r o n . k e m p f]

Larry;

you're a fucking idiot

The Access team wants you to stick on their sinking ship?
so fucking what?

What does the SQL Server team reccomend?

What is more popular, SQL Server or Jet?

 

[a a r o n . k e m p f]

and writing sprocs against Oracle, in ADP.. works _GREAT_