Members
  • Total Members: 14176
  • Latest: toxxxa
Stats
  • Total Posts: 42872
  • Total Topics: 16081
  • Online Today: 3914
  • Online Ever: 51419
  • (01. January 2010., 10:27:49)









Author Topic: .mdb file 2003 question  (Read 10917 times)

0 Members and 1 Guest are viewing this topic.

quailment

  • SCF Newbie
  • *
  • Posts: 1
  • KARMA: 0
  • Gender: Male
.mdb file 2003 question
« on: 21. March 2016., 18:45:37 »
.mdb database is network access.
On each computer in turn opens. However, if opened from one computer to another will not open. Without any messages. Client Settings - shared (not exclusive). Files also .accdb open normally.

What is the reason I cannot understand? Requires multiuser work with files is .mdb. When the earlier all worked fine for the 2003 office.

Samker's Computer Forum - SCforum.info

.mdb file 2003 question
« on: 21. March 2016., 18:45:37 »

jheysen

  • SCF Global Moderator
  • *****
  • Posts: 879
  • KARMA: 121
  • Gender: Male
Re: .mdb file 2003 question
« Reply #1 on: 22. March 2016., 01:30:09 »
If you require multiple users to interact with the Database, maybe it would be better to scale up to SQL Server? You can start in Express

specterminate

  • SCF Newbie
  • *
  • Posts: 1
  • KARMA: -3
  • Gender: Male
Re: .mdb file 2003 question
« Reply #2 on: 06. May 2016., 21:54:43 »
Try this sequence in order below or as an additional resources for restoring .mdb file see and learn following topics, and in case your corruption is severe, one more solution must assist you is "Repair Toolbox".

manual2100

  • SCF Member
  • **
  • Posts: 64
  • KARMA: 10
Re: .mdb file 2003 question
« Reply #3 on: 12. September 2016., 08:27:36 »
With the database splitter wizard you will have to split your database into 2 files front and back end. Forms and reports should be on the front end. Tables, indexes etc will be on the back end. Tables in front end should be links to the back end tables. More here: https://support.office.com/en-us/article/Split-an-Access-database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc

Then you should use the tool from www.autofeupdater.com so that each user works with their own copy of the front end.
You should not use the mdb file simultaneously..

casper68

  • SCF Member
  • **
  • Posts: 14
  • KARMA: 2
  • Gender: Male
Re: .mdb file 2003 question
« Reply #4 on: 07. June 2017., 08:02:28 »
what connection do you use?
Do you check if all users access to network path with same rights?


Samker's Computer Forum - SCforum.info

Re: .mdb file 2003 question
« Reply #4 on: 07. June 2017., 08:02:28 »

 

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Name: Email:
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image
Type the letters shown in the picture:
Second Anti-Bot trap, type or simply copy-paste below (only the red letters):www.scforum.info:

Enter your email address to receive daily email with 'SCforum.info - Samker's Computer Forum' newest content:

Terms of Use | Privacy Policy | Advertising