It is currently 21 April 2025, 18:37 Advanced search

How to connect to Access database

Questions and answers on how to best use Instant Developer

How to connect to Access database

Postby factotum » 11 September 2013, 14:23

First time trying to use in.de and stumped at the first step trying to connect to an MDB database - got this message:

Pro Gamma Instant Developer
File containing detailed information about the error

Send this file to <mailto:support@instantdeveloper.com>
to technical support

SQL context number: 10308
Connection string: Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=\;Jet OLEDB:System database=C:\Users\Paul\Documents\Alpha Five V12\MDBFiles\alphasports.mdb

Offending command ------------

------------------------------



Dumping ADO Error 1 of 1
Number = -2147467259 (80004005)
Source = Microsoft JET Database Engine
Description = Could not open table 'MSysAccounts' in the workgroup information file.
HelpFile = (null)
HelpContext = 4C57A5
SQLState = 3173
NativeError = -124979060 (F88CF88C)


Any ideas?

Paul
factotum
 
Posts: 15
Joined: 10 April 2013, 14:41

Re: How to connect to Access database

Postby asawyer13 » 11 September 2013, 19:17

I was able to answer this for Paul and get him going.
I
asawyer13
 
Posts: 137
Joined: 10 July 2013, 9:44

Re: How to connect to Access database

Postby factotum » 11 September 2013, 20:06

Thanks Alan :)
factotum
 
Posts: 15
Joined: 10 April 2013, 14:41

Re: How to connect to Access database

Postby g.lanzi » 12 September 2013, 7:57

Now I'm curios :)
What was the problem? Access ULS?
Giuseppe Lanzi
Director of Support services
Pro Gamma S.p.A.
User avatar
g.lanzi
Pro Gamma
Pro Gamma
 
Posts: 3503
Joined: 29 September 2010, 10:24
Location: Bologna

Re: How to connect to Access database

Postby factotum » 12 September 2013, 8:00

I should have used jet and not a direct access type - I wanted to connect to an mdb
I also forgot that you need to take ownership
factotum
 
Posts: 15
Joined: 10 April 2013, 14:41

Re: How to connect to Access database

Postby g.lanzi » 12 September 2013, 9:24

Ok. I've added some more information about the Access ULS enablede databases in this thread http://forum.progamma.com/viewtopic.php?f=7&t=60329 .
Giuseppe Lanzi
Director of Support services
Pro Gamma S.p.A.
User avatar
g.lanzi
Pro Gamma
Pro Gamma
 
Posts: 3503
Joined: 29 September 2010, 10:24
Location: Bologna

Re: How to connect to Access database

Postby factotum » 12 September 2013, 12:54

Thanks again Giuseppe :)
factotum
 
Posts: 15
Joined: 10 April 2013, 14:41


Return to Tips & Tricks

Who is online

Users browsing this forum: No registered users and 24 guests

cron