Excel and MYSQL User login connection

Hi all,
Does anyone have any idea how to set up a User login form whenever somebody uses the excel sheet?

And also the user id, username, password will be saved inside an MySql database. How can this be linked together?

Are you asking how you can create a login form in Excel that validates against a MySQL database?

Hi Kyle,
Yes that's exactly what I'm looking for

Firstly, it's not very secure. This will need VBA which is simple to circumvent.

Secondly, will all the users have the relevant software installed to allow this? Windows cannot natively connect to MySQL and requires 3rd party software - something like https://dev.mysql.com/downloads/connector/odbc/

Where is the security lacking? Because it will be used inside a shared_area folder via the server.

Also the connector can be installed for all computers, that's not a problem.

Excel is inherently insecure, it would be easy to bypass the login box, but it depends on how seriously the need for the security is.

Additionally, what hashing algorithm are you using for storing the passwords? This is unlikely to be supported directly in VBA and will need implementing or will require an external reference

The need for user and password is just to identify who has used the excel and amended it last. There is really no need for it, just for tractability purposes. In this case any hashing algorithms can be used I suppose

So why do you need to verify against a MySQL database?

It's easy to get the windows username in Excel

The database is set up in MySql, columns and datatypes to what they need to be. Id rather have everything controlled through Workbench rather than multiple information in multiple places. Makes it nice and tidy and easy to handle

Sorry, you really aren't clear on what you are trying to do.

You said initially you want to validate users against a MySQL database - though clearly this isn't set up.

What are you trying to control through workbench? Remember we know nothing about your project.

Basically,
Multiple computers will have a excel sheet. Inside the excel sheet will be a table with the following columns:
- User Requested
- Item Requested
- Quantity
- Time Requested
- Delivered? Yes/No

Reason I need to use the login forum is because, need to keep some sort of tractability who has entered the information. Instead of somebody manually inputting the information as this can be put by anyone.

Reason I'm using Mysql into this, is because query's are a lot quicker for analyzing rather using excel in my own opinion and multiple data can be altered quicker.

So you want to update that tables in your database from the data in that sheet?

Or do you just want to pull the data from the database into that sheet?

They're very different things.

Where are you wanting to store people updating? Are they updating the workbook or the database or what?

I think you need to give much more information and really a sample workbook

I haven't got a workbook set up just yet.
It will be them columns there above but the user id, time requested will be hidden as it is not needed inside the excel sheet.

The data will be sent to the database and can be only adjusted/altered within Workbench.

When I say it will be sent, need a macro button that says 'Send Now'. This will then create a new row inside MySql and automatically show the user requested, time it has been requested. And I have the option to click yes/no if it has been delivered.

What fields do you need sending to the database - what's the table definition?

Not sure what you mean by table definition sorry.
- Item Requested
- Quantity

these two columns will be manually inputted by the user, as soon as it is sent. It will be sent to the database.

Within the database, ill be able to see who requested it etc...

For anyone to help you, you need to provide, in detail the following information as a minimum:

The table definitions - these are, for each table, the field names, data types, primary and foreign keys and whether they auto increment
A mockup of your workbook - explicitly marking what information needs to be sent to which fields in the database
How your users table is structured, what you are using for usernames etc

I'm afraid, based on this so far, I'm going to have to duck out. This sounds like you want someone to do an extensive amount of work with you, as such your question may be better suited to the commercial services section of the website (but you're probably better off hiring a contractor to work with you)

I have no problem setting this system up its just having the user login forum for Excel, thats my problem at the moment. You have been asking the questions and I have answered it just to give you the ideas whats going on.

But you haven't given enough information. Do you have a users table set up? If not, just use the windows username and send that - there's no need for a log in, you already know who the users are when they submit the data - just send the windows username

Ill just look into that then. Thanks for your time

No problem, although you may feel it, I wasn't trying to be awkward.

You asked, what looked like a specific question, but it wasn't. Really you were asking for advice as to how to approach a problem, if you'd clarified that you'd have made it easier for people helping you as it helps frame the situation. For future help, something like the following would have been a better question:
------------------------------------------------

I'm looking at setting up a system where users update a spreadsheet.

They'll be making requests, that ultimately I want to be pushed to a database table (MySQL); I'm looking for some advice as to the best way to approach this.

Specifically, I want to capture the following information:

1. The user who is making the request (I don't have a users table set up yet)
2. The date and time of the request
3. Request details including
x
y
z

------------------------------

It lets people know where you are in the planning phase and the overall concept. It prevents people needing to guess and make shots in the dark; as such, you'll probably have a better response rate and get more (as well as better) answers to your question

No its cool, you're here to help and you've explained how to use the forum properly to me, this will definitely keep in my mind for future posts and try to explain a whole greater picture for others.

Would it be possible to delete this thread? If you have the ability ? it is no use at all at the moment for anyone