473,792 Members | 2,831 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Locked out of Access database

First, a brief explanation of why this has happened. I purchased, what
I thought, was a fully functional program written in Access last year
from a local programmer. This program was to be used as my POS for an
online DVD store. It turns out that what the programmer actually gave
me was a "license" to use his software. This was not the agreement we
made, and he knows this. He took advantage of the fact that I knew
very little about software, and led me to believe that I owned the
program.

About 4 months ago, when logging in to my database, a message popped
up saying to call the programmer for an update. I called and he have
me a 7 digit number to enter when this message pops up. I entered it
and got in. This message popped up again about a month ago and I
entered the same number, which got me into the database. This message
popped up again a week ago. I entered the same number, but this time
another message popped up, saying "err 4", and I was denied access to
my database.

My programmer and I are in the middle of a billing dispute over an
update he did for my program which didn't work. I called him about
this err 4 message, and this is when he told me that I actually only
have a license to use his program. He went on to say that until I pay
for the update mentioned earlier, he would not grant me access into my
database. I checked all of my past invoices from him, and none of them
mention anything about my purchasing a license. The first invoice I
paid, which was when I paid for the program, is billed as being for
the database and training. I pointed this out to him, and he says that
he never charged me for the license. The fact is that he never charged
me for a license because that was never part of our agreement.

I do not see an agreement between he and I any time in the near
future. I am locked out of a database which I have been entering my
stock in for almost a year. This is putting a massive strain on my
business.

I know very little about programming, actually nothing. I have
attempted to recover the database through a couple of programs. The
closest I have come was through a trial version of a program called
Nuclear Kernel Access. I don't really understand the program, but when
I open the database, I can see my database information (inventory,
users, etc).

If anyone out there could help me with this dilemma, I would greatly
appreciate it. Thanks, in advance.

chase

May 12 '07
15 4112
"Albert D. Kallal" <Pl************ *******@msn.com wrote in
news:B1O1i.1810 43$DE1.54130@pd 7urf2no:
Did you hire a developer to build you a system, or did you
purchase a existing system from him? Really that is all we need to
know.
Not even that. The issue is whether the coding was "work for hire"
or not. And there has to be a contract explicitly stating that it's
"work for hire" or, alternatively, that the ultimate rights to the
code belong to the purchaser.

As long as it's an outside contractor doing the coding, it's not
"work for hire," which is the only way that it could become the
property of the purchaser without an explicit granting of code
rights.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 14 '07 #11
"Albert D. Kallal" <Pl************ *******@msn.com wrote in
news:B1O1i.1810 43$DE1.54130@pd 7urf2no:
If you hired that developer, and started from scratch, and it was
your designs then you can certainly make a case that you own the
software. This is not different then any company that hires
someone to build them a table...it your table, and the designs are
also your.
Legally, it's considered *COMPLETELY* different.

The outside contractor holds the copyright on the code *because* she
wrote it, and can only transfer it to another entity by explicitly
stating that the rights are being transferred.

The only case in which the code would automatically be owned by the
purchaser would be if the programmer were hired as a full-time
employee, working full-time for the purchaser and only for the
purchaser, and with the purchaser paying taxes and benefits for the
programmer. In that scenario, it's definitely "work for hire" and
the purchaser has the full rights to the programmer's work product.

Absent that, and absent an agreement stating either that the
programming is "work for hire" or an agreement stating that the
purchaser will get the full code rights, the full rights to the code
BY DEFAULT belong to the programmer.

Period.

It doesn't make any difference if the code was written from scratch
for the particular client.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 14 '07 #12
OK, what everyone is saying regarding my not owning the program makes
sense.

Most of you also state that my programmer has no right to hold my data
in the program hostage, since I created the inventory. Any advise on
how I should handle this situation. As it stands, I am locked out of
my database due to a billing conflict which I do not see being
resolved anytime soon. If the programmer has no right to lock me out
of my database, how should I approach this from here?

Thanks.

On Mon, 14 May 2007 10:11:42 -0500, "David W. Fenton"
<XX*******@dfen ton.com.invalid wrote:
>"Albert D. Kallal" <Pl************ *******@msn.com wrote in
news:B1O1i.181 043$DE1.54130@p d7urf2no:
>If you hired that developer, and started from scratch, and it was
your designs then you can certainly make a case that you own the
software. This is not different then any company that hires
someone to build them a table...it your table, and the designs are
also your.

Legally, it's considered *COMPLETELY* different.

The outside contractor holds the copyright on the code *because* she
wrote it, and can only transfer it to another entity by explicitly
stating that the rights are being transferred.

The only case in which the code would automatically be owned by the
purchaser would be if the programmer were hired as a full-time
employee, working full-time for the purchaser and only for the
purchaser, and with the purchaser paying taxes and benefits for the
programmer. In that scenario, it's definitely "work for hire" and
the purchaser has the full rights to the programmer's work product.

Absent that, and absent an agreement stating either that the
programming is "work for hire" or an agreement stating that the
purchaser will get the full code rights, the full rights to the code
BY DEFAULT belong to the programmer.

Period.

