Replies

Hi Wendall,

Thanks for your reply. I just looked through the VBA Editor in my Access app, and found about 100 forms. My backend .mdb containing tables of data is 99MB. My front-end .mde file is about 19MB (after compact and repair). I also have the orginal .mdb file that is linked to the backend tables.

I have some questions on how to shrink the database, based on your reference to the other post. The steps are quoted below, my questions follow.

To post a stripped down copy of the database:
• Make a copy of the database and work with that.
• Remove all database objects (tables, queries, forms, reports, macros and modules) that are not relevant to the problem.
• In the remaining table(s), remove most records – leave only the minimum number necessary to demonstrate the problem.
• Remove or modify data of a confidential nature.
• Do a compact and repair (Tools/Database Utilities).
• Make a zip file containing the database; it should be below 100KB.
• If you have difficulties getting the zip file below 100 KB, save the database in Access 97 format and then zip it.
• Attach the zip file to a reply.

Is this how I should proceed to start shrinking the db?

-Makes copies of the orginal front end .mdb, and the backend .mdb containing the tables.
-Link the front end copy to the new back end copy.
-Start deleting forms and queries and table data not relevant to the problem.
I don’t know how choose what the delete in the copy file without breaking it.

Or should I combine the front and end and back end into one database file for testing, to shrink it down and make it mroe easilier portable to share in this forum?

Below are steps, including questions on how I would combine the front end, and back end.

-Combine the front-end and back-end componets of the access application, to make a single testing .mdb file. Open the orginal front end .mdb, and delete the links to the backend .mdb.
However, I can’t find were to access and view the original design screen for new database. The screen with the Objects (Tables, Queries, Forms, Reports, Pages, Macros, Modules) listed on the left, and a white box on the right with “Create Query in Design View”.Once at the screen I will go to the table view, and delete all the links to the backend .mdb.
Then I will right click Tables and select import, and then import the data in directly to the front-end .mdb.

-At this point I should have a single .mdb database will all the queries, forms, and tables together.
Now do you recommend I start shrinking this copy of the database? Should I delete data strait out of the tables to make it smaller?
How do you recommend I shrink down the forms? I don’t really know how to pick and choose with ones to delete.
-If I needed to, how would I save the database in Access 97 format?

Like I said, I didn’t develop this access database, nor the front end interface/switchboard.

What do you think is the best way for me to proceed? Do you think the best way if for me to read a whole book on programming access 2003 (I own Allison Balter’s Mastering Microsoft Office Access 2003) before attempting the above steps? Or do you think you will be able to guide me throught the process of shrinking the database

Thank you,
Peter

More often than not, an error that says “Function is not available…” such as you are getting indicates that a reference is missing. Unfortunately this appears to be a fairly complex application, and to do any more than make some general suggestions will require being able to look at the processes behind the forms involved. Can you post a stripped down copy that has been sanitized to remove any personal information? See Post 401925 for instructions on how to do that.

This for your tip. I had never even heard of that one.

What’s the difference between the entry level “HD” version and the “Studio Platium” verson?

Peter

None of the above. I use Sony’s Vegas Movie Studio Platinum. I’ve previously used some of the others and they are okay for basics. In the past I used Pinnacle Studio and have Roxio installed. However Vegas is more to my editing style and liking on the PC.

I found the solution to the gpt.ini read error on the network.

openletters
Welcome Newcomer

1 Posts
Status: offline

Posted – 08/19/2008 : 05:30:37 AM

Hi Guys, I have been reading this thread for a number of days now, and still nothing could help me with the 1058 and 1030 error codes.

It was mentioned earlier, Keep it simple stupid. And yep this is what fixed it for me.

The TCP/IP NetBIOS Helper service was disabled.
Please check this before you continue with any majour tasks like I did. This may or may not help.

Good luck!

That was the solution that worked for me!

Here is the link:
http://www.minasi.co…129&whichpage=3%5B/size%5D%5B/font%5D

I have now resolved my group policy testing, and have successfully run my first group policy test by starting notepad.exe automatically on any computer I log onto!
Now to start testing some useful policies!

Peter

So, I figured out why the Test Group Policy for notepad.exe wasn’t running. In the “Group Policy Test OU/Container” I created, instead of moving my user object there, I created a group called “Group Policy Test Group” in that container. Then I just added myself to the “Group Policy Test Group” security group thinking that would be enough. After I moved my user object directly to that container it worked.

I also removed my user object from the “Security Filtering” section of the Group Policy. That seemed to have no effect either way. I don’t know what “Security Filtering” is for anyway.

