I started my current project with little to know knowledge of MS Access or writing code with within MS Access so bare with me...
I have a split database, the tables are stored on a file server, the "front end" form is stored on each user's computer. I had my database doing exactly what I wanted from my computer. That is using one form to submit a record (henceforth known as Helpdesk), and use another to manage all submitted records(henceforth known as IMO). It was working perfectly for me. I copied Helpdesk to the individual machines of my users and then began testing it. I ran into a multi user problem where if I had IMO open no user could use Helpdesk to submit new records, or if one user had Helpdesk open and another tried to open it. Knowing nothing about multi user environments I did a little research and found a lot of data on the ADO recordset connection methods and what not. I made a backup of my DB and started the process of converting my DB from DAO to ADO to take advantage of this. after some trial and error, I decided to try some other methods first put and my DB back to DAO, now I get a run time error 3001 "Invalid Argument" when the following code runs:
Set rst = dbHelpdesk.OpenRecordset("Helpdesk", dbOpenDynaset, , dbSeeChanges)
So I guess I have two questions: How can I fix this error, and how can I set up my DB to allow multiple users to access the tables on the file server?
I have a split database, the tables are stored on a file server, the "front end" form is stored on each user's computer. I had my database doing exactly what I wanted from my computer. That is using one form to submit a record (henceforth known as Helpdesk), and use another to manage all submitted records(henceforth known as IMO). It was working perfectly for me. I copied Helpdesk to the individual machines of my users and then began testing it. I ran into a multi user problem where if I had IMO open no user could use Helpdesk to submit new records, or if one user had Helpdesk open and another tried to open it. Knowing nothing about multi user environments I did a little research and found a lot of data on the ADO recordset connection methods and what not. I made a backup of my DB and started the process of converting my DB from DAO to ADO to take advantage of this. after some trial and error, I decided to try some other methods first put and my DB back to DAO, now I get a run time error 3001 "Invalid Argument" when the following code runs:
Set rst = dbHelpdesk.OpenRecordset("Helpdesk", dbOpenDynaset, , dbSeeChanges)
So I guess I have two questions: How can I fix this error, and how can I set up my DB to allow multiple users to access the tables on the file server?
