473,322 Members | 1,538 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Access 2003

mseo
181 100+
Hi
I have an access 2003 DataBase I have designed it on my computer and when I copied it to another computer I got built-in login form asking me for user name and password
and I have never created any kind of security to this database so I had to open it exclusively so I need what's the reason of that and how can i handle this problem
again I have the full-open database on my computer
thanks for any help you my provide me.
Feb 17 '10 #1
7 1163
mseo
181 100+
the operating system of my computer is a Vista and the computer that I have tried to use it on is XP please I have tried to solve this, but I can't , I feel like I have to restructure the database again
Feb 18 '10 #2
Delerna
1,134 Expert 1GB
Nothing comes to mind as to why it is doing that except some sort of compatibility issue. I seem to recall a similar thing happening to me when the company I was working for at the time had a mix of computers running Windows 98 and XP. Don't remember the details but I think I finished up keeping 2 versions of the database.

Try creating a new database on the XP machine and then importing all the objects into it from the orriginal DB. See if that gets you around the problem.
Hopefully someone else might have a better answer.
It sounds like the sort of problem that requires physical access to everything involved in order to solve.
Feb 18 '10 #3
NeoPa
32,556 Expert Mod 16PB
Access security is set up as a PC level entity. If the standard System.Mda is used on your PC it's possible that a modified version is on the other. It is Access that this pertains to rather than a specific database though. You should notice this happens on the other PC for all usage, not just your database.
Feb 19 '10 #4
Delerna
1,134 Expert 1GB
Just reread my post and wanted to clarify that the
similar
thing I mentioned had nothing to do with security.
It was more, it ran fine on XP but not on 98
Feb 19 '10 #5
mseo
181 100+
thanks for your replies and I have found that when I moved the access file to another PC the default administration group has been changed
and my question now why have I had to assign the group to open the database?
and in fact I didn't create any groups or any kind of security
thank you very much and I appreciate your replies.
Feb 20 '10 #6
Stewart Ross
2,545 Expert Mod 2GB
The problem with Access workgroup files, as NeoPa said, is that if such a workgroup is created for a particular installation it is then applied by default to all MS Access databases opened using that installation. It is for this reason that you have such a workgroup being applied when you didn't define one for your database.

You may be able to change the default workgroup for the installation that is causing you difficulties (if you have suitable permissions). If the workgroup was defined for a specific application it can still be used for that application by opening it from a command line - the /wrkgrp switch can be set to specify which workgroup to use.

-Stewart
Feb 20 '10 #7
NeoPa
32,556 Expert Mod 16PB
Unless you're very comfortable with these security files (typically SYSTEM.MDW - Apologies for referring to it as MDA in the earlier post), and very few are - hence their removal in later releases, I suggest you leave the basic security as it is.

I would echo Stewart's comment. When, and only when, necessary, apply a specific security file to a project using the command line switch. That way others, like yourself, won't have these confusing situations to fall over.

It's a design flaw (from Access) in my view, which you have stumbled over. Whoever left you the situation by changing the file on one PC should not be blamed too heavily as it's a difficult area to navigate.
Feb 21 '10 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
2
by: BT Openworld | last post by:
I have just had to upgrade to Access 2003 as Access 97 EMail (SendObject) doesn't work when loaded on Windows XP. I'm finding my way around Access 2003 but my biggest problem is getting...
1
by: Wayne Aprato | last post by:
I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the...
3
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access...
7
by: Wayne Aprato | last post by:
I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." ...
2
by: Jeff | last post by:
Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000...
10
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.