[Resolved] ADO to current database -- NEW PROBLEM

[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?


*check out Post #4*

[Hack]

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.

[kfcSmitty]

okay, thanks! i hope thats what the problem is

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

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

nevermind, I got it

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

[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...


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

[Hack]

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.