Access to SQL Server Express ...

[pachjo]

I want to write a small application that will have three to four transacting users and maybe eight enquiry users.

The database will be on a file server in the form of a .mdf file.

The original database schema is in Access format and I want to convert to SQL Server.

I have tried to create the db with VS manually but get errors which I feel may be due to my missing schema info?

So I use the Upsizing Wizard which insists on a SQL Server?

Now I can create the db doing this but it puts it into my SQL Express instance whicih is not want I want.

Can someone let me know if I can create a .mdf file out of a Access database with the table with having the dbo. prefix?

Also if I plonk the said .mdf file on a file server and publish my project with the necessary sql components will this allow a true multi user environment?

Thanks

 

[charles.ajs]

I too have the sane question,
1. How many users can connect to SQL Server Express edition ?
2. How to attach a mdf file to SQL Server express

 

[pachjo]

I have tried to create the db with VS manually but get errors which I feel may be due to my missing schema info?

So I use the Upsizing Wizard which insists on a SQL Server?

Now I can create the db doing this but it puts it into my SQL Express instance whicih is not want I want.

Well I have managed to use the upsizing wizard and ticked all the options for triggers, relations etc and it works ok.

Being in the SQL Express instance makes not problems.

Can someone let me know if I can create a .mdf file out of a Access database with the table with having the dbo. prefix?

Again, it makes no difference. I connect to the database using server explorer and adding a data source etc and all works a treat.

Also if I plonk the said .mdf file on a file server and publish my project with the necessary sql components will this allow a true multi user environment?

Am yet to see how this would work!