+ Reply to Thread
Results 1 to 4 of 4

create one large database, and 30+ partial ones, with a two-way connection

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    netherlands
    MS-Off Ver
    excel 2013
    Posts
    8

    create one large database, and 30+ partial ones, with a two-way connection

    Hello,

    I work in health care and I need to create a large database, which can be filled in by secretaries.
    This database is filled with the private data of our clients.

    My other co-workers, which treat these clients, need to be able to see and edit the data of their own clients, but they are not allowed to see the data of other employees.
    Does anyone have any ideas how I achieve this?

    I've tried creating one large file, which opens the other files, extracts the required data and then closes them again. the drawback to this was that it that it took too long.
    I've also considered doing it the other way around, so I have experimented a litte with it. I tried having each co-worker file open the secretary file and copy it's changed values into it, but if something goes wrong with the macro, this would leave the secretary file open on a co-workers' computer.

    At this point I'm open to all suggestions, not necessarily only in excel. Maybe this is possible when combining excel with access or something?
    Please let me hear any thoughts you have on this, even if it's not a straight out solution!

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: create one large database, and 30+ partial ones, with a two-way connection

    Hi -

    Create Access database and put it in server then create excel macro that connects to that database displaying only the data intended for each persons.

    event

  3. #3
    Registered User
    Join Date
    04-09-2015
    Location
    netherlands
    MS-Off Ver
    excel 2013
    Posts
    8

    Re: create one large database, and 30+ partial ones, with a two-way connection

    Hi event,

    Could you please elaborate a little bit? I've familiarised myself with excel macro's a lot, but I'm new to access.
    If it's possible I'd like to do this without inserting a table in excel, so excel still looks the same as it always does.

    thanks already for pointing me in the right direction by the way!

  4. #4
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: create one large database, and 30+ partial ones, with a two-way connection

    Hi -

    All the table layout you have right now in Excel will be recreated in Access database. So you're not saving to Excel anymore but in Access instead. You can retrieve the data into excel, edit it then save it back to access.

    event

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 07-16-2013, 12:02 PM
  2. Replies: 2
    Last Post: 07-05-2013, 09:37 AM
  3. link table to database connection
    By itdgoodridge in forum Access Tables & Databases
    Replies: 2
    Last Post: 02-15-2013, 02:56 PM
  4. link table to database connection
    By itdgoodridge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 02:56 PM
  5. ODBC connection to an Oracle database
    By roli001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2011, 10:49 AM
  6. Database Connection with Informix using VBA
    By carlos Filho in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2006, 10:40 AM
  7. [SOLVED] Database Connection
    By Phil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2005, 08:05 AM
  8. Database Connection
    By Phil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1