sturner (7/6/2010)

---

there is no way around it (for the ones where there are multiple parent rows in the view result set).

I recommend you use stored procedures to retrieve and update...

Eric Mamet (4/26/2010)

---

I have since discovered more...

I have the laptop with me and could do a few experiments.

The problem is "timeout" after about 35 seconds.

I tried without success...

1. Where is SQLServer running? Is it on the same file server that the .mdb file was on or was it on another server? Is the other server located in...

ehamouda (5/7/2010)

---

Hi.

i was able "after a long time of trial and error" to migrate access database to sql 2005 and use linked tables to access the sql backend from the...

ukarlink (6/30/2010)

---

Private Sub Form_Load()

Dim cnThisConnect As ADODB.Connection

Dim rcdCompanies As ADODB.Recordset

Set cnThisConnect = CurrentProject.Connection

rcdCompanies.Open "tblCompanies", cnThisConnect, adOpenKeyset, adLockOptimistic

rcdCompanies.AddNew

rcdCompanies![CompanyName] = "Winthrop Brewing Companies"

rcdCompanies![Address] = "155 Riverside Ave."

rcdCompanies![City] = "Winthrop"

rcdCompanies![StateOrProvince] = "WA"

rcdCompanies![PostalCode] =...

Its has an Access front end. When I was reading up on security yesterday, the articles that I read suggested that Application Roles required the password to be provided by...

Thx, I did figure out that I needed to grant execute permissions to the users. Right now, we only have 10-ish users so I've added them individually, but I'm now...

Maybe I should spend more time at work doing work and less time at home doing work. Since I'm running SQLServer Express on my laptop, the server name and host...

The permissions allow the person to look, buy, shop, refund, sell the store, trash it...

This actually looks promising.

http://www.winblogs.net/index.php/2009/11/22/automating-backup-of-databases-in-sql-20052008-express/

Yes Powershell is included.

Thanks. Works like a charm. Now I just need to figure out how to output the results as a table that Access can use. (Thanks in advance for posting help...

I'm not a SQLServer God & Guru by anymeans, but I'd be doing a lot of reading up on security to ensure that one user doesn't accidentally (or deliberately) screw...

david.c.holley (10/7/2009)

---

Jeff Moden (10/7/2009)

---

Keep in mind that...

So its completely different from having a column (of any other data type) that stores the lat and a different on for the long as values. The geography data type...