kodiak385
is using THE INTERNET!!1
- Local time
- Today, 13:51
- Joined
- Jan 25, 2007
- Messages
- 31
So I've got another topic which has been practically beaten to death, but again, I'm having trouble finding my answer for the same reason. I've read up a bit on the advantages of splitting a database for multi-user environments, and while I'm a little nervous about it (having never tried it before), I'm pretty sure that's what I want to do.
The problem I'm running into is when I try to use Access's database splitting wizard, I get an error saying "Subscript out of range," followed immediately by "Invalid Procedure Call or Argument." I've compiled all of my VB and compacted/repaired the database just to be safe, and I'm still having the same issue. I don't know how else to eliminate this error, so I'm thinking in order to split my DB, I'm going to have to do it manually. Given this, I want to check first on here (best. resource. EVER. ) and get a little input before I try to proceed.
If I'm understanding correctly, all it REALLY takes to split a database is to make a copy of it to be the Back End, delete all queries/forms/reports/code, etc. in that DB, delete the tables in the original DB (the new Front End), and link the BE tables to the FE, basing all forms and reports on local queries. Is this right? Is there anything else to keep in mind when splitting the DB?
As more of an afterthought than anything, is there anything the Access DB splitting wizard does that you can't do manually? I just want to make sure I'm not missing something before I move forward tearing my DB a proverbial "new hole." hehe
Any input would be greatly appreciated here. Thanks in advance!
The problem I'm running into is when I try to use Access's database splitting wizard, I get an error saying "Subscript out of range," followed immediately by "Invalid Procedure Call or Argument." I've compiled all of my VB and compacted/repaired the database just to be safe, and I'm still having the same issue. I don't know how else to eliminate this error, so I'm thinking in order to split my DB, I'm going to have to do it manually. Given this, I want to check first on here (best. resource. EVER. ) and get a little input before I try to proceed.
If I'm understanding correctly, all it REALLY takes to split a database is to make a copy of it to be the Back End, delete all queries/forms/reports/code, etc. in that DB, delete the tables in the original DB (the new Front End), and link the BE tables to the FE, basing all forms and reports on local queries. Is this right? Is there anything else to keep in mind when splitting the DB?
As more of an afterthought than anything, is there anything the Access DB splitting wizard does that you can't do manually? I just want to make sure I'm not missing something before I move forward tearing my DB a proverbial "new hole." hehe
Any input would be greatly appreciated here. Thanks in advance!
Last edited: