Multi users for Excel VBA userform

Question

I have made my connection to a Access DB to allow multi entries. It now takes a range and adds it to a table. All perfect. But now I want to have multiple users using the Excel userform to populate Access DB.

Is this possible or do I have to rewrite my whole userform?

John Slegers · Accepted Answer · 2016-02-13 00:11:23Z

1

Enable events = True

This was the solution for me.

edited Feb 13, 2016 at 0:11

John Slegers

47.4k23 gold badges205 silver badges173 bronze badges

answered Feb 11, 2016 at 12:23

gandalf

537 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ASH · Accepted Answer · 2015-12-04 20:08:37Z

0

Having multiple people use Excel requires you to 'share' the workbook.

https://support.office.com/en-us/article/Use-a-shared-workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61

This is NOT a good idea. Given enough time, Excel will crash, and/or get corrupted, and you'll lose all your data. Just split your Access DB and share the front end with the users.

https://support.office.com/en-us/article/Split-an-Access-database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc

answered Dec 4, 2015 at 20:08

ASH

20.5k28 gold badges117 silver badges247 bronze badges

1 Comment

gandalf Over a year ago

Hi, thanks for replying. Excel uses the form only for a second to link it to acces. I already have it working. Opening as READ ONLY. User opens a copy, gets the user interface with the worksheet layout and then queries it to acces DB. Stress testing soon.

Collectives™ on Stack Overflow

Multi users for Excel VBA userform

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related