Re: Error No. -2147467259, Error Description: Could not open table 'MSysAccounts' in the workgroup information file

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dear Paul,

I Found the Problem. Can you Imagine what was the problem ? You will
surprise ?

My Spectrum.exe and DefaultData.mdb was in same (D:\Spectrum\Program)
Directory.
As soon as I had copy SPECTRUM.EXE file in other directory and run it then
database has open successfully.

This is the funny problem of Microsoft Visual Studio ?

Now I have further query that if I provide user level rights in Access
Database then it required to copy any database like SYSTEM.MDW with
Application ?

Currently I am copying two database SYSTEM.MDB & DEFAULTDATA.MDB file with
my application. When User Create New Company then I am copy DefaultData.MDB
file in Folder where user select as SPECTRUM.MDB.

If I provide user level rights in DEFAULTDATA.MDB then will transfer to
SPECTRUM.MDB file ?

Please help me.

Thanks again.

Sanjay Shah



"Paul Clement" <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx> wrote in message
news:bgmot2tak70ccfu0tgpjqdsbm0erhl4t1n@xxxxxxxxxx
On Wed, 21 Feb 2007 18:24:12 +0530, "SANJAY SHAH-MICROBRAIN COMPUTERS PVT.
LTD."
<microbrain@xxxxxxxx> wrote:

¤ Dear Paul,
¤
¤ I had tried connection string by providing system database with full
path
¤ then it gives error message 2147467259 - Could Not Find Installable
ISAM.
¤
¤ Please help me.

Make certain that there is a space between Data and Source in your
connection string. Also, if
you're not using database security then remove the User ID, Password and
System Database arguments.

Your connection string should look something like this:

Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\Spectrum\Program\DefaultData.mdb;


Paul
~~~~
Microsoft MVP (Visual Basic)


.

Relevant Pages

  • Re: Access vs SQL
    ... ¤ .mdb file? ... are supplying a "satisfactory" connection string, ... > DAO can connect to any number of database types including Microsoft Access ... So, when you use ODBC, you are not connecting to a JET database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Installable ISAM
    ... When you want to use any data access interface from DAO to ODBC to OLE DB to ADO to ADO.NET you need to set a Connection String that tells the data access interface where to find the database, how to access it and other details used to get connected. ... ¤ utilizes MS access 2003. ...
    (microsoft.public.vb.database)
  • Re: Using a database
    ... ¤ I have a PostgreSQL database on my machine created by an app I ... I would like to read this database and extract some data the ... Second you need a connection string to your database before you can connect. ...
    (microsoft.public.vb.general.discussion)
  • Re: Installable ISAM
    ... Private Sub Form_Load ... ¤ it calls up the MSaccess file which it saves to), ... "my database name definition is ... Could you post your connection string to the database? ...
    (microsoft.public.vb.database)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)