Will I use FE/BE?

[whiterower]

hi, I just wanna ask if i need to split my application into a be/fe. Right I'm thinking that I don't need to spli the database since most of my table resides on our SQL Server. What I did ii convert my db to mde wihtout splitting.Is this the right thing?

 

[Rob.Mills]

Are most or all of your tables on the SQL server? If all then you're better off using an Access Data Project. They're designed specifically for connecting to SQL Server.

 

[whiterower]

I can't since I have queries that use parameters and I already deployed my app..Yes all my tables resides n my SQL server.

What I did was i convert the mdb file to mde and install a copy on each machine..is there any effect that will slow down the apps?

 

[whiterower]

Thanks Pat...I did just that i use parameters on my queries..my question is..is it okay if i convert the mdb into mde and don't have to split the db since all my tables is in my sql server? and i dont have tables in my access db its just queries,modules,reports and forms.

I convert the mdb to mde and distribute it to each users workstation..is this alright?

 

[whiterower]

Thanks Pat for making it clear...i appreciate it

 

[Rich]

What's the advantage of making an MDE?

 

[Rich]

I read that making an MDE makes little or no difference to the speed