Access Craters!?!?!?

[Avatarp]

I have linked tables in a database on my hard drive. I have this database on the network as well. When copying the database up to the network it craters if there is a bad data type or any error message in my linked tables. Am I screwed working with Access with a network? What should I do here

[alex_read]

It really depends on how many users and records you're working with in Access, technically, yes it can support working across a network.

Normally it's better practice to use a larger database system which was built for this such as SQL Server if you can get hold of this.

As far as your question on the data type errors etc, normally you would check / validate any entered information in your code before passing this to the database...

If len(txtUserPassword.text) < 20 then
    strSQL = "SELECT * FROM Orders WHERE " & _
    "CustomerID = '" & cstr(txtUserPassword.text) & "'"
End If