Thanks dan-572483, I will give your answer a try. It sounds good.

Thanks so very much Lowell. You really went out of your way to help. I appreciate it a lot. Works great.

Lowell (5/9/2013)

---

here's a quick adaptation of another post i did for almost the same thing;

you'd need to tweak the mail settings, assuming you have db mail all set up:

--2005/08

...

Newbie Jones (5/9/2013)

---

Can someone explain the 3 different options in the upsizing wizard?

1) Create a new Access client/server application

2) Link SQL server tables to existing application

3) No Application changes

I want...

Thanks very much for all the information Lowell. He says we can failover from VMware replica (VMware replica though we have transactional replication too. I'd have to make the...

Thanks. Agreed but my boss and his network admin LURVE AppAssure. They don't react well to any ideas that it's not the bees knees. He wanted me to...

Solved my own problem. I'll give an explanation in case anyone needs this someday. It tuirned out that, because I was using the chrome browser on my client...

Thanks Erin. I created my newest publication with my windows account and I think I remember reading that replication should be set up with a SQL login. But, the...

Ok thank you. I tried connecting as sa and still no luck. I have been trouble finding who the owner of the publications is as it doesn't display...

I am on the Publication Access List (PAL). Thank you for reminding me to check it. I am logged in with a windows user ID with system administrator access....

Thanks Roger. I was hoping to use SSIS. Have you had to refresh a database (mine's in test) that was acting as a publisher and distributor to another...

Thank you SQLAJ. Yes there are many ways, for example, I can use SSIS and everything works beautifully but that's without replication. I was hoping that someone could give...

Thanks. I will continue over in that forum.