On my PC, I ran “gpupdate /force” and got a real error! I am actually happy to get a real error.

C:Windowssystem32>gpupdate /force
Updating Policy…

User policy could not be updated successfully. The following errors were encount
ered:

The processing of Group Policy failed. Windows attempted to read the file \a.orgsysvola.orgPolicies{CA5EFA8B-BA08-49FD-85A8-0C7850D85F7F}gpt
.ini from a domain controller and was not successful. Group Policy settings may
not be applied until this event is resolved. This issue may be transient and cou
ld be caused by one or more of the following:
a) Name Resolution/Network Connectivity to the current domain controller.
b) File Replication Service Latency (a file created on another domain controller
has not replicated to the current domain controller).
c) The Distributed File System (DFS) client has been disabled.
Computer policy could not be updated successfully. The following errors were enc
ountered:

The processing of Group Policy failed. Windows attempted to read the file \a.orgsysvola.orgPolicies{CA5EFA8B-BA08-49FD-85A8-0C7850D85F7F}gpt
.ini from a domain controller and was not successful. Group Policy settings may
not be applied until this event is resolved. This issue may be transient and cou
ld be caused by one or more of the following:
a) Name Resolution/Network Connectivity to the current domain controller.
b) File Replication Service Latency (a file created on another domain controller
has not replicated to the current domain controller).
c) The Distributed File System (DFS) client has been disabled.

To diagnose the failure, review the event log or invoke gpmc.msc to access infor
mation about Group Policy results.

After reading this article below which I found through the event viewer, I determined that I have a DFS error.
http://technet.micro…259(WS.10).aspx

So basically I want to add a new DFS entry for “\a.orgsysvola.orgPolicies{CA5EFA8B-BA08-49FD-85A8-0C7850D85F7F}gpt”.
But I think I want to change the path a little bit for where the Group Policies are stored. Where is the setting to change where Active Directory stores group policy?

Is creating a shared folder/DFS entry the correct approach for getting Group Policy to work?

Thanks,
Peter

I tried testing the notepad Group Policy on a Windows XP machine, and it worked!
After making the fixes in the previous post, that was the trick. (I did have to re-add my username to the security filtering).

So I know group policy now works for other computers in my network, but not my own.
Any idea how to troubleshoot the error in my previous post still?

Thanks,
Peter

Code:

S:>gpupdate
Refreshing Policy...

User Policy Refresh has completed.
Computer Policy Refresh has completed.


S:>gpresult

Microsoft (R) Windows (R) XP Operating System Group Policy Result tool v2.0
Copyright (C) Microsoft Corp. 1981-2001

Created On 1/20/2010 at 5:14:34 PM


RSOP results for Ap on F : Logging Mode
-----------------------------------------------------------

OS Type:     				Microsoft Windows XP Professional
OS Configuration:        	Member Workstation
OS Version:              	5.1.2600
Domain Name: 				A
Domain Type: 				Windows 2000
Site Name:   				Default-First-Site-Name
Roaming Profile:
Local Profile:   			C:Documents and Settingsp
Connected over a slow link?: No


COMPUTER SETTINGS
------------------
	CN=F,CN=Computers,DC=a,DC=
	Last time Group Policy was applied: 1/20/2010 at 5:14:16 PM
	Group Policy was applied from:  	A.a.org
	Group Policy slow link threshold:   500 kbps

	Applied Group Policy Objects
	-----------------------------
    	Default Domain Policy

	The following GPOs were not applied because they were filtered out
	-------------------------------------------------------------------
    	Local Group Policy
        	Filtering:  Not Applied (Empty)

	The computer is a part of the following security groups:
	--------------------------------------------------------
    	BUILTINAdministrators
    	Everyone
    	BUILTINUsers
    	NT AUTHORITYNETWORK
    	NT AUTHORITYAuthenticated Users
    	F$
    	Domain Computers
    	CERTSVC_DCOM_ACCESS


USER SETTINGS
--------------
	CN=P,OU=Group Policy Test OU/Container,DC=a,DC=org
	Last time Group Policy was applied: 1/20/2010 at 5:14:16 PM
	Group Policy was applied from:  	A.a.org
	Group Policy slow link threshold:   500 kbps

	Applied Group Policy Objects
	-----------------------------
    	TEST - Run Notepad at Startup

	The following GPOs were not applied because they were filtered out
	-------------------------------------------------------------------
    	Default Domain Policy
        	Filtering:  Disabled (GPO)

    	Local Group Policy
        	Filtering:  Not Applied (Empty)

	The user is a part of the following security groups:
	----------------------------------------------------
    	Domain Users
    	Everyone
    	BUILTINUsers
    	BUILTINAdministrators
    	NT AUTHORITYINTERACTIVE
    	NT AUTHORITYAuthenticated Users
    	LOCAL
    	Domain Admins
    	RicohPGrp
    	ColorPgrp
    	Group Policy Test Group
    	PWDCgrp
    	TS Users Group
    	Management
    	ReceptionPgrp
    	CERTSVC_DCOM_ACCESS

