So I've designed a database for several users using user level security with the older mdb file format. The database is split with the back end on a network drive. I'm looking into making the jump to SQL but I have a few questions about making the jump. Should I be using the accdb or adp file format? Is there a significant difference between the two? I also read that when using an SQL backend the way parameters are passed are a little different, right now in design view on my queries I just have the where clause selected with the criteria being something similar to [Forms]![Customers]![CustomerIDField] , I'm almost certain these things would have to change if I moved to an SQL backend but from reading the resources I've found I'm not sure what changes to make. I'm also aware that this upgrade will mean losing the user level security, is there anyway to emulate something similar to that, perhaps through using windows login ID's?
Jump to SQL
- Thread starter Fasopus
- Start date
