Problem to overcome

[LWCARAB]

I have a database which is open most of the day, I have on online input form which input to the access database but this fails when the database is open and even if I use a second linked database. I need ideas to get around this?

Thanks,

Richard

 

[qdogfball]

not sure what you are really asking.

Are you saying that the database is open, and you want to create a new form for it?

Or are you saying that you have already created a form, but it is not working to let you input data into a table?

 

[LWCARAB]

I have a database which is open always open in the library but I have an html/asp page so that other people in the company can input to the access database in the library BUT when the database is open, the online form cannot save to the database.

 

[GolferGuy]

Sounds to me like the database is being opened without share. At least without share for update. OR, the .asp page is trying to open the database in exclusive (non share) mode. Of course that would not be allowed because the database is already open.

 

[LWCARAB]

how do you make those changes?

 

[GolferGuy]

Try the Access documentation (On line help) and search on share. If the problem is on the web side, try an .ASP forum, or look into options with ADO open to allow sharing.

 

[NigelShaw]

Hi There,

not up to speed with online forms etc but my first instinct would be if the database is already open, then isn't it locked for other entries until the table is closed?

an idea would be to have the info from the asp pooled for a mass update and then have the info collected updated periodically to the table.

it could i guess, be pooled in vb state with unique ids to prevent errors then the code could write to the table at set intervals then clear the code.

like i say, im not familiar with online stuff but that would be the route i would look at if i was faced with this scenario.

NS

 

[LWCARAB]

In the advanced database options, it is marked as shared, but that still doesn't let the asp input to it when it is open.

 

[GolferGuy]

Who ever has the database open from the LAN, is it in a shared mode at that time? Does the asp open the database itself in shared mode? Or is the default for the asp Exclusive?