S:>

So, I figured out why the Test Group Policy for notepad.exe wasn’t running. In the “Group Policy Test OU/Container” I created, instead of moving my user object there, I created a group called “Group Policy Test Group” in that container. Then I just added myself to the “Group Policy Test Group” security group thinking that would be enough. After I moved my user object directly to that container it worked.

I also removed my user object from the “Security Filtering” section of the Group Policy. That seemed to have no effect either way. I don’t know what “Security Filtering” is for anyway.

On my PC, I ran “gpupdate /force” and got a real error! I am actually happy to get a real error.

C:Windowssystem32>gpupdate /force
Updating Policy…

User policy could not be updated successfully. The following errors were encount
ered:

The processing of Group Policy failed. Windows attempted to read the file \a.orgsysvola.orgPolicies{CA5EFA8B-BA08-49FD-85A8-0C7850D85F7F}gpt
.ini from a domain controller and was not successful. Group Policy settings may
not be applied until this event is resolved. This issue may be transient and cou
ld be caused by one or more of the following:
a) Name Resolution/Network Connectivity to the current domain controller.
b) File Replication Service Latency (a file created on another domain controller
has not replicated to the current domain controller).
c) The Distributed File System (DFS) client has been disabled.
Computer policy could not be updated successfully. The following errors were enc
ountered:

The processing of Group Policy failed. Windows attempted to read the file \a.orgsysvola.orgPolicies{CA5EFA8B-BA08-49FD-85A8-0C7850D85F7F}gpt
.ini from a domain controller and was not successful. Group Policy settings may
not be applied until this event is resolved. This issue may be transient and cou
ld be caused by one or more of the following:
a) Name Resolution/Network Connectivity to the current domain controller.
b) File Replication Service Latency (a file created on another domain controller
has not replicated to the current domain controller).
c) The Distributed File System (DFS) client has been disabled.

To diagnose the failure, review the event log or invoke gpmc.msc to access infor
mation about Group Policy results.

After reading this article below which I found through the event viewer, I determined that I have a DFS error.
http://technet.microsoft.com/en-us/library/cc727259(WS.10).aspx

So basically I want to add a new DFS entry for “\a.orgsysvola.orgPolicies{CA5EFA8B-BA08-49FD-85A8-0C7850D85F7F}gpt”.
But I think I want to change the path a little bit for where the Group Policies are stored. Where is the setting to change where Active Directory stores group policy?

Is creating a shared folder/DFS entry the correct approach for getting Group Policy to work?

Thanks,
Peter

Thanks Peter J,

I just purchased Pinnacle HD for $46.99 and a Happauge 950Q HD TV tuner card for $69.99 off Amazon.
I can’t wait to start transcribing VHS and recording HD TV off the air!

-Peter Z.

I usually get what Fry’s has on sale. Currently I am running Ultimate Collection because of a deal that Fry’s had. But earlier was was running just Studio – it was fine for transferring VHS tapes, or for creating DVDs from movies recorded from TV.

By the way, I have a Hauppage HVR-1600 video capture card and use the bundled WinTV to record the tapes or shows. I then run the MPG file through Studio, trimming and adding menus to convert to DVD.

And a hint: don’t let Studio burn your DVD – it incorrectly guesses the size of your video, overestimating by as much as 40% (in other words, it thinks that a video that will fit easily on a DVD is too big to fit). I always tell it that I have a dual-layer DVD and have it generate the DVD image to the disk drive. Then I use Nero to burn the DVD. I also set the WinTV recorder to proper level so that the resulting movie fits on a single DVD – this way the DVD retains any Closed Captioning stream that is present.

See the post I reference below (date=’2010-01-12 16:21′)?
I explain how I liked my Group Policy to a Test OU, AND I included a screenshot.

First you ask me to stop attaching Word Documents with Screenshots, now my screen shots aren’t good enough, ugh, this problem is taking a really long time to diagnose. Group Policy is hard…I still don’t know how to use it. In the future I will try and follow your advice to upload jpg screenshots of text files output, or the text file output itself.

