Open Access MDB - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Open Access MDB

Author

Topic

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-09-24 : 12:30:56

Im trying to set up a linked server but the only way to open this file in access 2000 or access 2003 is use this

Having shortcut as this
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\test_inventory.mdb" /WRKGRP "c:\system.mdw"

I cannot seem to set up the linked server data source to be this
Give me errors using jet odbc

If i have just new database created in access i can just set
data source to c"\test_inventory.mdb and works

Only have issue with secured access database.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-24 : 23:47:37

Create an odbc dsn for access db then use that dsn to create linked server.

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-09-25 : 08:55:41

Tried to do this with ODBC did not work when remove the permissions in access and just have
mdb it works .

Odd

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-09-25 : 12:08:28

i managed to get it working

In SQL 2005 i see
Linked Server
InventoryDB
catalog
system catalog
default
table
inventoryTB

I can do
select * from [INVENTORYDB]...[All]

How do i do
select * from linked_server_name.catalog.schema.object_name
I tried [INVENTORYDB].catalog.schema.ALL

Not worked the catalog and schema are defaults.

Thanks
FROM [INVENTORY_PROPERTY].Catalog.dbo.[All]
--linked_server_name.defaultcatalog.schema.object_name

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources