I would like to demote RODC server (Windows server 2012) to disjoin the domain and act as a local file sharing server only. Please give a brief actions of what I could do? step by step in short brief only would be okay.

Many thanks.

Hi,

I am Rupesh & I am new to this forum.

I am trying to build a tool in excel which can update database maintained in access.

There will be 3 to 4 user for this excel tool which will be connected to one access database.

The excel will act as the front end tool & access as a backend tool.

I want excel VBA to perform 3 things:

1. It will update data in access based on 2 column which will act as a unique code.
2. It will add any new row if the data doesnt match with previous unique code.
3. If the user wants to delete perticular row / range then it will be deleted from database also.

Below sample of table:

Country      Product code      Sub-Brand      Mfg Base
Russia      SRU030008869020137      Syrups      Own
Russia      SRU030008869020141      Syrups      Own
Russia      SRU030008564220158      Tablets      Own
Russia      SRU030008564220258      Tablets      Own
Russia      SRU030008564220558      Tablets      Own
USA      SRU030008869020137      Syrups      Own
USA      SRU030008869020141      Syrups      Own
USA      SRU030008564220158      Tablets      Own
USA      SRU030008564220258      Tablets      Own
USA      SRU030008564220558      Tablets      Own

1st two column will act as a unique key.

We cannot use a replacement code since there will be multiple user working on different region, replacement option can change  or erase others database.

Thanks for the help in advance.

Regards,

Rupesh.

Hi,
We experience a problem with Outlook room booking in the following case:
1. I book a reoccurring meeting every Thursday for 5 weeks and add a Meeting Room to the invitation.
2. The meeting room is occupied 1 Thursday out of the 5 Thursdays in question
3. When I send the invitation, Outlook (the meeting room) declines ALL 5 Thursday meetings
What I would like:
4. Instead of Outlook (the meeting room) declining ALL 5 Thursday meetings, I would like the meeting room to accept the 4 thursdays where the meeting room is available and only decline the 1 Thursday where the meeting room is occupied.
In my old company, they had set up Outlook to act as bullet 4. But in my new company no one knows how to set up Outlook correctly, so meeting rooms will not dismiss all meetings in an reoccurring event, but only the one(s) where the meeting room is already booked.
I hope, you can help us with the problem :) Thank you!

Hi,
I have lost an Excel file several times for not disconnecting an API program.
Therefore I would like a message box saying "Have you logged off?" that appears when I try to close the Excel workbook. This will act as a reminder and save me from hours of file reconstruction.
Many thanks
Ian

Hello:

I have created an Excel spreadsheet that pulls data from SQL through a T-SQL query that I created and placed in the Excel "Data" menu's "Connections" section.

I just found out that I need to add a column, to this spreadsheet, that will act as a formula column to eliminate a case sensitivity issue.

Anyway, this column will be a permanent column in the sense that the formula in each row for that column will need to be automatically "copied straight down" the column every time a new row is added to SQL and therefore to the spreadsheet.

How do I go about doing this?

Thank you!

John

I have a client who will be running ACT 2012 until his company merges with another early next year.

I've just installed ACT 2012 Pro on a Windows 10 Machine running Office 2016.  With a little tweaking the program works under Windows 10.  However, in the ACT 2012 email setup, Outlook (2016) does not show up as a choice.  I've seen this before with other programs such as old versions of Simply Accounting, and that sort of thing.

Is there a workaround for this? (Actually I'm not sure what's causing it).  I can install Outlook 2007 back on his machine for the time being, but I'd rather not.

Thanks.
Dave

Our domain controller is down for good. We have 2nd DC which act as backup. Active directory is there but no DNS and when i tried installing DNS, it gives me an error

I'm used to setting up mail hosts with a secondary which is actually a smarthost in case the main host goes down for a while.
In this case, I have a primary mail server but it's on a network that sometimes has issues and for a variety of reasons, we cannot move it.

Therefore, I want to build a server in one of our data centers that can be highly reliable but it should basically act as the sender and smarthost.

Meaning, it should authoritatively send outgoing email from hosts inside the LAN but it should also act as a smarthost should any of that email be bound for the primary host. If the primary is down, then hang on to the email, keep trying until the host is back online.

I'm not sure how something like this would be set up since I don't want to make the smarthost the primary in the MX DNS records. Kinda confusing no?

Need some assistance with designing the best soultion for the storefront servers that will offer both the most efficent conenction for users and resilience. I have a diagram that show the network layout where users and app servers will be situation.

Zone1: Has local storefront server. Users access application hosted locally on site and also application deployed in Zone app servers.

Zone2: Storefront used to service users connecting from European sites to access apps on Zone 2 servers.

Question. What is the best way to configure the storefront server at each site? Ideally I want them to act as a failover. I also want to them to a zone so that users connections are serviced by the closest storefront server.

In the past I have used a round robin connection. but i dont think this is best for this setup, or is there some other way I can achieve this?

I think the problem is that I want to use a single unique name for the storefront connection. This works fine with a round robin setup, but i dont see how i can use this method with zones as well.

I could have both servers in zone two using round robin, this is the center of this MPLS network and the connection to zone 1 is 100MG.

Your thoughts?

Their primary location, here in xxxx, has a new server up and running with a single Windows Server 2012 R2 Standard VM that is acting as their domain controller, primary DNS server, and file server for their xxxxx office.  In xxxxx, we have an identical server that we are spinning up a new Windows Server 2012 R2 Standard VM on.  This server will act as a file server for their aaaaaa office, but I also want it to be a domain controller and DNS server for their office.  Now, here's the thing though.  I want them to BOTH be on the same domain.  In other words, I want to setup xxxxxx to be the primary domain controller, and aaaaaa as the secondary domain controller.  All of the workstations will point to the xxxx VM as their primary DNS and the aaaaa VM as their secondary DNS via a site-to-site VPN connecting the two networks.  In aaaaa, it would be just the reverse, with their workstations looking at the aaaaa VM as their primary DNS and then xxxxx as the secondary DNS.

[10:30]  
In practice, this was working fine when we had it setup working in the lab.  However, from an actual deployment and production standpoint, what do you think?  Are there issues with having basically a "child" domain controller of a primary domain located in a different location connected via Site-to-Site VPN?