Let's separate the issues.

I am under impression that you created a linked server and sproc on the SQL server machine (not the local PC) and if you are going to...

That is different from your original request, but let's try.

What is the authentication that you are using on your local machine?

How is your local PC registration is done (SQL authentication,...

Something like this?:

http://vyaskn.tripod.com/sqlsps.htm

Sorry, your solution then does not make any sense for me.

Why would you want to involve SQL server at all? You are creating a stored procedure in SQL server just...

1. Windows firewall.

2. SQL server / Agent of server 2 are running on the "local" accounts.

3. SQL server browser service is not running on computer 1.

ApexSQL Diff - http://www.apexsql.com/sql_tools_diff.asp

I would assume that merging data will still get you a certain amount of efforts though...

Tough luck... As I said before that is happening because you did not read documentation on SQL server security.

That is also happening because your local SQL server on your...

I believe that duplicate entries are not allowed on this forum.

Just post what is it that you did not like about suggested solution?

IDERA SQLSafe suggests a freeware version

Duplicate request?

http://www.sqlservercentral.com/Forums/Topic566099-357-1.aspx

Forget about sp_tables_EX.

That is nice and simple sproc, which you do not need (or can read about in BOL).

What about select * from ACC...tablename?

Edward,

you will not get any new and shiny features of SQL 2005, but you will still get better memory management; different behavior of response on memory pressure etc. You also...

Original article written by Marc Cohen is great, but not always true.

http://beingmarkcohen.com/?p=62

Read a great response by sc0rp10n in the same post.

Ultimate and short article about short-circuiting...

w3wp!resourceutilities!5!8/19/2008-13:46:20:: i INFO: Evaluation copy: 0 days left

I note there is an entry stating there are 0 days left for evaluation. I don't know if this is relevant because...

Ultimate security guide for Access:

Test scenario:

1. Computer 1 - SQL server 32 bit edition running on Windows 2003

2. Computer 2 - Windows XP desktop.

On computer 2 create a new folder...

🙂

Quinn,

it is up to you how you are going to use it.

It is just that MS does not recommend using opendatasource for frequent accesses.

Excerpt from BOL:

"Like the OPENROWSET function, OPENDATASOURCE...