It doesn't make any difference if the code was written from scratch
for the particular client.
May 15 '07 #13
chaseexchange <ch***********@ yahoooooo.comwr ote in
news:uq******** *************** *********@4ax.c om:
Most of you also state that my programmer has no right to hold my
data in the program hostage, since I created the inventory. Any
advise on how I should handle this situation. As it stands, I am
locked out of my database due to a billing conflict which I do not
see being resolved anytime soon. If the programmer has no right to
lock me out of my database, how should I approach this from here?
An intellectual property lawyer ought to be able to get your data
released with one of those $200 nasty letters they write threatening
further legal action. Of course, you need to be prepared to go
further with it if the idiot doesn't recognize that he's in trouble
for tying up your data.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 15 '07 #14
On Mon, 14 May 2007 19:53:14 -0500, "David W. Fenton"
<XX*******@dfen ton.com.invalid wrote:

I'm not sure I agree. I'm thinking chaseexchange may not be locked out
of the data at all: perhaps this is a split database, with a .mde
front-end (this is the application part) and a .mdb back-end (this is
the database part). He should search for .mdb files on his computer,
then open them with MsAccess, and voila, there is the data.

That's why I suggested that if this is indeed the case, a competent
developer could write a provisional application in a few days so he
can limp along again.

By the way, not every company works with "licensed" software like most
of you do. For example the company I work for has a different
approach: once all the bills are paid, the source code is yours.
Comparing your custom solutions with MsOffice products is not really
apples to apples, I think (but do not want to start a flame war).

-Tom.
>chaseexchang e <ch***********@ yahoooooo.comwr ote in
news:uq******* *************** **********@4ax. com:
>Most of you also state that my programmer has no right to hold my
data in the program hostage, since I created the inventory. Any
advise on how I should handle this situation. As it stands, I am
locked out of my database due to a billing conflict which I do not
see being resolved anytime soon. If the programmer has no right to
lock me out of my database, how should I approach this from here?

An intellectual property lawyer ought to be able to get your data
released with one of those $200 nasty letters they write threatening
further legal action. Of course, you need to be prepared to go
further with it if the idiot doesn't recognize that he's in trouble
for tying up your data.
May 15 '07 #15
Is your database requite you log on, and is it split into two parts?

Can you open the back end mdb direct?

(or, create a blank database, and import the data????).

Try a few of the above..it very possible your data is still open and
importable by you...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
May 15 '07 #16

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
5683
by: DebbieG | last post by:
I have created a database for a client and was told that it was to be a one-user database. Well, you know the next statement ... now they want 3 people to be able to use the database. (FYI, I have never created a database for multiusers. I've done some searching but not finding what I want.) I have split the database. In Tools, Options, I have set the following: Default open mode = Shared Default record locking = Edited Record
1
1434
by: Carlos Sol | last post by:
Good day I am having a problem developing a web application for an on line catalog. I am using ms access XP on an XP professional platfrom. I have been able to succesfully develop a web page to query the database to produce a list of items in groups of 10, but when I request the next 10 items the server returns the following error: "Error Type: Provider (0x80004005)
2
12856
by: Captain Nemo | last post by:
Hi I seem to remember that in Access 2000 you can sometimes get a bogus error message telling you that a certain table is 'locked by another user', when there is no way that could be true. Unfortunately, I can't remember what the workaround (if any) might be. Can anyone help?
4
2765
by: hkappleorange | last post by:
I ued this code to connect to a mdb file A = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\Inetpub\wwwroot\ASPX\Authors.mdb" )
1
7944
by: amindi | last post by:
Hi, I wrote a VB6 program to read some data records from a Ms Access database and to write them into a SQL server database.(I use Ms Access 2000 and SQL server 2000).After reading each record in Access database, I update a text type datafield of that record in Access database to 'Y' (to mark the perticular record as a copied record)(The program does the updation). I tested the program several times by using a seperate copy of the same database...
1
4797
by: tricard | last post by:
Good afternoon all, I have recently been trying my hand out at the ADO model as before I have only used DAO (just thought I would expand my knowledge a bit). The problem I am having is that while I am executing and debugging code, my database keeps getting put into a locked state and I cannot seem to get it out of this state without closing MS Access and reopening it (and this doesn't seem to always work either). I used to have this...
3
2089
by: ksarkies | last post by:
Hi This is a "problem" I've been battling for many days and haven't been able to understand; various postings I've come across on the Internet seem to not quite provide the answer. We have a commercial (membership database) application written around Access 2002 and we are using Access 2003 to run it on Server 2003 (64 bit), and 32 bit XP Pro. The database file is locked in some way so that it can't be opened within Access, even when using...
6
11337
by: stuart | last post by:
I have 2 users who ran into a problem with a data entry program (written in Access 2003). One user was keying into one of the forms when she got the message "ACCESS Error Number: 3218 Could not update; currently locked'. About the same time, another user was keying records into a 2nd form. Even though they were on different forms, they would have added records to the same table. The 2nd user had tried to add about 28 records, the...
11
5027
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the database, in in both VB6 and VB.NET applications, I got the error "The Microsoft Jet database engine cannot find the input table or query 'myTable'. Make sure it exists and that its name is spelled correctly." Also, I got the error "The...
0
9670
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9518
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10430
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10159
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10000
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5436
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5560
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3719
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2917
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.