Issues saving to Access Database through an Intranet

[Guest]

All,

I am new to putting an access database on an Intranet website and am having
an issue with saving to the database. It is a fairly simple access database
that has some updates and inserts into some tables using ado recordsets.

When I runthe database by clicking on it from the location that it actually
resides on, any updates and inserts are permanently posted to the database.

This same database at this location is accessed through the Intranet. When
I click on the database on our intranet webpage, it seems to make the changes
while I'm in the database, but when I close out, all of the updates and
inserts seem to roll back.

Is there something special that needs to be done so that when the database
is opened through an intranet, that all my changes are kept permanently?

Please email me with any suggestions at: (e-mail address removed)

Thanks,
Andrea

 

[Alex Dybenko]

Perhaps you open mdb in exclusive mode, and updates from web page fails. try
to add error handling there and see what is going on

 

[Guest]

Alex,

Thanks for your response. After a lot of debugging, I figured out that the
problem was that I was using the CurrentProject to set my connection string.
Unfortunately, this holds the path of a temporary internet path and not the
true internet path of where my database resided. After I set the connection
string to a hardcoded path, everything worked fine.

Thanks,
Andrea Wright