multiuser jet 4.0 db

multiuser jet 4.0 db

Post by beck » Sat, 22 May 2004 07:18:37


How do I setup a MS Jet 4.0 db as multiuser? I've got it working in
single user mode, but I can't find what I'm missing for the multiuser.
I've added the system db (mdw) and get an error "cannot find installable
ISAM". What am I doing wrong? Any help would be appreciated.
Patrick
 
 
 

1. MS OLE DB For Jet 4.0 Question

2. OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server - Could not find installable ISAM

Hi all,

using sql 2008 sp1 32-bit

I'm getting the following error message.

I have a linked server setup to a mdb file, I can query the table fine.
I'm trying to exec the metadata SP and get this only on this table, other
tables I have no problem?

Query:
EXEC sp_columns_ex 'AccessLinkedServer','ProblemTable'

Error:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server
"AccessLinkedServer" returned message "Could not find installable ISAM.".Msg
7311, Level 16, State 2, Procedure sp_columns_ex, Line 283
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider
"Microsoft.Jet.OLEDB.4.0" for linked server "AccessLinkedServer". The
provider supports the interface, but returns a failure code when it is used.

This works fine:
SELECT * FROM AccessLinkedServer...[ProblemTable]

thanks
gv

3. problem in ADO with Microsoft Jet 4.0 OLE DB

4. OLE DB Provider for Jet 4.0

5. Access 2000 DB problems after JET 4.0 SP7 install

6. Not a valid account name or password (MS Jet 4.0 OLE DB Provider)

7. Max connections with JET 4.0 OLE DB driver

8. Missing Jet 4.0 OLE DB Driver?

9. insert rows, Access db, C#, Microsoft.Jet.OLEDB.4.0, autonumber =

10. Use of Jet 4.0 OLE DB and Excel

11. Size and concurrency limits on Jet 4.0 dB engine?

12. deploying an application that uses microsoft jet 4.0 ole db provider

13. BUG-Access 97 db insert via Jet 4.0 using stored procedure fails - any help?

14. Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0"

15. Allow Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' Permission