Did you try saving the JPG’s to you computer, so you can expand them? Note that I blocked out my user name and domain in all the screenshots for security purposes.

In this post I have uploaded screenshots of the cmd prompt output. I ran “gpresult /r /v > gpresult.txt”. Please review the whole thread before responding. Remember, I show the screenshot in an earlier post that show my Group Policy and it shows that notepad.exe is supposed to start at startup. But that policy is not flowing to my account, even though my username is linked to that OU in the Policy.

Also, don’t take anything I say as true, I may have just set up the policy wrong, as I have never done this before… Please verify all the steps that I have showed you in my posts.

Let’s get this nut cracked!!! (Nut referring the issue at hand of course.)

Thanks,
Peter

Hi Paul,
I linked my Test Group Policy to a new Test OU, but notepad isn’t opening when I log out and log back in.

Can you please take a close look at my new attached screenshots?
I run my Domain Controller on Windows Server 2003 SP1, and the PC I am testing the User Policy on runs Windows Vista.

Thanks.

I can’t see the any GPOs except Default Domain Policy being applied. (It would be easier to read if you used the text output and pasted the text.)

Is your user in the Test OU?
For the GPO to be applied to a user it needs to be linked the the OU or parent OU of the user. Same goes for a machine GPO.

cheers, Paul

Attached are the screenshots in jpg format.

I ran rsop and I ran gpresult /h (for html output).

-Peter

Open a Command Prompt on the XP / Vista machine and type gpresult. This will tell you what group policies are applied.
Click Start > Run and type rsop.msc. This will show you the result of the application of those policies.

p.s. Save the screenshots as JPG and embed them in your reply. Saves us downloading Word documents.

cheers, Paul

Attached are the screenshots in jpg format.

I ran rsop and I ran gpresult /h (for html output).

-Peter

Open a Command Prompt on the XP / Vista machine and type gpresult. This will tell you what group policies are applied.
Click Start > Run and type rsop.msc. This will show you the result of the application of those policies.

p.s. Save the screenshots as JPG and embed them in your reply. Saves us downloading Word documents.

cheers, Paul

Attached are the screenshots in jpg format.

I ran rsop and I ran gpresult /h (for html output).

-Peter

Open a Command Prompt on the XP / Vista machine and type gpresult. This will tell you what group policies are applied.
Click Start > Run and type rsop.msc. This will show you the result of the application of those policies.

p.s. Save the screenshots as JPG and embed them in your reply. Saves us downloading Word documents.

cheers, Paul

Attached are the screenshots in jpg format.

I ran rsop and I ran gpresult /h (for html output).

-Peter

Open a Command Prompt on the XP / Vista machine and type gpresult. This will tell you what group policies are applied.
Click Start > Run and type rsop.msc. This will show you the result of the application of those policies.

p.s. Save the screenshots as JPG and embed them in your reply. Saves us downloading Word documents.

cheers, Paul

Attached are the screenshots in jpg format.

I ran rsop and I ran gpresult /h (for html output).

-Peter

Open a Command Prompt on the XP / Vista machine and type gpresult. This will tell you what group policies are applied.
Click Start > Run and type rsop.msc. This will show you the result of the application of those policies.

p.s. Save the screenshots as JPG and embed them in your reply. Saves us downloading Word documents.

cheers, Paul

Attached are the screenshots in jpg format.

I ran rsop and I ran gpresult /h (for html output).

-Peter

Open a Command Prompt on the XP / Vista machine and type gpresult. This will tell you what group policies are applied.
Click Start > Run and type rsop.msc. This will show you the result of the application of those policies.

p.s. Save the screenshots as JPG and embed them in your reply. Saves us downloading Word documents.

cheers, Paul

Attached are the screenshots in jpg format.

I ran rsop and I ran gpresult /h (for html output).

-Peter

Open a Command Prompt on the XP / Vista machine and type gpresult. This will tell you what group policies are applied.
Click Start > Run and type rsop.msc. This will show you the result of the application of those policies.

p.s. Save the screenshots as JPG and embed them in your reply. Saves us downloading Word documents.

cheers, Paul

Attached are the screenshots in jpg format.

I ran rsop and I ran gpresult /h (for html output).

-Peter

Open a Command Prompt on the XP / Vista machine and type gpresult. This will tell you what group policies are applied.
Click Start > Run and type rsop.msc. This will show you the result of the application of those policies.

p.s. Save the screenshots as JPG and embed them in your reply. Saves us downloading Word documents.

cheers, Paul