Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

I am using same access database table for both web service application and window application in .Net.

But some times i am getting error "Database table is already in use" when i am trying to access table from window application.

can we use single table for both web service and window application? or we can't use same table for both?

can any one give me your opinion on this.

Thanks,
Ranjani Sekar.
Posted

Well...technically, yes, you can.

But I'd advise against it, if possible.
Access is not good with multi user: it works (most of the time) but tends to throw up problems (mostly synchronisation related) if you have more than one user trying to use the file. I've done it, and it works - but it caused so many headaches I'll never do it again!

And a web service would count as one user, and a windows app as another.

If you want more than one program accessing a DB at the same time, you should consider using a proper multi user system, like SQL Server, or MySql.
 
Share this answer
 
Hi
Thank you for your quick reply.

As you said i exactly had synchronization issue. Because of that i can access my access db for some times from my window application and some times i got error.

Once again thank you.

Thanks,
Ranjani Sekar.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900