Re: [CGUYS] MS Access problem
Well, there's one file that's called by the shortcut, but the folder has 5 different .mdb files in it. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of gerald Sent: Friday, October 03, 2008 4:29 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem is this all one integrated file? or a set of separate files with different extensions? by the way, i have never used axes. At 04:30 PM 10/3/2008, you wrote: >The entire file is about 8mb... > >How would I go about seeing how big the database portion is? > >Larry > >-Original Message- >From: Computer Guys Discussion List >[mailto:[EMAIL PROTECTED] On Behalf Of gerald >Sent: Friday, October 03, 2008 10:55 AM >To: COMPUTERGUYS-L@LISTSERV.AOL.COM >Subject: Re: [CGUYS] MS Access problem > >how big is the database portion of this file, and how big is the whole >file? > > > >*** * >* >** List info, subscription management, list rules, archives, privacy >** >** policy, calmness, a member map, and more at http://www.cguys.org/ >** >*** * >* > > >*** ** >** List info, subscription management, list rules, archives, privacy ** >** policy, calmness, a member map, and more at http://www.cguys.org/ ** >*** ** * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
is this all one integrated file? or a set of separate files with different extensions? by the way, i have never used axes. At 04:30 PM 10/3/2008, you wrote: >The entire file is about 8mb... > >How would I go about seeing how big the database portion is? > >Larry > >-Original Message- >From: Computer Guys Discussion List >[mailto:[EMAIL PROTECTED] On Behalf Of gerald >Sent: Friday, October 03, 2008 10:55 AM >To: COMPUTERGUYS-L@LISTSERV.AOL.COM >Subject: Re: [CGUYS] MS Access problem > >how big is the database portion of this file, and how big is the whole >file? > > > > >* >** List info, subscription management, list rules, archives, privacy >** >** policy, calmness, a member map, and more at http://www.cguys.org/ >** > >* > > >* >** List info, subscription management, list rules, archives, privacy ** >** policy, calmness, a member map, and more at http://www.cguys.org/ ** >* * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
The entire file is about 8mb... How would I go about seeing how big the database portion is? Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of gerald Sent: Friday, October 03, 2008 10:55 AM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem how big is the database portion of this file, and how big is the whole file? * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
how big is the database portion of this file, and how big is the whole file? * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
I'll give your ideas a try... Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, October 02, 2008 10:59 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem I've had trouble on some machines getting Access 2007 to associate itself with older mdb files and in these cases have had to resort to opening the older files from within Access instead of from Explorer. Yes, it makes no sense. Anyway, it seems from your description you don't have this problem. Only two things I can suggest therefore that you may already have tried. First, when you open the file using the old system, try hitting the function key ( F11) to see if it will bring up hidden tables, and possible something from which the export command will work. But even you cannot export directly see if you can open the table and copy the data over directly by hitting ctl-a (select all) ctl-c (copy) and then pasting (ctl-v) into a new access table in a new database. Probably you've tried that but just in case . . . I know how frustrating that kind of problem can be so best of luck to you. JL Larry Sacks wrote: > I can open it on his old system *BUT* not by going directly into MS > Access 2000. If I try to open it, I get the permissions error again. > > Instead I can open it via the shortcut. > > When this d/b delivered, it used the MS Access Runtime 2000 so you > didn't have to have Access installed. > > Oh... and there's no menu listed to export the data either. > > Larry > > -Original Message- > From: Computer Guys Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Tony B > Sent: Thursday, October 02, 2008 9:07 AM > To: COMPUTERGUYS-L@LISTSERV.AOL.COM > Subject: Re: [CGUYS] MS Access problem > > Didn't you just say you can open it on his old machine? Then can't you > just export it as a csv? > > > On Thu, Oct 2, 2008 at 11:38 AM, Larry Sacks <[EMAIL PROTECTED]> > wrote: > >> I've been through the MS newsgroups, but I'll wade through them again. >> The solutions that sound plausible involve getting the original >> > version > >> of access, although how do I go about finding that? The software was >> installed in 2001. >> > > >> On Wed, Oct 1, 2008 at 8:11 PM, Larry Sacks <[EMAIL PROTECTED]> >> wrote: >> >>> Nope. The mdb isn't corrupted. I can take the file on his new >>> >> system, >> >>> put it back on his old system and it works. >>> > > > > * > ** List info, subscription management, list rules, archives, privacy > ** > ** policy, calmness, a member map, and more at http://www.cguys.org/ > ** > > * > > > * > ** List info, subscription management, list rules, archives, privacy ** > ** policy, calmness, a member map, and more at http://www.cguys.org/ ** > * > > * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Answers inline below >Have you tried running the application on a PC without ANY version of >Office installed? Yes. But it doesn't work since it's a database (.mdb) file and it looks for a program associated with that. >If the application runs w/o Office installed try >running the application after installing all MS Office applications >EXCEPT MS Access. If that works then you can either: > >1. Leave the system set up without MS Access installed. This works if >your customer doesn't need MS Access for any other application. > >2. See if there is some way to install/configure MS Access so it >doesn't try to automatically upgrade existing databases. That's never been a problem. I sort of wish it was *the* problem since that'd be easy to get around. >If neither of these solutions are available then your customer has a >serious problem because it sounds like the vendor set up the database >application with specific user level permissions. >From what I've seen, I think the error message is a red-herring. >This means you have >to know the correct administrative user id and password for the specific >database if you want to upgrade/modify the application. I'm not trying nor is it my desire to upgrade or modify this. I just want to get it to run under Windows XP instead of Windows 2000. Maybe in some parlance, that's the definition of 'modify' but I'm not looking at it that way. >Since it >doesn't sound like the vendor provided this information to your customer >as part of delivering the system then your customer is probably out of >luck. Yeah...that's being debated by various departments and until they make a decision one way or another, I'm going to keep trying to get this working Larry * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS access problem
Larry, Suggestion 1) Have you tried putting copies of the files from the old computer on the new computer using the identical paths. This could solve your permissions problem, as the program is searching for a file that it can't find because it is in the wrong path. "C:\Incident.Ora\SYSTEM.MDA" "C:\Incident.Ora\Incident.mdb" "C:\Program Files\Common Files\Microsoft Shared\Microsoft Access Runtime\msaccess.exe" /runtime /wrkgrp "C:\Incident.Ora\SYSTEM.MDA" "C:\Incident.Ora\Incident.mdb" Suggestion 2) Older versions of Access had very poor security, One need only import the database files into an existing file and it would strip the security out of the data, and let you work with the data in the new database. Also I have MS Office 2000 Premium & Professional, and MS Office 97 Professional Edition(SP1&2 disks). Mike Larry Sacks wrote: Assuming this is what you meant: I changed the shortcut on my system to point to the latest version of MS Access (not the runtime) and included the rest of the goodies from the shortcut (basically invoke MS Access 2007 instead of the MS Access Runtime). When I do that, it actually loads the d/b and I'm prompted to enter the user-id. However, when I do that (and the user-id/password combination is correct), I get "The current user account doesn't have permission to convert or enable this database." And yes, I've tried it as local admin and domain admin. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Arnold Kee Sent: Thursday, October 02, 2008 10:47 AM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: [CGUYS] MS access problem Hello all: I believe that opening a runtime application will be successful if the underlying code of the runtime application is compatible with the version of access trying to open it. But the best chance I believe is to open the latest version of access possible and then to point to the mdb file target. Let us know how it works out. Thanks, Arnold [EMAIL PROTECTED] * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * -- *Mike Drabick HDH Construction Consultants, Inc 200 Harry S. Truman Parkway Suite 220 Annapolis, MD 21401 410-571-1100 410-571-1177 Fax* * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
I've had trouble on some machines getting Access 2007 to associate itself with older mdb files and in these cases have had to resort to opening the older files from within Access instead of from Explorer. Yes, it makes no sense. Anyway, it seems from your description you don't have this problem. Only two things I can suggest therefore that you may already have tried. First, when you open the file using the old system, try hitting the function key ( F11) to see if it will bring up hidden tables, and possible something from which the export command will work. But even you cannot export directly see if you can open the table and copy the data over directly by hitting ctl-a (select all) ctl-c (copy) and then pasting (ctl-v) into a new access table in a new database. Probably you've tried that but just in case . . . I know how frustrating that kind of problem can be so best of luck to you. JL Larry Sacks wrote: I can open it on his old system *BUT* not by going directly into MS Access 2000. If I try to open it, I get the permissions error again. Instead I can open it via the shortcut. When this d/b delivered, it used the MS Access Runtime 2000 so you didn't have to have Access installed. Oh... and there's no menu listed to export the data either. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B Sent: Thursday, October 02, 2008 9:07 AM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem Didn't you just say you can open it on his old machine? Then can't you just export it as a csv? On Thu, Oct 2, 2008 at 11:38 AM, Larry Sacks <[EMAIL PROTECTED]> wrote: I've been through the MS newsgroups, but I'll wade through them again. The solutions that sound plausible involve getting the original version of access, although how do I go about finding that? The software was installed in 2001. On Wed, Oct 1, 2008 at 8:11 PM, Larry Sacks <[EMAIL PROTECTED]> wrote: Nope. The mdb isn't corrupted. I can take the file on his new system, put it back on his old system and it works. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Have you tried running the application on a PC without ANY version of Office installed? If the application runs w/o Office installed try running the application after installing all MS Office applications EXCEPT MS Access. If that works then you can either: 1. Leave the system set up without MS Access installed. This works if your customer doesn't need MS Access for any other application. 2. See if there is some way to install/configure MS Access so it doesn't try to automatically upgrade existing databases. If neither of these solutions are available then your customer has a serious problem because it sounds like the vendor set up the database application with specific user level permissions. This means you have to know the correct administrative user id and password for the specific database if you want to upgrade/modify the application. Since it doesn't sound like the vendor provided this information to your customer as part of delivering the system then your customer is probably out of luck. Howard Larry Sacks wrote: I tried the MS Access Runtime 2007 but couldn't get too far with that. I installed the MS Access Runtime 2000 and can get the app to start and I can try to login but then I get an error of: "The current user account doesn't have permissions to covert or enable this database". From looking online, most of the solutions I can find say to start the d/b in the old version of Access and then convert it to the new version. Except I don't have the software from the old versions of Access. MS Office 2000 is the oldest we have here as the older stuff is no longer here. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Well, if you can't find an export function, maybe just print the darn thing out and scan it back in? I dunno what else to suggest. On Thu, Oct 2, 2008 at 12:52 PM, Larry Sacks <[EMAIL PROTECTED]> wrote: > I can open it on his old system *BUT* not by going directly into MS > Access 2000. If I try to open it, I get the permissions error again. > > Instead I can open it via the shortcut. > > When this d/b delivered, it used the MS Access Runtime 2000 so you > didn't have to have Access installed. > > Oh... and there's no menu listed to export the data either. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS access problem
Assuming this is what you meant: I changed the shortcut on my system to point to the latest version of MS Access (not the runtime) and included the rest of the goodies from the shortcut (basically invoke MS Access 2007 instead of the MS Access Runtime). When I do that, it actually loads the d/b and I'm prompted to enter the user-id. However, when I do that (and the user-id/password combination is correct), I get "The current user account doesn't have permission to convert or enable this database." And yes, I've tried it as local admin and domain admin. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Arnold Kee Sent: Thursday, October 02, 2008 10:47 AM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: [CGUYS] MS access problem Hello all: I believe that opening a runtime application will be successful if the underlying code of the runtime application is compatible with the version of access trying to open it. But the best chance I believe is to open the latest version of access possible and then to point to the mdb file target. Let us know how it works out. Thanks, Arnold [EMAIL PROTECTED] * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
I can open it on his old system *BUT* not by going directly into MS Access 2000. If I try to open it, I get the permissions error again. Instead I can open it via the shortcut. When this d/b delivered, it used the MS Access Runtime 2000 so you didn't have to have Access installed. Oh... and there's no menu listed to export the data either. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B Sent: Thursday, October 02, 2008 9:07 AM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem Didn't you just say you can open it on his old machine? Then can't you just export it as a csv? On Thu, Oct 2, 2008 at 11:38 AM, Larry Sacks <[EMAIL PROTECTED]> wrote: > I've been through the MS newsgroups, but I'll wade through them again. > The solutions that sound plausible involve getting the original version > of access, although how do I go about finding that? The software was > installed in 2001. > On Wed, Oct 1, 2008 at 8:11 PM, Larry Sacks <[EMAIL PROTECTED]> > wrote: >> Nope. The mdb isn't corrupted. I can take the file on his new > system, >> put it back on his old system and it works. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Didn't you just say you can open it on his old machine? Then can't you just export it as a csv? On Thu, Oct 2, 2008 at 11:38 AM, Larry Sacks <[EMAIL PROTECTED]> wrote: > I've been through the MS newsgroups, but I'll wade through them again. > The solutions that sound plausible involve getting the original version > of access, although how do I go about finding that? The software was > installed in 2001. > On Wed, Oct 1, 2008 at 8:11 PM, Larry Sacks <[EMAIL PROTECTED]> > wrote: >> Nope. The mdb isn't corrupted. I can take the file on his new > system, >> put it back on his old system and it works. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
I've been through the MS newsgroups, but I'll wade through them again. The solutions that sound plausible involve getting the original version of access, although how do I go about finding that? The software was installed in 2001. Sending you the file is an interesting idea, but the file has confidential information in it. It's not that I don't trust you, but besides, I've tried it on several computers, XP, Windows 2000, Office 2000, Office 2007, MS Access Runtime 2000, MS Access Runtime 2007 (either installed by themselves or some combination) and it doesn't work. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B Sent: Wednesday, October 01, 2008 5:35 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem Try the MS newsgroups. You can't be the first to have the problem. http://www.microsoft.com/office/community/en-us/default.mspx Send me the mdb file and I'll try it. Worse that can happen is I'll get the same error. On Wed, Oct 1, 2008 at 8:11 PM, Larry Sacks <[EMAIL PROTECTED]> wrote: > Nope. The mdb isn't corrupted. I can take the file on his new system, > put it back on his old system and it works. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Try the MS newsgroups. You can't be the first to have the problem. http://www.microsoft.com/office/community/en-us/default.mspx Send me the mdb file and I'll try it. Worse that can happen is I'll get the same error. On Wed, Oct 1, 2008 at 8:11 PM, Larry Sacks <[EMAIL PROTECTED]> wrote: > Nope. The mdb isn't corrupted. I can take the file on his new system, > put it back on his old system and it works. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Nope. The mdb isn't corrupted. I can take the file on his new system, put it back on his old system and it works. I think the error is a bit of a red herring. When you say "Open the shortcut" do you mean double clicking it? If so, yes I am. If I just go into MS Access 2007 (or Access 2000), and try to open the .mdb, I get the same error - the one about not having necessary permissions. I think one reason I can't just open the .mdb by itself is I need to do something with the .mdw file too. This was (from what I can tell) originally sent out with Access Runtime so recipients of the program didn't have to have Access installed. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B Sent: Wednesday, October 01, 2008 4:49 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem Perhaps the mdb is corrupted, but that error sounds like a red herring. You sure you weren't trying to open the shortcut? I just opened one of our old .mdb's in Access 2007 with no trouble. But oddly, now it shows a modified date of today, even though I didn't save or change anything. On Wed, Oct 1, 2008 at 5:07 PM, Larry Sacks <[EMAIL PROTECTED]> wrote: > UhI already went down that path before... > > When I try to open it in Access 2007, I get "You do not have the > necessary permissions to use the object. Have your > system administrator or the person who created this object establish the > appropriate permissions for you." * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Maybe. I just need to find someone with Office 2003. Does the old shortcut give anything useful? Microsoft Access Runtime\msaccess.exe" /runtime /wrkgrp "C:\Incident.Ora\SYSTEM.MDA" "C:\Incident.Ora\Incident.mdb" Could the .MDA file be related to the problem? Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart Marshall Sent: Wednesday, October 01, 2008 3:30 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem Dumb question. Can he send it to someone with Office 2003 and have them attempt to open and than save in the 03 format and then try and open in 07? Stewart At 05:17 PM 10/1/2008, you wrote: >I might be able to... but I believe the d/b was created in Access 97 (or >95)... > >The user's old PC is Windows 2000 with Office 2000 and the MS Access >2000 Runtime for the d/b. > >Larry > >-Original Message- >From: Computer Guys Discussion List >[mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart >Marshall >Sent: Wednesday, October 01, 2008 2:59 PM >To: COMPUTERGUYS-L@LISTSERV.AOL.COM >Subject: Re: [CGUYS] MS Access problem > >Can you get a copy of MS Access 2003? > >Stewart > > >At 04:51 PM 10/1/2008, you wrote: > >The only fixes I can find on the MS Knowledge base is to run the >version > >of Access that created the folder and then go to Tools/Security and do > >some stuff there... > > > > > >-Original Message- > >From: Computer Guys Discussion List > >[mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart > >Marshall > >Sent: Wednesday, October 01, 2008 2:31 PM > >To: COMPUTERGUYS-L@LISTSERV.AOL.COM > >Subject: Re: [CGUYS] MS Access problem > > > >There is a work around for this I think I heard about this from someone > >else. > > > >Check MS knowledge base and see if they have a fix for it. > > > >Stewart > > > > > >At 04:07 PM 10/1/2008, you wrote: > > >UhI already went down that path before... > > > > > >When I try to open it in Access 2007, I get "You do not have the > > >necessary permissions to use the object. Have your > > >system administrator or the person who created this object establish > >the > > >appropriate permissions for you." > > > > > >Larry > > > >Rev. Stewart A. Marshall > >mailto:[EMAIL PROTECTED] > >Prince of Peace www.princeofpeaceozark.org > >Ozark, AL SL 82 > > > > > >*** >* > >* > >** List info, subscription management, list rules, archives, privacy > >** > >** policy, calmness, a member map, and more at http://www.cguys.org/ > >** > >*** >* > >* > > > > > >*** >** > >** List info, subscription management, list rules, archives, privacy >** > >** policy, calmness, a member map, and more at http://www.cguys.org/ >** > >*** >** > >Rev. Stewart A. Marshall >mailto:[EMAIL PROTECTED] >Prince of Peace www.princeofpeaceozark.org >Ozark, AL SL 82 > * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Perhaps the mdb is corrupted, but that error sounds like a red herring. You sure you weren't trying to open the shortcut? I just opened one of our old .mdb's in Access 2007 with no trouble. But oddly, now it shows a modified date of today, even though I didn't save or change anything. On Wed, Oct 1, 2008 at 5:07 PM, Larry Sacks <[EMAIL PROTECTED]> wrote: > UhI already went down that path before... > > When I try to open it in Access 2007, I get "You do not have the > necessary permissions to use the object. Have your > system administrator or the person who created this object establish the > appropriate permissions for you." * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Dumb question. Can he send it to someone with Office 2003 and have them attempt to open and than save in the 03 format and then try and open in 07? Stewart At 05:17 PM 10/1/2008, you wrote: I might be able to... but I believe the d/b was created in Access 97 (or 95)... The user's old PC is Windows 2000 with Office 2000 and the MS Access 2000 Runtime for the d/b. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart Marshall Sent: Wednesday, October 01, 2008 2:59 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem Can you get a copy of MS Access 2003? Stewart At 04:51 PM 10/1/2008, you wrote: >The only fixes I can find on the MS Knowledge base is to run the version >of Access that created the folder and then go to Tools/Security and do >some stuff there... > > >-Original Message- >From: Computer Guys Discussion List >[mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart >Marshall >Sent: Wednesday, October 01, 2008 2:31 PM >To: COMPUTERGUYS-L@LISTSERV.AOL.COM >Subject: Re: [CGUYS] MS Access problem > >There is a work around for this I think I heard about this from someone >else. > >Check MS knowledge base and see if they have a fix for it. > >Stewart > > >At 04:07 PM 10/1/2008, you wrote: > >UhI already went down that path before... > > > >When I try to open it in Access 2007, I get "You do not have the > >necessary permissions to use the object. Have your > >system administrator or the person who created this object establish >the > >appropriate permissions for you." > > > >Larry > >Rev. Stewart A. Marshall >mailto:[EMAIL PROTECTED] >Prince of Peace www.princeofpeaceozark.org >Ozark, AL SL 82 > > >*** * >* >** List info, subscription management, list rules, archives, privacy >** >** policy, calmness, a member map, and more at http://www.cguys.org/ >** >*** * >* > > >*** ** >** List info, subscription management, list rules, archives, privacy ** >** policy, calmness, a member map, and more at http://www.cguys.org/ ** >*** ** Rev. Stewart A. Marshall mailto:[EMAIL PROTECTED] Prince of Peace www.princeofpeaceozark.org Ozark, AL SL 82 * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * Rev. Stewart A. Marshall mailto:[EMAIL PROTECTED] Prince of Peace www.princeofpeaceozark.org Ozark, AL SL 82 * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
I might be able to... but I believe the d/b was created in Access 97 (or 95)... The user's old PC is Windows 2000 with Office 2000 and the MS Access 2000 Runtime for the d/b. Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart Marshall Sent: Wednesday, October 01, 2008 2:59 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem Can you get a copy of MS Access 2003? Stewart At 04:51 PM 10/1/2008, you wrote: >The only fixes I can find on the MS Knowledge base is to run the version >of Access that created the folder and then go to Tools/Security and do >some stuff there... > > >-Original Message- >From: Computer Guys Discussion List >[mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart >Marshall >Sent: Wednesday, October 01, 2008 2:31 PM >To: COMPUTERGUYS-L@LISTSERV.AOL.COM >Subject: Re: [CGUYS] MS Access problem > >There is a work around for this I think I heard about this from someone >else. > >Check MS knowledge base and see if they have a fix for it. > >Stewart > > >At 04:07 PM 10/1/2008, you wrote: > >UhI already went down that path before... > > > >When I try to open it in Access 2007, I get "You do not have the > >necessary permissions to use the object. Have your > >system administrator or the person who created this object establish >the > >appropriate permissions for you." > > > >Larry > >Rev. Stewart A. Marshall >mailto:[EMAIL PROTECTED] >Prince of Peace www.princeofpeaceozark.org >Ozark, AL SL 82 > > >*** * >* >** List info, subscription management, list rules, archives, privacy >** >** policy, calmness, a member map, and more at http://www.cguys.org/ >** >*** * >* > > >*** ** >** List info, subscription management, list rules, archives, privacy ** >** policy, calmness, a member map, and more at http://www.cguys.org/ ** >*** ** Rev. Stewart A. Marshall mailto:[EMAIL PROTECTED] Prince of Peace www.princeofpeaceozark.org Ozark, AL SL 82 * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
Can you get a copy of MS Access 2003? Stewart At 04:51 PM 10/1/2008, you wrote: The only fixes I can find on the MS Knowledge base is to run the version of Access that created the folder and then go to Tools/Security and do some stuff there... -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart Marshall Sent: Wednesday, October 01, 2008 2:31 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem There is a work around for this I think I heard about this from someone else. Check MS knowledge base and see if they have a fix for it. Stewart At 04:07 PM 10/1/2008, you wrote: >UhI already went down that path before... > >When I try to open it in Access 2007, I get "You do not have the >necessary permissions to use the object. Have your >system administrator or the person who created this object establish the >appropriate permissions for you." > >Larry Rev. Stewart A. Marshall mailto:[EMAIL PROTECTED] Prince of Peace www.princeofpeaceozark.org Ozark, AL SL 82 * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * Rev. Stewart A. Marshall mailto:[EMAIL PROTECTED] Prince of Peace www.princeofpeaceozark.org Ozark, AL SL 82 * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
The only fixes I can find on the MS Knowledge base is to run the version of Access that created the folder and then go to Tools/Security and do some stuff there... -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Rev. Stewart Marshall Sent: Wednesday, October 01, 2008 2:31 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem There is a work around for this I think I heard about this from someone else. Check MS knowledge base and see if they have a fix for it. Stewart At 04:07 PM 10/1/2008, you wrote: >UhI already went down that path before... > >When I try to open it in Access 2007, I get "You do not have the >necessary permissions to use the object. Have your >system administrator or the person who created this object establish the >appropriate permissions for you." > >Larry Rev. Stewart A. Marshall mailto:[EMAIL PROTECTED] Prince of Peace www.princeofpeaceozark.org Ozark, AL SL 82 * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
There is a work around for this I think I heard about this from someone else. Check MS knowledge base and see if they have a fix for it. Stewart At 04:07 PM 10/1/2008, you wrote: UhI already went down that path before... When I try to open it in Access 2007, I get "You do not have the necessary permissions to use the object. Have your system administrator or the person who created this object establish the appropriate permissions for you." Larry Rev. Stewart A. Marshall mailto:[EMAIL PROTECTED] Prince of Peace www.princeofpeaceozark.org Ozark, AL SL 82 * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
UhI already went down that path before... When I try to open it in Access 2007, I get "You do not have the necessary permissions to use the object. Have your system administrator or the person who created this object establish the appropriate permissions for you." Larry -Original Message- From: Computer Guys Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tony B Sent: Wednesday, October 01, 2008 1:28 PM To: COMPUTERGUYS-L@LISTSERV.AOL.COM Subject: Re: [CGUYS] MS Access problem You should have no trouble opening the old .mdb directly within Office2007. I don't even think they changed the .mdb format. Once you have it opened you can make a new shortcut to it. Just trash the old shortcut. As you've discovered, they're not normal Windows shortcuts. On Wed, Oct 1, 2008 at 1:18 PM, Larry Sacks <[EMAIL PROTECTED]> wrote: > I've got a user who is getting a new PC. His old system was Windows > 2000 with Office 2000. > > > > He's got an Access database written by an outside vendor - that as far > as we can tell - no longer exists. It uses the MS Access Runtime 2000, > but the database has been around since 2001. > > > > His new system is Windows XP running Office 2007. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** * * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
Re: [CGUYS] MS Access problem
You should have no trouble opening the old .mdb directly within Office2007. I don't even think they changed the .mdb format. Once you have it opened you can make a new shortcut to it. Just trash the old shortcut. As you've discovered, they're not normal Windows shortcuts. On Wed, Oct 1, 2008 at 1:18 PM, Larry Sacks <[EMAIL PROTECTED]> wrote: > I've got a user who is getting a new PC. His old system was Windows > 2000 with Office 2000. > > > > He's got an Access database written by an outside vendor - that as far > as we can tell - no longer exists. It uses the MS Access Runtime 2000, > but the database has been around since 2001. > > > > His new system is Windows XP running Office 2007. * ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *
