MSAccess Help
- Started
- Last post
- 11 Responses
- trooperbill
Weve tried opening 2 copies of the same access file over the network at the same time and it doesnt let us do it?
Ive seen people do this in the past (or at least it looks like the same thing)
is there a setting or something in access that will let people work on the same database.mdb at the same time?
- trooperbill0
lolz nope
its something the warehouse manager has knocked togther but the sales team need access... only they cant both open the file at once without it locking one of them out
- make sure they respect your time, this can drop you down the rabbit hole sometimes...vaxorcist
- flashbender0
perhaps you need to buy another license? Isn't microsoft notorious for a one license one user mentality?
- vaxorcist0
haven't used access since 1999, but once upon a time, if I remember right, you had to have one user with read-only rights and another with read/write rights, because access was unsophisticated about people erasing each others changes.... I don't recall how to do this...
- vaxorcist0
hmmm 2 copies of the same mdb file... try downloading the file, renameing it, unhooking both PC's from the network, opening the files, then re-hooking the PC's up to the network.. that is as long as you don't need current data.....
and of course, rebuild/update/convert to SQL someday and this crap no longer happens.... but I know how hard that can be....
- trooperbill0
anyone know how to do this?
- comicsans0
Access is a single user desktop system. It can be faked to appear multi-user but it's hardly industrial strength, you really need a proper RDBMS, or failing that MySQL.
If you must fuck with it try Tools/Options/default open mode -> shared but you'll be sorry
- SteveJobs0
it's been a looong time, so i don't remember about read-only access with um... access, but generally you'll just write a simple asp/php script to pump out the data to a web page. access is unique in many ways, which means a few sacrifices to get that portability.
you can also write an app layer on top using vba (visual basic for applications). http://visualbasic.about.com/od/…
otherwise, export to excell or other easy-to-read format?
- vaxorcist0
so we're all kind of guessing here... .you could probably get better help on a VB forum, or just automate an excel export...
.... this may be trivial, or possibly complex, you may have to hire a consultant... .. beware that complexity can mushroom..... as access is easy to make something that looks "almost" like it will work but really is just a sideways bunch of wizard generated stuff....
Some of my gigs in the semi-distant past were often where I was hired to migrate the client out of home-grown stuff in Access which had been outgrown.... or had made a fine mess of non-relational index oddness...