Access Problem

Hardware, Software, Internet, etc.

Moderators: Big-O Ryan, Big-O Mark, Matt, jester22c

User avatar
Anthony
Moderator
Moderator
Posts: 1532
Joined: Thu Sep 12, 2002 5:10 am
Location: Rochester, New York
Contact:

Access Problem

Post by Anthony »

This is mostly targeted towards harra, but of course anyone can answer:

Do you know why I would be able to open a access file on the computer that creates it, but when I attempt to move it to another computer it won't open? It does not rely on anything outside the file (That I know of... and I created it so I didn't (while knowing) make it somehow rely on something outside that one file).

And would you know anyway to make it so I can move it. It seems that it needs to be changed a lot :roll: (People can't seem to stop wanting fields added lol), so I really need them to be able to email it to me so I can change it at home (as opposed to being at their computer).
Image
PhaseDMA - Check it out
My AIM+ FAQ
User avatar
harra
Veteran
Veteran
Posts: 324
Joined: Thu Sep 12, 2002 7:03 am
Location: Houston, Texas
Contact:

Post by harra »

Anthony,

Honestly, unless you are utilizing MS Access user-level security, I don't know of any reason why you can't move a MS Access .mdb/.mde file from one computer to another. I do it all the time.

Can you provide some more details about what it's doing when you try to open it on another computer? Is it just not doing anything? Is it giving some sort of error message?
User avatar
Anthony
Moderator
Moderator
Posts: 1532
Joined: Thu Sep 12, 2002 5:10 am
Location: Rochester, New York
Contact:

Post by Anthony »

It is actually giving me some sort of error msg, but I don't know what it is right now (I'll have them send it to me again tonight and post the exact error msg later tonight).

I assumed you would need the error msg but... I don't have it currently :| .
Image
PhaseDMA - Check it out
My AIM+ FAQ
User avatar
Plasma2002b
Extreme Groupie
Extreme Groupie
Posts: 976
Joined: Thu Jul 18, 2002 11:36 pm
Location: Riverside, Ca
Contact:

Post by Plasma2002b »

(probably a stupid question to ask)

are ya using the same versions of Access to open it?
Image

its teh infamous life of brian gaut to teh max0r!
User avatar
harra
Veteran
Veteran
Posts: 324
Joined: Thu Sep 12, 2002 7:03 am
Location: Houston, Texas
Contact:

Post by harra »

The only problem with versioning that I have run into is when you try to open a MS Acesss 2000 database with MS Access 97. If you try and open a 97 database with 2000 you'll get prompted to convert the database.
User avatar
Anthony
Moderator
Moderator
Posts: 1532
Joined: Thu Sep 12, 2002 5:10 am
Location: Rochester, New York
Contact:

Post by Anthony »

I forgot to have my mom email me the file (Got caught up with getting my ISP back...). I have told her to email me... And I'll remind her in the morning...
Image
PhaseDMA - Check it out
My AIM+ FAQ
User avatar
Michael
Fanatic
Fanatic
Posts: 161
Joined: Sun Sep 29, 2002 8:20 am
Location: New York, USA
Contact:

Post by Michael »

That's a strange problem. I use Access databases at my job a lot (my job is writing ASP pages that access XML pages stored in a database), and I've never had a problem opening and modifying the database on the myriad computers we have scattered around campus. (I work for a university.) If you'd like, I can ask around tomorrow at work, see if anyone else who knows more about Access than I do knows what the problem might be?
User avatar
Anthony
Moderator
Moderator
Posts: 1532
Joined: Thu Sep 12, 2002 5:10 am
Location: Rochester, New York
Contact:

Post by Anthony »

Ya it's the same version and such... My mom likes to complain about the computer so it might be the computer... But I question how many of the problems are really caused by "the" computer.

If you guys can help me figure out this problem you will be making a small group of people very happy...

Not that this should matter but...
All with the same error (That I will provide ASAP)

Original PC Specs:
Windows XP Home
2.x Ghz
Office 2000

PC Specs We Have Used:
Windows 2000 Pro
166 Mhz
Office 2000

And
Windows XP Home
2.x Ghz
Office 2000 (I believe (came with XP))

And
Windows 98
??? Mhz
Office 97
Image
PhaseDMA - Check it out
My AIM+ FAQ
User avatar
harra
Veteran
Veteran
Posts: 324
Joined: Thu Sep 12, 2002 7:03 am
Location: Houston, Texas
Contact:

Post by harra »

Anthony,

When you are on the computer where teh .mdb file opens without issue, are you required to enter a username and password to get into the database?
User avatar
Anthony
Moderator
Moderator
Posts: 1532
Joined: Thu Sep 12, 2002 5:10 am
Location: Rochester, New York
Contact:

Post by Anthony »

Nope.

In fact (once again not that I know if it matters) I can access the files on all the user accounts (xp accounts) on the computer from admin to limited user.

This is weird because I made it and I know I didn't (while knowing) do anything that would make it dependent on anything.
Image
PhaseDMA - Check it out
My AIM+ FAQ
User avatar
harra
Veteran
Veteran
Posts: 324
Joined: Thu Sep 12, 2002 7:03 am
Location: Houston, Texas
Contact:

Post by harra »

Just checking.

Whenever you set up user-level security on an MS Access database (meaning everytime you open up the file it prompts for a username and password), then it is dependant on a secondary file to operate.

This is weird. I would say if possible, you can try and e-mail me the file (zipped of course) and I can take a look at it.
User avatar
Anthony
Moderator
Moderator
Posts: 1532
Joined: Thu Sep 12, 2002 5:10 am
Location: Rochester, New York
Contact:

Post by Anthony »

Okay I'll do that as soon as my mom responds to my email / she gets into work.
Image
PhaseDMA - Check it out
My AIM+ FAQ
User avatar
harra
Veteran
Veteran
Posts: 324
Joined: Thu Sep 12, 2002 7:03 am
Location: Houston, Texas
Contact:

Post by harra »

You can get my e-mail address from your forum. I'm sure you can look at my profile and get my e-mail address :)
User avatar
Anthony
Moderator
Moderator
Posts: 1532
Joined: Thu Sep 12, 2002 5:10 am
Location: Rochester, New York
Contact:

Post by Anthony »

Okay... Now I'm mad... The stupid thing opened at school out of all places. Maybe my mom did something weird went she sent the first copy.

Maybe it was the virus that got on the network, and killed so many programs.

Well thanks Ray
Image
PhaseDMA - Check it out
My AIM+ FAQ
User avatar
harra
Veteran
Veteran
Posts: 324
Joined: Thu Sep 12, 2002 7:03 am
Location: Houston, Texas
Contact:

Post by harra »

Well,

I really didn't do anything, but if you need any Access assistance in the future, that is an area I can contribute in this community.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest