Recent content by DJanton

Error 3027 - Read-Only Access Yes, after copying to a local pc I can open the access DB no problem. Thank You.

Hi, A major problem here ever since the manager had to restore Novell network software and re-setup the users. Now Access file pops up a message Database or object is read-only (3027). The Access file itself does not show read-only attribute on. The folder where the file resides has all the...

Please help. I'm trying to add new fields to Access form that has many fields already and many of them are over to of each other. How does one get a more clear view what fields are on the form and control them, add new fields, without messing up the whole thing. If you have the answer, please...

Cascading Delete - ADODB Connection FoFa, Thank you for your help. The cascading delete is part of the SQL Table in ItrackTest DB. I know what you mean about the sa connection but I'm not the DB manager here, I'm just following orders if you know what I mean. I do use full names as far as...

FoFa, I ran an MDAC checker and was able to correct most of the version mismatch problems except for one for mkjet.dll file. RE ADO, I'm simply connecting via the ADODB connect string; Connect string = "Provider=SQLOLEDB.1;Data Source=HOSQL1;Initial Catalog=ItrackTest;User ID=sa;" Next...

From what I can see (within the administrative Tools) the ODBC DSN is defined for the DB and the driver is SQLSRV32.dll. I ran a connectivity test directly on the DSN and it shows perfect results. Thank You.

Could not find linked table Hello FoFa, Thank you for the tip to check the MDAC version. My boss is looking into it. As far as Access version it's ACCESS 2000. I'll know shortly if things have improved. Thank You.

Can you solve this one? I'm having very unusual problems with not being able to get VB code in access to work with linked SQL Server tables. For one, I'm able to link all the SQL Server tables to Access DB without a problem. I even tested each link by viewing data in each linked table in...