[Resolved] ADO to current database -- NEW PROBLEM

Is it possible to link ADO to the MS Access 2002 database I'm using? I tried this before but every once and a while it would say I don't have permissions to write to the table.

I'm sure I have enough permissions, as I tried it on my laptop, but it just doesnt seem to want to work.

Anyone ever encounter this error?


*check out Post #4*

Quote:

---

Originally Posted by kfcSmitty

Is it possible to link ADO to the MS Access 2002 database I'm using? I tried this before but every once and a while it would say I don't have permissions to write to the table.

I'm sure I have enough permissions, as I tried it on my laptop, but it just doesnt seem to want to work.

Anyone ever encounter this error?

---

The only times that I can remember getting that error was when I was trying to open a database that was already open.

okay, thanks! i hope thats what the problem is

also, how would I set the connection string to the current database? Currently I have

VB Code:

cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=H:\JOB\FinancialData2.mdb"

nevermind, I got it :D

VB Code:

cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & application.currentproject.fullname

Now when I try to edit my database it keeps comign up with I do not have exclusive access to the database at this time. And I may not be able to save...


*edit* its gone now, but I didn't do anything. Is there a timeout period for an access database or something?

Quote:

---

Originally Posted by kfcSmitty

Now when I try to edit my database it keeps comign up with I do not have exclusive access to the database at this time. And I may not be able to save...

---

That, again, sounds like an attempt to open an open database. The exclusive rights thing I get alot because I will open the database using Access, then run code that tries to open it. :rolleyes: