Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11

    Trying to share data base from desktop to laptop

    I have a big data base on the desktop. I want to access it from a laptop to make changes or add while the desktop is being used on another program by someone else. I have been trying this for a year now. I am a real novice so please explain step by step if possible? I can see the desktop on other programs and share with no problem.?



    Thanks!!!!!!!!!!!!!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    Have you split your db into FrontEnd and BackEnd?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11

    Huh???

    I am really a novice here. I hired someone to build this data base that we operate our time and attendance with for our Human Service company a few years ago. We know how to operate it and run some querys. But that is it. So I don't even know what a "front end" is. Sorry.

    But we are really looking for help because we made it work once but are now being told it can't be done?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    Do you have the program Microsoft Access on your laptop? If so, what version?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  5. #5
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11
    2002, Same as on the desktop machine. We were going to convert to 07 which I have on a few machines but was told by a Professor at the State University that we could not?

    Anyway, we are going to stay with the 2002 version until we have to switch. The data base we have is very extensive and took months to build so it works with our working with disabled clients and all the billing that goes with the State and Federal programs.

    Thanks much for getting back to me. It feels good that maybe there is an expert out there that might be able to make this work.

    We have tried even an IT consultant and they could not make it work!

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    Have you shared the folder that contains the db so it will be visible on the network? How about the OS? WinXP on both?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  7. #7
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11
    XP on both, desktop is set to share all files. I share QUICKBOOKS and it works fine. I can get other files as well. I can see the DB but when I open it, it doesn't bring over the newest data. It still has the old data from that one time it did work? I wonder if the desktop has upgraded something so that when the laptop looks for the file or tries to open the desketop db, it can't for some reason?

    It acts almost like we are running a different version but both say 2002 ver 10?

  8. #8
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11

    Version

    Quote Originally Posted by RuralGuy View Post
    Have you shared the folder that contains the db so it will be visible on the network? How about the OS? WinXP on both?
    I checked both machines and they are the same version 10.6771.6845 SP3

    Thought that might be the answer but guess not.

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    Are they both Home Edition or Pro? How big is the db? Is there more than one mdb?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  10. #10
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11
    XP Pro on both Big data base but how can I measure it to tell you. Very complicated. It is set up to track time and attendance by employee/customer. It totals hours by various staff to each customer and each client to their billing source. MDB??

  11. #11
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11
    I found the size 152168 KB

  12. #12
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    152MB...pretty good size but nowhere near the 2GB limit. Is it an MDB file or MDE? Is there more than one?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  13. #13
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11
    There is a file for the data base and a file for the data It says Microsoft Access application for the file type? The data file is larger than the DB. The DB is directed to go to the data file to pull information?

  14. #14
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11
    How can I tell if it is mdb or mde

  15. #15
    Joe Q is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Aug 2009
    Posts
    11
    Can you call me or can I call you? We can walk through it.

    My web site is www.toddsteven.com so you can see what kind of business we do.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. reporte en base a consulta cruzada
    By ute in forum Reports
    Replies: 2
    Last Post: 04-29-2009, 03:51 AM
  2. Share a ms access database over internet
    By marianne in forum Access
    Replies: 0
    Last Post: 04-14-2009, 10:14 PM
  3. Share a database over the Internet
    By edupi in forum Access
    Replies: 5
    Last Post: 04-13-2009, 08:14 PM
  4. Having trouble with dates in my Data Base!!!!
    By BigPhil in forum Queries
    Replies: 4
    Last Post: 02-15-2006, 12:47 PM
  5. Security icon created on desktop !!!
    By wasim_sono in forum Security
    Replies: 1
    Last Post: 02-07-2006, 09:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums