By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,530 Members | 891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,530 IT Pros & Developers. It's quick & easy.

how can i use msaccess database as a multiuser database?

P: 7
Hi Genius,

vanakam

i developed a application with msaccess as a backend and vb6 as a frontend tool, it can work in a stand alone machine.

now i want to convert as multiuser application, at the same time more than one user my access the same table such as billing, payment entry,payment recived entry. how can i implement this one.

pls anybody give idea. pls.............................................

hopefully expect your idea.

annamalai .n
Jul 5 '08 #1
Share this Question
Share on Google+
6 Replies


!NoItAll
100+
P: 296
The two companies I've worked for that did this eventually replaced Access with another solution due to intractable problems with Access as a Multi User Database. While Access has the capability - it is neither refined nor good at it. I would strongly advise against trying this. It is a great single user database for light duty. Get heavy or multi-user - move to something designed for this such as MS SQL, or MySQL. The learning curve is not bad at all.

Des
Jul 6 '08 #2

debasisdas
Expert 5K+
P: 8,127
is the database in server or in your local system ?
Jul 7 '08 #3

P: 7
hai

database is only one location as server

idea pls ......

with regards
annamalai

is the database in server or in your local system ?
Jul 7 '08 #4

P: 7
hai

database at server


with regards
annamalai

hai

database is only one location as server

idea pls ......

with regards
annamalai
Jul 8 '08 #5

lotus18
100+
P: 866
How do you connect your access to vb? Are you using dsn or what?

Just try this:

Make sure that server and the users's pcs are connected then try to make a shortcut icon of the exe file from the server to the user's pc. This will work.

Rey Sean
Jul 8 '08 #6

P: 7
Hi,

ok fine.it coundn't access at the same time. database connected with odbc(dsn)

Example
user 1 and user 2 want to make a bill for diff. customer how it can autogen. then bill number?

which is my need

thanks

with regards
annamalai




How do you connect your access to vb? Are you using dsn or what?

Just try this:

Make sure that server and the users's pcs are connected then try to make a shortcut icon of the exe file from the server to the user's pc. This will work.

Rey Sean
Jul 9 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.