By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

access-vb problems...

P: n/a
Hi All,

This is what I want to do:
1. Build a database in Access with certain queries and a query form.
(DONE).
2. I now need to use the same form as a form in VB, this will be the front
page and will additionally have the following functions on it: Print, Save
(CSV), Import (CSV).
3. On top of that the program will function - solely as a stand-alone
program. I want to be able to modify the fields from within Access and for
that to cause the software to change the fields based on the database.
4. I DON'T want the end user to be able to figure out that the .mdb
database is .mdb and open it, and thus reverse engineer it. I want to
encrypt it, so that only I or my program can unencrypt the data, as well as
calling it something like .dbd (DataBase Data).
5. I want to offer updates to the office. The updates will be distributed
in the - .dbd file, which will be encrypted. The extra option under the
file menu will be Update, the update can't affect the real program.
6. At a later date, I want to put an option to have pictures in one Access
field, without ruining the program and having to recompile, I want it to be
importable in an update, or to be left in, but only activated in a later
update, and the program will currently have "This Feature Is Not Yet
Available..." (The company I am currently working for is not in a stable
position, I want to force them in to keeping me till the end).

In short I need a VB app that will run a MSAccess database input & output
from the query forms, however as a stand-alone application and not possible
to see through the database. The database will have to be suffixed with
something other than .mdb and encrypted, with the software understanding
that encryption. The software also needs to have a File menu with | Import
(CSV), Save (CSV), Print & Update. The software needs to have the facility
to add pictures at a later date for via the database.

Can anybody help me, please?

Thanks,
Pickles.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Sorry, forgot to mention all is using VB6! NOT .NET.
"Jonathan (Pickles) Sklan-Willis" <me@picklesgeek.net> wrote in message
news:cg4vc.47$PT.38@newsfe6-win...
Hi All,

This is what I want to do:
1. Build a database in Access with certain queries and a query form.
(DONE).
2. I now need to use the same form as a form in VB, this will be the front page and will additionally have the following functions on it: Print, Save
(CSV), Import (CSV).
3. On top of that the program will function - solely as a stand-alone
program. I want to be able to modify the fields from within Access and for
that to cause the software to change the fields based on the database.
4. I DON'T want the end user to be able to figure out that the .mdb
database is .mdb and open it, and thus reverse engineer it. I want to
encrypt it, so that only I or my program can unencrypt the data, as well as calling it something like .dbd (DataBase Data).
5. I want to offer updates to the office. The updates will be distributed in the - .dbd file, which will be encrypted. The extra option under the
file menu will be Update, the update can't affect the real program.
6. At a later date, I want to put an option to have pictures in one Access field, without ruining the program and having to recompile, I want it to be importable in an update, or to be left in, but only activated in a later
update, and the program will currently have "This Feature Is Not Yet
Available..." (The company I am currently working for is not in a stable
position, I want to force them in to keeping me till the end).

In short I need a VB app that will run a MSAccess database input & output
from the query forms, however as a stand-alone application and not possible to see through the database. The database will have to be suffixed with
something other than .mdb and encrypted, with the software understanding
that encryption. The software also needs to have a File menu with | Import
(CSV), Save (CSV), Print & Update. The software needs to have the facility
to add pictures at a later date for via the database.

Can anybody help me, please?

Thanks,
Pickles.

Nov 13 '05 #2

P: n/a
Use Google and search for each of your key tasks - what you are asking amounts to someone spending a
good few days coding and testing a full application - it'll never happen!

If you are even asking the first couple of questions then I doubt that you are at all ready for the
last few questions. You should at least be able to create the database and forms using common sense
and the comprehensive help available in the MDSN library (online).

I don't want to sound negative but it would take a long post to even scratch the surface of this
project.

However, some pointers to search for:

2. I now need to use the same form as a form in VB, this will be the front
page and will additionally have the following functions on it: Print, Save
(CSV), Import (CSV).

Look for 'ADO CSV Visual Basic'

3. On top of that the program will function - solely as a stand-alone
program. I want to be able to modify the fields from within Access and for
that to cause the software to change the fields based on the database.

Look for 'ADOX modify field MSAccess'

4. I DON'T want the end user to be able to figure out that the .mdb
database is .mdb and open it, and thus reverse engineer it. I want to
encrypt it, so that only I or my program can decrypt the data, as well as
calling it something like .dbd (DataBase Data).

http://support.microsoft.com/default...ent/secfaq.asp
http://www.pcworlddownload.com/devel.../MDBSecure.htm
5. I want to offer updates to the office. The updates will be distributed
in the - .dbd file, which will be encrypted. The extra option under the
file menu will be Update, the update can't affect the real program.

What updates? Application, databases schema, images?

6. At a later date, I want to put an option to have pictures in one Access
field, without ruining the program and having to recompile, I want it to be
importable in an update, or to be left in, but only activated in a later
update, and the program will currently have "This Feature Is Not Yet
Available..." (The company I am currently working for is not in a stable
position, I want to force them in to keeping me till the end).

Just code for it and have a table in the DB that holds the flag as to whether or not this is
available.
http://www.mvps.org/access/forms/frm0030.htm

Regards,

Chris.

"Jonathan (Pickles) Sklan-Willis" <me@picklesgeek.net> wrote in message
news:MH4vc.51$PT.24@newsfe6-win...
Sorry, forgot to mention all is using VB6! NOT .NET.
"Jonathan (Pickles) Sklan-Willis" <me@picklesgeek.net> wrote in message
news:cg4vc.47$PT.38@newsfe6-win...
Hi All,

This is what I want to do:
1. Build a database in Access with certain queries and a query form.
(DONE).
2. I now need to use the same form as a form in VB, this will be the front page and will additionally have the following functions on it: Print, Save
(CSV), Import (CSV).
3. On top of that the program will function - solely as a stand-alone
program. I want to be able to modify the fields from within Access and for
that to cause the software to change the fields based on the database.
4. I DON'T want the end user to be able to figure out that the .mdb
database is .mdb and open it, and thus reverse engineer it. I want to
encrypt it, so that only I or my program can unencrypt the data, as well as calling it something like .dbd (DataBase Data).
5. I want to offer updates to the office. The updates will be distributed in the - .dbd file, which will be encrypted. The extra option under the
file menu will be Update, the update can't affect the real program.
6. At a later date, I want to put an option to have pictures in one Access field, without ruining the program and having to recompile, I want it to be importable in an update, or to be left in, but only activated in a later
update, and the program will currently have "This Feature Is Not Yet
Available..." (The company I am currently working for is not in a stable
position, I want to force them in to keeping me till the end).

In short I need a VB app that will run a MSAccess database input & output
from the query forms, however as a stand-alone application and not possible to see through the database. The database will have to be suffixed with
something other than .mdb and encrypted, with the software understanding
that encryption. The software also needs to have a File menu with | Import
(CSV), Save (CSV), Print & Update. The software needs to have the facility
to add pictures at a later date for via the database.

Can anybody help me, please?

Thanks,
Pickles.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.