excel front end / hide access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a large excel VBA project delivered as an ADD-In and was looking into
moving the data portion into access.

Q: before I begin - What is the best way to hide the access file and app ? I
think the file should be open but do not want the "user" to see it. Also do
not want "interference" if user also has another access file open.

Am experienced in Excel VBA and other reasons to keep frontend in Excel

thanks
 
If you are just using access as a data store only with no forms etc, set a
database password on the mdb, and use that password to open it via Excel,
this will prevent users from getting into the database to tinker about.
 
Ok with password but what is best way to hide the instance of Access so they
don't even know Access is involved?
 
if you are only using access as a data store you don't event need Access
installed so that should nail it.
 
Alex,

Let me see if I am understanding this post. Are you saying that if I have
Excel installed on my computer, but I do not have Access (Retail or RunTime)
installed, then from Excel I could create an instance of Access to use
strictly as a data store?
If this is true, how would Excel keep track of table names, field names, etc.?
 
Create the database on a computer with Access installed and virtually all
PC's with current OS's on them have the Access driver installed so you can
create an ODBC link to the Access database without Access having to be
installed on the workstations to access the Access database, how many
webservers have Access installed on them but they can access the Access
mdb's?

All structural modifications to the mdb would be better being done on a
computer with Access installed would make life easer.

It does work as long as all you are using the mdb for is storing data.
 
As I said yesterday it's a learning curve and I am learning at least good
thing every day.

Glad to help
 
This caught my eye because of a specific case. I belong to a club that is
involved in a competetive sport. The current scoring system is something
from the dark ages that is starting to fall apart. They have to reset the
date in the BIOS to 2004 because it will not run after that. They don't have
Access and I don't believe they have Excel, but I was thinking I could help
them out and learn a new trick myself.

Where I work, they are starting to use C#. I would like to learn it. I
would assume (haven't done my homework yet) that C# apps can be delivered as
an exe without a license. This would give me a way to create a new scoring
and membership system for them and learn a new trick.

So what does this have to do with Excel? Nothing, but If it can be done
with Excel, I would assume C# could do it with an ODCB connection as well.
 
Great so are these the steps -

1) I set up and save the mdb with a password
2) excel addin and mdb saved to client pc
3) use Excel vba to querry (through ado) the mdb
4) send client updated data with same mdo file name
5)Excel can then read/write and querry the mdb

sounds great, nice to know it might work before the coding starts
 
Back
Top